Oracle Database Administration Fundamentals I
Training
Provided by The Virtual Training Company
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.
|
|
||||||||
Oracle Database Administration Fundamentals I
Welcome
- Welcome
- Prerequisites for this Course
- About this Course
- Technet Database Administration Manuals
Database Administration
- Oracle Database Administration? pt. 1
- Oracle Database Administration? pt. 2
- The Basic Architecture of Oracle
Oracle Database Administration Tools
- What are the Tools?
- SQL*Plus
- SQL*Plus Worksheet
- iSQL*Plus
- All the Other Oracle Tools
- Database Configuration Assistant pt. 1
- Database Configuration Assistant pt. 2
- Oracle Enterprise Manager Console pt. 1
- Oracle Enterprise Manager Console pt. 2
- The Management Server and the Agent
- Net Configuration Assistant and Net Manager
- Oracle Enterprise Manager Console pt. 3
- Oracle Enterprise Manager Console pt. 4
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
About The Training Provider: The Virtual Training Company
The Virtual Training Company - The Virtual Training Company started in California's Silicon Valley in 1996.
VTC grew quickly over the next three years and relocated first in 1999 to the beautiful town of Winchester, Virginia; and six years later to Stephens City, Virginia.
The company was founded by British born Mark Vernon who started producing CD-based training for Apple software. The format on the CDs - narrated...
