CSCI 379 - Fall 2004

Oracle Enterprise DBA - Part 1A: Architecture and Administration featuring Oracle 9i

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 Using Data Dictionary and Dynamic Performance Views 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 Undo Data 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 Managing Password Security and Resources Lesson 14
Before Attending Fourteenth Class Managing Users Lesson 15
Before Attending Fifteenth Class Managing Privileges Lesson 16
Before Attending Sixteenth Class Managing Roles Lesson 17
Before Attending Seventeenth Class Auditing Lesson 18
Before Attending Eighteenth Class Loading Data into a Database Lesson 19
Before Attending Eighteenth Class Using Globalization Support Lesson 20