Oracle Database Administration Fundamentals I
by Gavin Powell
Start the free chapterThis is the second in a series of courses, aimed at preparing the user for Oracle Certification Exam # 1Z0-031. This course will teach Oracle database administration fundamentals; installing Oracle, creating databases, managing objects in the database and more. This course expands on the first course offered by VTC (Introduction to Oracle SQL and PL/SQL). Following courses will include: Oracle Database Administration Fundamentals II and Oracle Database Performance Tuning. To get started, click one of the movie topics below.
Course content
Welcome4 lessons
Database Administration3 lessons
Oracle Database Administration Tools13 lessons
- What are the Tools?5:331 credit or ad
- SQL*Plus3:301 credit or ad
- SQL*Plus Worksheet2:011 credit or ad
- iSQL*Plus2:271 credit or ad
- All the Other Oracle Tools1:421 credit or ad
- Database Configuration Assistant pt. 17:591 credit or ad
- Database Configuration Assistant pt. 26:431 credit or ad
- Oracle Enterprise Manager Console pt. 16:221 credit or ad
- Oracle Enterprise Manager Console pt. 24:551 credit or ad
- The Management Server and the Agent3:031 credit or ad
- Net Configuration Assistant and Net Manager5:391 credit or ad
- Oracle Enterprise Manager Console pt. 34:231 credit or ad
- Oracle Enterprise Manager Console pt. 44:411 credit or ad
The Architecture of Oracle11 lessons
- Oracle Database Architecture3:201 credit or ad
- Memory Structures6:541 credit or ad
- Processes7:191 credit or ad
- Datafiles/Tablespaces/Objects7:591 credit or ad
- Control Files/Logging/Archiving/Recovery6:481 credit or ad
- COMMIT vs ROLLBACK6:221 credit or ad
- Rollback and Undo5:111 credit or ad
- Temporary Sort Space5:391 credit or ad
- How it all Fits Together7:031 credit or ad
- Oracle Managed Files5:451 credit or ad
- Partitioning5:451 credit or ad
Installing Oracle and Creating a Database11 lessons
- The Oracle Installer pt. 14:581 credit or ad
- The Oracle Installer pt. 21:521 credit or ad
- The Oracle Installer pt. 33:271 credit or ad
- Configuration Parameter Files pt. 13:511 credit or ad
- Configuration Parameter Files pt. 27:021 credit or ad
- SQL*Net Configuration Files5:241 credit or ad
- Oracle Optimal Flexible Architecture5:451 credit or ad
- Windows Specifics pt. 13:571 credit or ad
- Windows Specifics pt. 26:271 credit or ad
- Creating a Database with a Script pt. 14:541 credit or ad
- Creating a Database with a Script pt. 24:331 credit or ad
Starting Up and Shutting Down a Database7 lessons
- Connecting to a Database4:541 credit or ad
- STARTUP Command pt. 15:461 credit or ad
- STARTUP Command pt. 25:401 credit or ad
- SHUTDOWN Command pt. 16:511 credit or ad
- SHUTDOWN Command pt. 25:271 credit or ad
- Combining STARTUP and ALTER DATABASE1:341 credit or ad
- The Oracle Enterprise Manager Console1:431 credit or ad
Configuration Parameters5 lessons
DDL and the Physical Database14 lessons
- DDL and the Physical Database?3:541 credit or ad
- The ALTER DATABASE Command2:311 credit or ad
- Looking at the Database5:231 credit or ad
- Changing Datafiles5:191 credit or ad
- Sizing of Datafiles4:151 credit or ad
- Datafiles and Tempfiles4:221 credit or ad
- Control Files7:211 credit or ad
- Logfiles and Archives pt. 14:031 credit or ad
- Logfiles and Archives pt. 26:441 credit or ad
- The ALTER SYSTEM Command pt. 16:141 credit or ad
- The ALTER SYSTEM Command pt. 24:531 credit or ad
- Automated Undo/Manual Rollback pt. 15:451 credit or ad
- Automated Undo/Manual Rollback pt. 22:271 credit or ad
- Metadata Views3:491 credit or ad
DDL and the Logical Database5 lessons
Expanding Database Objects12 lessons
- Tables pt. 13:571 credit or ad
- Tables pt. 23:101 credit or ad
- Tables pt. 34:481 credit or ad
- Indexes pt. 15:381 credit or ad
- Indexes pt. 26:211 credit or ad
- Clusters2:331 credit or ad
- Index Organized Tables1:531 credit or ad
- Sequences2:391 credit or ad
- UNDROP, PURGE and the Recycle Bin1:291 credit or ad
- Partitioning7:061 credit or ad
- Metadata Views pt. 15:581 credit or ad
- Metadata Views pt. 26:181 credit or ad