Oracle Database 11g: 2 Day DBA

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

course content details

	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