This 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.
WelcomeWelcomePrerequisites for this CourseAbout this CourseTechnet Database Administration ManualsDatabase AdministrationOracle Database Administration? pt. 1Oracle Database Administration? pt. 2The Basic Architecture of OracleOracle Database Administration ToolsWhat are the Tools?SQL*PlusSQL*Plus WorksheetiSQL*PlusAll the Other Oracle ToolsDatabase Configuration Assistant pt. 1Database Configuration Assistant pt. 2Oracle Enterprise Manager Console pt. 1Oracle Enterprise Manager Console pt. 2The Management Server and the AgentNet Configuration Assistant and Net ManagerOracle Enterprise Manager Console pt. 3Oracle Enterprise Manager Console pt. 4The Architecture of OracleOracle 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 DatabaseThe 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 DatabaseConnecting 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 ParametersWhat 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 DatabaseDDL 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 DatabaseWhat is the Logical Database?
Tablespace Management pt. 1
Tablespace Management pt. 2
Tablespace Management pt. 3
Metadata Views
Expanding Database ObjectsTables 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 AdministrationTypes of Users
Grants and Revokes
Create and Alter User Syntax
Administration Users
Database Auditing
SchedulingThe DBMS_JOB Package
Job Scheduling in Oracle
Scheduling/Executing Jobs in Windows and Unix
UtilitiesExport
Import
SQL*Loader
ORAPWD and ORADIM
Built-In PackagesSupplied Packages
Scripting for AutomationSome Example Scripts
Click here to find out more about the Oracle Database Administration Fundamentals I Training CD 
