ATI's Oracle 9i DBA Fundamentals I course

Summary: This course provides the new DBA with the background and tools needed to install and patch Oracle software and set up, operate, and manage Oracle databases. Course covers Oracle9i, Release 1 and 2. Prerequisites: SQL and PL/SQL for Oracle9i or comparable experience is required. Who Should Attend: Prospective DBAs, including database operators and application designers and developers, should attend this course. Benefits of Attendance: Upon completion, students will be able to: start up and shut down an Oracle instance and database; create an operational database; manage physical and logical storage; manage users, privileges, and resources; manage undo and redo data; manage database objects; and manager database storage. Course Outline: Chapter 1: Oracle Architectural Components Using the Universal Installer Describing the Oracle Instance and The System Global Area Describing the Oracle Database Structure Chapter 2: Oracle Tools Using SQL*Plus Using Oracle Enterprise Manager Tools Chapter 3: Managing an Oracle Instance Creating and Modifying Initialization Parameter File Starting and Stopping Instance Opening and Closing a Database Monitoring ALERT Log and Trace Files Chapter 4: Creating a Database Creating and Dropping a Database Creating Tablespaces Creating Users Chapter 5: Data Dictionary Views and Standard Packages Creating the Data Dictionary Querying the Dictionary Views Creating the PL/SQL Environment Chapter 6: Maintaing Control Files and Redo Logs Recreating and Relocating Control Files Creating Redo Log Groups and Members Dropping, Moving, and Renaming Redo Logs Querying the Data Dictionary for Information about Control Files and Redo Logs Chapter 7: Managing Undo Data Understanding the Purpose of Undo Data Managing Undo Data Chapter 8: Managing Tablespaces and Datafiles Planning File Locations to Optimize Database Performance Creating, Altering, Coalescing, and Dropping Tablespaces Adding, Renaming, and Relocating Datafiles Chapter 9: Storage Structures and Relationships Describing the Logical Database Structure Understanding Block Space Use Understanding Row Chaining and Migration Querying the Data Dictionary for Information About Storage Structures and Relationships Chapter 10: Managing Rollback and Temporary Segments Creating, Sizing, and Shrinking Rollback Segments Creating Temporary Tablespace Assigning Temporary Tablespace to Users Using Temporary Tablespaces Chapter 11: Magaing Tables Creating, and Altering Tables Dropping and Truncating Tables Analyzing Tables Querying the Data Dictionary for Information about Tables Chapter 12: Managing Indexes Selecting Correctly From Among Index Types Creating, Altering and Dropping Indexes Querying the Data Dictionary for Information about Indexes Chapter 13: Maintaing Data Integrity Creating, Enabling, Disabling and Dropping Constraints Querying the Data Dictionary for Information about Data Integrity Chapter 14: Loading and Reorganizing Data Using Conventional Path and Direct Path Loading Using the EXPORT and IMPORT Utilities Chapter 15: Managing Users, Profiles, Roles, and Grants Creating, Altering, Dropping Users Creating and Using Profiles Using Password Verification Granting System and Object Privileges Creating and Using Roles Chapter 16: Using Globalization Support Choosing Character Set and National Character Set for a Database Specifying the Language-Dependent Behavior Tuition: Tuition is $2500 per person at one of our scheduled public courses. Onsite pricing is available. Government personnel qualify for reduced rates. Please call us at 410-956-8805 or send an email to ati@aticourses.com. Register Now Without Obligation