SUMMARY:   This class builds on the SQL*Plus and PL/SQL skills for staff who are responsible for creating and administering physical and logical file structures in this powerful relational database product. The class consists of a mixture of lecture and practical exercises. Versions of this class are available for Oracle releases 8i, 9i, & 10g. AUDIENCE:   This class is intended for technical staff who are responsible for creating and administering Oracle databases. Development staff may also benefit from attending this class, to gain an overview of the work of a Database Administrator to aid in developing effective software systems that will be based on Oracle. PREREQUISITES:   Experienced DBA’s who are cross-training from other relational databases, this class can be presented in 3 days. DURATION:   5 Days. APPROACH:   Separate Oracle instance for each student. A Windows 2000/XP workstation or a shared Unix/Linux system will be required. OBJECTIVES:   Students will be able to create and perform basic administration on one or more Oracle database instances on Windows and UNIX systems.. Recommended Next Class: Oracle DBA Performance Tuning COURSE CONTENT:   Database Administration: Memory, process and disk structure; instances and databases; storage structures; backup and recovery; SQL and database tuning; network resource management. Oracle Architecture: Disk structures; parameter files; control files; data files/10g bigfiles; redo log files; password files; segments, extents and blocks; memory areas; shared pool; buffer cache; redo log buffer; processes; database writer; log writer; system monitor; process monitor; archiver; processing overview. Creating a Database: Configuring the operating system; privileged account authentication; creating a parameter file; creating a database; creation commands; post creation actions; data dictionary management. Starting and Stopping Oracle: Instance processing overview; startup command; startup stages; command options; shutdown commands and options; checking instance status; using the alert logs; trace files. Tablespaces, Datafiles and Undo/Rollback Segments: Structure review; tablespace types; system tablespace/10g SYSAUX tablespace; non-system tablespaces; inside a tablespace; locally managed and dictionary managed tablespaces; datafiles; tablespace and datafile management; segments, extents and blocks; undo/rollback segment operations; creating and managing undo/rollback segments. Tables and Indexes: Creating tables; data types; creation and management commands; inside a table; table management (alter, drop, move); partitioned tables; indexes; creating indexes and setting storage criteria; index management. 10g automated storage management. Database Integrity: Creating, altering and dropping constraints; enabling and disabling constraints; constraints and indexes; more on index types; index-organised tables; bitmap indexes; reverse key indexes. User and Resource Management: User accounts overview; resource profiles; system and password limits; profile management; authentication choices - password, operating system, database; users and tablespaces; privileges and roles; creating and managing user accounts; tablespace quotas; data dictionary information. Privileges: User and system privileges; assigning privileges to users; using roles; stored code privileges; invoker and definers rights. Backup and recovery: setting up for backup; archiving logs; complete/incomplete recovery; using RMAN; 9i export/import; 10g Data Pump; 9i flashback mechanisms; 10g flash recovery area. Oracle Best Practices: User and system privileges; assigning privileges to users; using roles; stored code privileges; invoker and definers rights. JR/05