Hello, I spent 8 years teaching "Essentials of Oracle For Database Administrators" at the University of California at Berkeley. During that time I developed this tutorial on Oracle database administration along with the books:
"Oracle Database Administration On Unix Systems" and "Oracle Database Administration On Windows NT"
You will need MicroSoft PowerPoint to view the presentation
Lecture 1 - Introduction To Database Management
Systems:
Covers the relational database from a historical
perspective. Introduce the Oracle RDBMS and the various tools that make up the
Oracle offering. A brief explanation of the various Oracle tools and
applications. Lect1.pps
Lecture 2 - Oracle RDBMS Architecture - System
Installation:
The architecture of the UNIX operating system is
discussed. The various Oracle processes, memory and data structures are
described. The relationship between the data structures and the UNIX operating
system is described. Covers the installation of Oracle on the Windows and UNIX
platforms. Lect2.pps
Lecture 3 - End User Management and Security:
The various
system administration tasks that need to be performed to set up the correct
environment for the installation. The topics will include manual database
creation, adding users, controlling access (security), starting and stopping the
database. Lect3.pps
Lecture 4 - Client Server
Communications:
Data communications architectures are covered.
The OSI model will be described and related to the implementation of client
server systems using Oracle’s NET8. Various installation and debug issues are
covered. Lect4.pps
Lecture 5 - Data Loading Plus Backup and
Recovery:
Introduction to the basic DBA task of loading data into
the database. The reader will also be introduced to various database backup and
recovery techniques. Lect5.pps
Lecture 6 - Introduction to SQL
and PL/SQL
programming:
The reader is introduced to the Oracle's procedural
extension to SQL, PL/SQL. Topics include creating and debugging database
triggers and procedures using PL/SQL. Intro_sql.pps
and Lect6.pps
Lecture 7 - Database Performance Aanalysis And
Tuning:
Show the reader how collect and interpret the database
performance statistics and use them to tune the RDBMS. This section covers both
system tuning and SQL statement tuning. Lect7.pps
Lecture 8 - Application Development For
DBA’s:
Introduction to application devvelopment. Entity
relationship modeling (ER) and its relationship to application development,
Defining database business rules using constraints. Estimating system storage
requirements. Lect8.pps
Lecture
9 - Backup and Recovery:
Introduction
to Oracle logical and physical backup and recovery. Includes file
level and block level backup and recovery using Recovery Manager
(RMAN) Bkup_recv.pps
Lecture 10 - Database High
Availability:
High
availability solutions are covered in this section. Topics include replication,
RAC, ASM and Standby Database Lect_ha.pps
and Lect_asm.pps
Email me if you have any questions..........Lynnwood Brown