Oracle Database 11g Administration Workshop I Release 2 Training

Course Information

This Oracle Database 11g: Administration Workshop I training and certification will help individuals explore the fundamentals of basic database administration.

This course will guide participants of the concepts through a refined combination of structured hands-on practices and cases that will prepare them for the corresponding Oracle Certified Professional exam.

Completion of this training course will enable candidates in:

Installing Oracle Grid Infrastructure.
Creating and managing users.
Installing and configuring an Oracle Database.
Creating and managing storage structures.
Administering the Oracle Database.
Understanding the Oracle database architecture and how its components work and interact with one another.
Performing backup and recovery.

Course Benefits:

Attaining certification of this course will ensure fast, reliable, secure and easy to manage performance. Also, this training will help individuals to optimize database workloads, at lower IT costs and deliver a better quality of service by enabling smooth and rapid consolidation within your Datacenter.

COURSE OUTLINE

1. Exploring the Oracle Database Architecture

Overview of Oracle Database Architecture
Overview of Oracle ASM Architecture
Memory structures
Process Architecture
ASM storage components
Logical and physical storage structures

2. Installing your Oracle Software

Tools Used to Administer an Oracle Database
Oracle Universal Installer (OUI)
Installation: System Requirements
Install Oracle Database Software
Install Oracle Grid Infrastructure
Silent Install

3. Creating an Oracle Database

Plan the Database
Use the DBCA to Create a Database
Password Management
Create a Database Design Template
Use the DBCA to Delete a Database

4. Managing the Oracle Database Instance

Start and stop the Oracle database and components
Access a database with SQLPlus
Use Oracle Enterprise Manager
Modify database installation parameters
Describe database shutdown options
Describe the stages of database startup
Access dynamic performance views
View the alert log

5. Managing the ASM Instance

Start up and shut down ASM instances
Set up initialization parameter files for ASM instance
Administer ASM disk groups

6. Configuring the Oracle Network Environment

Use tnsping to test Oracle Net connectivity
Use Enterprise Manager to create and configure the Listener
Enable Oracle Restart to monitor the listener
Identify when to use shared servers or dedicated servers

7. Managing Database Storage Structures

Storage Structures
How Table Data Is Stored
Anatomy of a Database Block
Tablespaces in the Preconfigured Database
Space Management in Tablespaces
Actions with Tablespaces
Oracle Managed Files (OMF)

8. Administering User Security

Database User Accounts
Predefined Administrative Accounts
Benefits of Roles
Predefined Roles
Implement Profiles

9. Managing Data Concurrency

Data Concurrency
Enqueue Mechanism
Resolving Lock Conflicts
Deadlocks

10. Manage Undo Data

Data Manipulation
Undo Data Versus Redo Data
Transactions and Undo Data
Configure Undo Retention

11. Implementing Oracle Database Auditing

Describe DBA responsibilities for security
Enable standard database auditing
Review audit information
Specify audit options
Maintain the audit trail

12. Database Maintenance

Manage optimizer statistics
Use the Automatic Database Diagnostic Monitor (ADDM)
Manage the Automatic Workload Repository (AWR)
Describe and use the advisory framework
Set alert thresholds
Use automated tasks
Use server-generated alerts

13. Performance Management

Performance Monitoring
Manage Memory Components
Enable Automatic Memory Management (AMM)
Automatic Shared Memory Advisor
Use Memory Advisors
Dynamic Performance Statistics
Troubleshoot and Tuning Views
Invalid and Unusable Objects

14. Backup and Recovery Concepts

Part of Your Job
User Error
Statement Failure
Understanding Instance Recovery
Phases of Instance Recovery
Media Failure
Using the MTTR Advisor
Archive Log Files

15. Performing Database Backups

Backup Solutions: Overview
Oracle Secure Backup
User-Managed Backup
Terminology
Recovery Manager (RMAN)
Configure Backup Settings
Back Up the Control File to a Trace File
Monitor the Flash Recovery Area

16. Performing Database Recovery

Open a Database
Data Recovery Advisor
Loss of a Control File
Loss of a Redo Log File
Data Failures
List Data Failures

17. Moving Data

Describe ways to move data
Create and use directory objects
Use external tables to move data
Use SQL*Loader to move data
General architecture of the Oracle Data Pump
Deploy the Data Pump export and import to move data

18. Working with Support

Use the Enterprise Manager Support Workbench
Work with Oracle Support
Log service requests (SR)
Manage patches

Name

Code

Fee

What Our Trainees Say

very good and great coordination of Mercury Solutions staff for training.
Project Management Professional (PMP)

Sundar V A, Gurgaon

The instructor was good and generated interest in the course
Project Management Professional (PMP)

Chandrabhanoo Chakrabarti, Gurgaon

The CEH contents was good and covered complete syllabus of EC Council and the instructor was great!
CEH V10 ANSI Training

Saleem Tahiri , Gurgaon

Overall excellent and very much positive approach in all ways of professional driving through the training academy and instructor as a very much fabulous gesture to all.
Project Management Professional (PMP)

Gurushankar Thiyakarajan, India

Instructor's knowledge to deliver the training is the best one
VMware vSphere : Install, Configure, Manage [v6.5]

Ranganatha Mukunda, Live Online

The best thing about the program is - the way how the trainer explain the course it was perfect
VMware vSphere : Install, Configure, Manage [v6.5]

Charbel Ziade, Live Online

The best part about the program is Trainers friendly attitude to accommodate all my requests even when some of the requests were not in the course curriculum.
55242A: Microsoft Dynamics 365 Customization and Configuration Training Course

Kunal Waghmare, Gurgaon

The training was great and enjyable, I must recommand other to get training from this institution. The trainer was very skilled and experienced.
ECSA v9 (EC-Council Certified Security Analyst)

Em Pannah, Gurgaon

Good Course for the Security Professional
Certified Information Systems Security Professional

Shailesh Jain , Bangalore

The Training gave us all we needed
CISSP - Certified Information Systems Security Professional

Lokesh , Bangalore

Oracle Database 11g: Administration Workshop I Release 2

Enquire now

-

INR 66753

USD 1336

INR 70092

INR 30739

USD 615

-

QUICK

INFORMATION

5 Day(s) Course

Official Courseware

Certified Trainer

Training

Customize Your Batch

1:1 Training Available on Demand

Course Information

COURSE OUTLINE

WHO SHOULD ATTEND

Pre-requisites

Exam

What Our Trainees Say