Oracle Database 10g Quickstart for DBAs

Day 1

• Lesson 1 : Introduction
• Lesson 2 : Installing the Oracle Database Software
• Lesson 3 : Managing the Oracle Instance

Day 2

• Lesson 4 : Managing Database Storage Structures
• Lesson 5 : Administering User Security
• Lesson 6 : Managing Schema Objects
• Lesson 7 : Managing Data and Concurrency

Day 3

• Lesson 8 : Managing Undo Data
• Lesson 9 : Implementing Oracle Database Security
• Lesson 10 : Moving Data

Lesson 1 : Introduction

• Install, create, and administer Oracle Database 10g
• Configure the database for an application
• Employ basic monitoring procedures
• Move data between databases and files

Lesson 2 : Installing the Oracle Database Software

• Describe your role as a database administrator (DBA), and explain typical tasks and tools
• Plan an Oracle database installation
• Use Optimal Flexible Architecture (OFA)
• Install the Oracle software by usingOracle Universal Installer (OUI)

Lesson 3 : Managing the Oracle Instance

• Start and stop the Oracle database and components
• Use Enterprise Manager (EM)
• Access a database with SQL*Plus and iSQL*Plus
• Modify database initialization parameters
• Describe the stages of database startup
• Describe the database shutdown options
• View the alert log
• Access dynamic performance views

Lesson 4 : Managing Database Storage Structures

• Describe how table row data is stored in blocks
• Define the purpose of tablespaces and data files
• Create and manage tablespaces
• Obtain tablespace information
• Describe the main concepts and functionality of Automatic Storage Management (ASM)

Lesson 5 : Administering User Security

• Create and manage database user accounts
• Authenticate users
• Assign default storage areas (tablespaces)
• Grant and revoke privileges
• Create and manage roles
• Create and manage profiles
  • Implement standard password security features
  • Control resource usage by users

Lesson 6 : Managing Schema Objects

• Define schema objects and data types
• Create and modify tables
• Define constraints
• View the columns and contents of a table
• Create indexes
• Create views
• Create sequences
• Explain the use of temporary tables
• Use the data dictionary

Lesson 7 : Managing Data and Concurrency

• Manage data through the use of SQL
• Identify and administer PL/SQL objects
• Describe triggers and triggering events
• Monitor and resolve locking conflicts

Lesson 8 : Managing Undo Data

• Explain DML and undo data generation
• Monitor and administer undo data
• Describe the difference between undo data and redo data
• Configure undo retention
• Guarantee undo retention
• Use the Undo Advisor

Lesson 9 : Implementing Oracle Database Security

• Describe your DBA responsibilities for security
• Apply the principle of least privilege
• Enable standard database auditing
• Specify audit options
• Review audit information
• Maintain the audit trail

Lesson 10 : Moving Data

• Describe available ways for moving data
• Create and use directory objects
• Use SQL*Loader to load data from a non-Oracle database (or user files)
• Explain the general architecture of Data Pump
• Use Data Pump Export and Import to move data between Oracle databases
• Use external tables to move data via platform-independent files