Oracle Database 11g: 2 Day DBA

What you will learn

The goal of this course is to teach Database Administrators how to install the Oracle Database 11g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required task. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 11g. This course is targeted towards Database Administrators of small to medium sized businesses.

Learn To:
  • Install Oracle Database 11g software and create a database
  • Use Enterprise Manager Database Control to manage the database
  • Manage database storage structures and schema objects
  • Administer users and security
  • Back up and recover the Oracle database
  • Monitor the database and use the Advisors
Audience
 Database Administrators
Support Engineer
Technical Administrator
Technical Consultant

Course Objectives
 Install Oracle Database 11g
Create a database
Use Enterprise Manager Database Control
Configure and manage the Oracle Network environment
Manage database storage structures
Administer users and security
Manage schema objects
Back up and recover the database
Monitor the database
Use the Advisors
Use the Support Workbench
Manage the Oracle Database software

Course Topics
Overview of Oracle Database Administration
 Structure of a Relational Database
SQL
Components of an Oracle Instance and Database
Basic Tasks of an Oracle DBA
Tools Used to Administer an Oracle Database

Installing Oracle Database and Creating the Database
 Using the Oracle Universal Installer to Install the Oracle Database Software
Using DBCA to Create a Database
Using DBCA to Manage Templates

Using Oracle Enterprise Manager Database Control and SQL*Plus
 Overview of Administering the Database Using Enterprise Manager
Starting the Enterprise Manager Console Process
Granting Enterprise Manager Administrative Privileges
Setting Enterprise Manager Preferred Credentials
Using SQL*Plus to Access Your Database

Configuring the Oracle Network Environment
 Tools for Configuring and Managing the Oracle Network
Using the Enterprise Manager Net Services Administration Page
Managing the Oracle Net Listener with Enterprise Manager
Using the Listener Control Utility
Oracle Net Naming Methods
Using Enterprise Manager to Configure Local Naming
Using Oracle Net Manager to Configure Local Naming

Managing the Oracle Instance
 Oracle Instance Management
Starting the Instance and Opening the Database
Viewing and Modifying Initialization Parameters
Managing Memory Components
Viewing the Alert Log

Managing Database Storage Structures
 Oracle Database Structures
Multiplexing the Redo Log
Enlarging the Database
Creating, Modifying, and Dropping Tablespaces
Reclaiming Space in Your Tablespace
Managing Undo Data
Using the Undo Advisor to Compute the Minimum Undo Tablespace Size

Administering Users and Security
 Overview of Users and Security
Creating, Modifying, and Dropping Users
Unlocking a User Account and Resetting the Password
Setting the Password Policy
Administering Privileges and Roles

Managing Schema Objects
 Creating, Modifying, and Dropping Tables
Understanding Data Integrity and Defining Constraints
Viewing the Contents of a Table
Creating and Dropping Indexes
Managing Views
Managing Program Code Stored in the Database
Managing Access to Schema Objects
Loading Data

Performing Backup and Recovery
 Backup, Restore, and Recovery Concepts
Configuring the Database for Backup and Recovery
Configuring Backup Settings
Backing Up the Database
Using the Oracle-Suggested Backup Strategy
Performing Backup Maintenance Tasks
Using Oracle Advised Recovery to Recover the Database
Performing Flashback Table and Flashback Drop

Monitoring the Database and Using the Advisors
 Monitoring General Database State, Workload, and Performance
Setting Metric Thresholds
Setting Up Direct Alert Notification
Viewing ADDM Performance Analysis and Responding to Findings
Using the SQL Tuning and SQL Access Advisors
Configuring the Automatic SQL Tuning Advisor
Viewing Automatic SQL Tuning Results

Investigating, Reporting, and Resolving Problems
 Using the Enterprise Manager Support Workbench
Workflow for Investigating, Reporting, and Resolving a Problem
Performing the Tasks to Investigate and Report a Critical Error

Managing Oracle Database Software
 Understanding Software Management and Patch Releases
Patching Oracle Database Software
Using the Database Upgrade Assistant to Upgrade the Database