|
Course Outline For:
Oracle Database Administration Fundamentals I
Start learning Oracle Database Administration Fundamentals I right away, Free!
Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems
viewing the lessons, click here Welcome Database Administration Oracle Database Administration Tools More lessons below ...
Would you like to continue? You can have instant access to the rest of this training for just $30.00
|
The Architecture of Oracle  Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts | 
Learn Oracle Database Administration Fundamentals I
