Oracle 11g Database Administration Lite

Length: 3 Days
Audience: Database Administrators responsible for the administration of an existing Oracle 11g database. Programmers and Analysts seeking a greater understanding of the Oracle DBMS.
Prerequisites: Oracle 11g SQL Fundamentals. Not required, but helpful would be Oracle 11g PL/SQL Programming.
Overview: This course provides students with an introduction to Oracle 11g database administration. The course provides an overview of the key issues pertaining to the operation and maintenance of an existing Oracle 11g 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 11g environment.
Topics discussed include:
  • Overview of Oracle 11g 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 11g Courses