Enterprise DBA Part 1A: Architecture and Administration

Aims and Objectives
Start up and shut down an Oracle Instance.
Create an operational database.
Manage Oracle database files.
Manage tablespaces segments, extents .and blocks
Manage users, privileges and resources.

Target Audiences
This course is for junior database administrators.

Prerequisites
The delegate should have completed course SPLI,
Introduction to Oracle: SQL and PL/SQL.

Course Content
Module 1: Oracle Architectural Components
Module 2: Getting Started with the Oracle Server
Module 3: Managing an Oracle Instance
Module 4: Creating a Database
Module 5: Data Dictionary Views and Standard Packages
Module 6: Course Contents
Module 7: Maintaining the Control File
Module 8: Maintaining Redo Log Files
Module 9: Managing Tablespaces and Data Files
Module 10: Storage Structure and Relationships
Module 11: Managing Rollback Segments
Module 12: Managing Tables
Module 13: Managing Indexes
Module 14: Maintaining Data Integrity
Module 15: Loading Data
Module 16: Reorganising Data
Module 17: Managing Password Security and Resources
Module 18: Managing Users
Module 19: Managing Privileges
Module 20: Managing Roles