Oracle Database 11g: 2 Day DBA

 Oracle University provides a downloadable eKit containing the training materials for this course.

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

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Instruction Language
View Schedule	Instructor-Led Training	US$ 1,200	2 Days	English	English
View Schedule	Live Virtual Class	US$ 1,200	2 Days	English

 

Note: To have a more personalized experience, we invite you to: Log In!

Audience:

• Database Administrators
• Technical Administrator
• Technical Consultant
• Support Engineer

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