Syllabus for dbm 438______________________-- ----------------------- by Prof Timothy Ramteke DBM-438: Database Administration with Lab Lecture Hours : 3 Lab Hours : 2 Credit Hours : 4 Description: Students are introduced to a variety of database administration topics, including capacity planning, database management system (DBMS) architecture, performance tuning, backup, recovery and disaster planning, archiving, reorganization and defragmentation. Prerequisite: DBM-405 Textbook: Oracle 10g Database Administrator: Implementation and Administration by Carol McCulloough-Dieter Thompson Course Technology ISBN 0-619-15900-6 Possible Reference: Oracle Essentials 3/e Rick Greenwald, Robert Stackowiak and Jonathan Stern O'Relly Publishers 0-596-00585-7 Web Sites: ora-code.com :DOCJAR to decode error codes asktom.oracle.com :Reference Site Schedule: --------------------------------------------------- Chapter Topic ------- ----- 1 Oracle Architecture 2 Tools 3 Creating a database 4 Data Dictionary 5 Redo Log Files 6 Storage COncepts 7 Tablespaces 11 Uses 12 Privileges 13 Roles