CSCI 397C or CSCI 379

Oracle 8i Database Administration 

or 

Enterprise DBA - Part 1A: Architecture and Administration

Reading Assignments and Related Course Notes

Reading Assignment Topic from Oracle 8 DBA Course Manuals Oracle Course Manuals and Notes on Web
Before Watching First Archived Class Oracle Architectural Components Lesson 1
Before Watching First Archived Class Getting Started with the Oracle Server Lesson 2
Before Watching Second Archived Class Managing an Oracle Instance Lesson 3
Before Watching Third Archived Class Creating a Database Lesson 4
Before Watching Fourth Archived Class Creating Data Dictionary Views and Standard Packages Lesson 5
Before Watching Fifth Archived Class Maintaining the Control File Lesson 6
Before Watching Sixth Archived Class Maintaining Redo Log Files Lesson 7
Before Watching Seventh Archived Class Managing Tablespaces and Data Files Lesson 8
Before Watching Eighth Archived Class Storage Structure and Relationships Lesson 9
Before Watching Ninth Archived Class Managing Rollback Segments Lesson 10
Before Watching Tenth Archived Class Managing Tables Lesson 11
Before Watching Eleventh Archived Class Managing Indexes Lesson 12
Before Watching Twelfth Archived Class Maintaining Data Integrity Lesson 13
Before Watching Thirteenth Archived Class Loading Data Lesson 14
Before Watching Fourteenth Archived Class Reorganizing Data Lesson 15
Before Watching Fifteenth Archived Class Managing Password Security and Resources Lesson 16
Before Watching Sixteenth Archived Class Managing Users Lesson 17
Before Watching Seventeenth Archived Class Managing Privileges Lesson 18
Before Watching Eighteenth Archived Class Managing Roles Lesson 19
Before Watching Eighteenth Archived Class Using National Language Support Lesson 20