NORTHERN VIRGINIA COMMUNITY COLLEGE

ANNANDALE CAMPUS

COMMUNITY EDUCATION

 

Course Title :  ORACLE DATABASE ADMINISTRATOR

Cover Versions 10g  and 11g

 

 

 

Instructor ; Hung Vu     (W) (202) 283-8793 ( C) (202) 498 9785 (C) (703) 835-0555

email : hvu@nvcc.edu

home page : http://www.nvcc.edu/home/hvu

 

 

Class Description:

Learn the fundamental features of Oracle Database Administration. Topics covered include identifying the main structure and functionality of the Oracle Engine, Oracle 11g, examining physical file structures that make up an Oracle database, starting up and shutting down, creating an Oracle instance and managing users, roles and Oracle tablespaces. Emphasis will be placed on DBA duties and tools, Oracle Database Administration Features such as identifying the main structure and functionality of an Oracle Instance, unloading and loading data using Oracle SQL statements and the SQL LOADER utility and external tables. Classical Data Export Utility and Import Utility, new Data Pump Export and Import Utilities, setting up of an audit trail and basic tuning are also covered. Database cold and hot backup recovery strategy will be discussed and practiced.

 

 

Student Assessment:

 

                Students will be awarded  4.0  CEU after class completion

                Attendance requirements : At least 90% of lecture

 

                               

               

Course Prerequisite :

 

                Some experience with Oracle SQL and PLSQL

 

Course Methodology :

 

                This course covers advanced features of Oracle Database Administrator.  Lectures and extensive examples will be presented.  Hands-on-labs will be used to consolidate material covered.

 

 

Course Materials:

 

                Handouts and Labs prepared by instructor

 

Reference Book :  Oracle Database 11g DBA HANDBOOK

                                    By Bob Bryla and Kevin Loney, Oracle Press ISBN 978-0-07-149663-6

                                   


 

CLASS SCHEDULE

 

Week 1 :                Session 1 & 2:

CHAPTER 1 : Getting Started with the Oracle Structure .          

Oracle Database Architecture Overview

 

                                                SGA

                                                Background Process

                                                Different kinds of database files

                                                Logical Structure

Physical structure

 

CHAPTER 9: Database Security and Auditing

 

User Info

                                                Object Privileges

                                                System privileges

                                                Privileges information : Data Dictionary

                                                Roles

                                                Profile

 

Practicing Exercise 1 : Create User

                                                Practicing Exercise 2 : Create Role

                                                Practicing Exercise 3 : User Info

               

                               

Week 2 :                Session 3 & 4 :

                                                CHAPTER 11 : Backup and Recovery

               

Export / Import

                                              Create a new Instance

                                                Load and Unload data :

 

                               

Practicing Exercise 4 : Export Import

                                                Practicing Exercise 5 : Relocating Index with import /export Utilities

                                                Practicing Exercise 6 : Oracle Instance

               

 

Week 3 :                Session 5 & 6 :

 

                                                CHAPTER 11: Backup and Recovery          

Oracle Database Auditing and Backup

                                               

Triggers

                                                Audit Trail

Data Loading

 

Practicing Exercise 9 : Audit Trail

                                                Practicing Exercise 10 :  Cold Backup

                                                Practicing Exercise 10 : Cold Backup and Recovery

                                                Practicing Exercise 11 : Hot Backup and recovery

               

                               

                                                                               


 

Week 4 :                Session 7  & 8 :

CHAPTER 7 : Managing Transaction with Undo Tablespace

 

Oracle Database External  Tables and Flashback

                                                User Objects

Database Structures

 

                                                CHAPTER 1 : Getting Started with the Oracle Structure

CHAPTER 4 : Physical Database Layout

 

Practicing Exercise 12 : User Objects

Practicing Exercise 14 :Managing Tablespace

                                                Practicing Exercise 15 : Database Structure Review

               

Week 5 :                Session 9 & 10 :

CHAPTER 6 : Monitoring Space Usage

 

Oracle External Table and Flashback

                                                Data Pump

External Tables and Flashback

 

Practicing Exercise 16 : External tables

                                                Practicing Exercise 17 : Flashback

                                                Practicing Exercise 13 : SQL Execution Plan

 

               

: