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
Skills Gained
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
Who Can Benefit
Database Administrators
Support Engineer
Technical Administrator
Technical Consultant
Prerequisites
none.
Code:
11g-2DBA
Length:
2 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$1,200
This course is taught by Certified Oracle instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
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
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
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
