CSCI 379 - Fall 2002

Oracle Enterprise DBA - Part 1A: Architecture and Administration

Reading Assignments and Related Course Notes

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