Oracle DBA Fundamentals I CD Training (CBT)

Duration: 8 hrs

This Oracle training course tutorial is aimed at preparing the user for the Oracle Certification Exam # 1Z0-031.

This tutorial will teach Oracle database administration fundamentals; creating databases, installing Oracle, managing objects in the database and much more.

Welcome
Welcome
Prerequisites
About
Technet Database Administration Manuals
Database Admin
Oracle Database Administration? part 1
Oracle Database Administration? part 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 part 1
Database Configuration Assistant part 2
Oracle Enterprise Manager Console part 1
Oracle Enterprise Manager Console part 2
The Management Server and the Agent
Net Configuration Assistant and Net Manager
Oracle Enterprise Manager Console part 3
Oracle Enterprise Manager Console part 4
The Architecture
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 in Oracle
Installation of Oracle and Creating a Database
The Oracle Installer part 1
The Oracle Installer part 2
The Oracle Installer part 3
Configuration Parameter Files part 1
Configuration Parameter Files part 2
SQL*Net Configuration Files
Oracle Optimal Flexible Architecture
Windows Specifics part 1
Windows Specifics part 2
Creating a Database with a Script part 1
Creating a Database with a Script part 2
Starting Up and Shutting Down a Database
Connecting to a Database
STARTUP Command part 1
STARTUP Command part 2
SHUTDOWN Command part 1
SHUTDOWN Command part 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 part 1
The Parameters and What They Do part 2
The Parameters and What They Do part 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 part 1
Logfiles and Archives part 2
The ALTER SYSTEM Command part 1
The ALTER SYSTEM Command part 2
Automated Undo/Manual Rollback part 1
Automated Undo/Manual Rollback part 2
Metadata Views
DDL and the Logical Database
What is the Logical Database?
Tablespace Management part 1
Tablespace Management part 2
Tablespace Management part 3
Metadata Views
Expanding Database Objects
Tables part 1
Tables part 2
Tables part 3
Indexes part 1
Indexes part 2
Clusters
Index Organised Tables
Sequences
UNDROP, PURGE and the Recycle Bin
Partitioning
Metadata Views part 1
Metadata Views part 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