Oracle 10g Database Administration Lite

Length: 3 Days
Audience: Database Administrators responsible for the administration of an existing Oracle 10g database. Programmers and Analysts seeking a greater understanding of the Oracle DBMS.
Prerequisites: Oracle 10g SQL & SQL*Plus. Not required, but helpful would be Oracle 10g PL/SQL Programming.
Overview: This course provides students with an introduction to Oracle 10g database administration. The course provides an overview of the key issues pertaining to the operation and maintenance of an existing Oracle 10g database. The course includes discussions of database design, administration, and operation of the database. The Data Dictionary is examined to create an awareness among participants of the wealth of system information available to the informed user of the system. Dynamic performance tables are also explored to provide access to additional information about the database.
Although this course is intended for the workgroup administrator, it is also suitable for an enterprise database administrator. Some topics are covered briefly so as to provide only an awareness of key features without dwelling on the details of these features. The material presented is also useful for application developers who wish to better understand the Oracle 10g environment.
Topics discussed include:
  • Overview of Oracle 10g Architecture
  • Memory Structures and Processes
  • Relationships Between Database Objects
  • User Management and Database Security
    • Creating Users and Profiles
    • Creating Roles
    • Granting Roles and Privileges
  • Defining Database Objects
    • Tablespaces and Datafiles
      • Oracle Managed Files
      • Dictionary-Managed
      • Locally-Managed
    • Tables
      • Datatype Considerations
      • Table and Column Constraints
      • Deferred Integrity Constraint Checking
      • Temporary Tables
    • Indexes
      • B-Tree Indexes
      • Bitmapped Indexes
      • Function-Based Indexes
      • Guidelines for Creating Indexes
    • Clusters
    • Views
    • Sequences
    • Synonyms
  • Oracle Utilities
    • SQL*Loader
    • Import & Export
    • Datapump Import & Export
  • Storage Management
    • Data Block Structure
    • Chained and Migrated Rows
  • Overview of Client-Server Architecture
  • Oracle's Data Dictionary
Back to Oracle 10g Courses