Oracle 11g R2 Core DBA Online Training

Oracle 11g R2 Core DBA Course Syllabus

1. Introduction

1. What is DBA?
2. Why a Company needs a DBA?
3. Roles & Responsibilities of DBA
4. Identify the oracle product
5. Oracle Architecture
6. Physical and Logical Phase of Database

2. Installing oracle database 11g software

1. System requirements.
2. Redhat Linux Installation
3. Install software with the Oracle Universal Installer on Linux Platform
4. Identify System Requirements
5. Discuss Oracle Base
6. Discuss Oracle Home
7. Configure Ms Windows Installation
8. Prerequisite Checks and Fixup Utility

3. Exploring The Oracle Database  Architecture: General

1. More About Database Instances
2. What is Instance and SGA
3. General Database Architecture
4. Instance Background Processes
5. Discuss about New Feature Parameters
6. About PGA and Server Process

4. Exploring The Oracle Database Physical Architecture:

1. Discuss about Control files
2. How to manage the Control files
3. Multiplexing the Control files
4. Multiplexing the online redo log files
5. Brief  about online redo log files.
6. More About Datafiles concepts
7. Brief About Paramter files
8. Discuss about Password files.
9. How to create spfile and pfile
10. What is spfile?
11. Difference between spfile and pfile

           
5. Create an oracle database

1. Database Configuration Assistant(DBCA)
2. Create A New Database
3. Configure An Existing Database
4. Drop A Database
5. Manually Create A Database
6. More About The Database Files

6. Manually Starting and Stopping Database Services

1. Starting and Stopping Database Control
2. Different Startup Modes
3. Different Shutdown Modes
4. Starting and Stopping The Listener
5. Sysdba

7. Manage Database Storage Structures: Tablespaces

1. What are segments?
2. What are extents?
3. What is Blocks?
4. Estimation of  Extents
5. Dictionary Managed Table space
6. Locally Managed Table space
7. About Tablespaces
8. Tablespace Management
9. Autoextend Options
10. Drop Tablespace
11. Alter Tablespace
12. Tablespace Encryption

8. Manage Database Storage Structures: Advanced Tablespaces

1. More About Temporary Tablespaces
2. Using V$Sort_Segment
3. About Temporary Tablespace Groups
4. Temporary Groups
5. More About Permanent Tablespaces
6. About Database_Properties
7. More About Bigfile Tablespaces
8. More About The Sysaux Tablespace

9. Manage Database Storage Structures:

1. Managing Data Files
2. Managing Temp Files
3. Enable Oracle-Managed Files (OMF)
4. Renaming a data file
5. Temporary Groups

10. Managing Undo Data

1. About Undo Space Management
2. Configure Undo Management
3. Undo_Management
4. Undo_Tablespace
5. Undo_Retention
6. Guarantee Undo Retention
7. Monitor Undo Space
8. Use The Undo Advisor

11. Security: Administering User Security

1. Create and manage database user accounts
2. Create and manage roles
3. Grant and revoke privileges
4. Control resource usage by using Profiles
5. Auditing Of Database Activity
6. Audit_Trail Parameter
7. Enhanced Default Security Settings
8. Create and Manage Database Accounts
9. Grant and Revoke Database Privileges
10. Resource Limits Via Profiles
11. Alter Profile
12. Drop Profile

12. Oracle Net Services

1. Understand Oracle Net concepts
2. Use Oracle Net Manager to create and configure listeners
3. Use the listener control utility to control the Oracle Net Listener
4. Start and stop Listener concepts
5. Listener.ora
6. Tnsnames.ora
7. Concept about Database Links
8. Use the Oracle Net Manager to configure client and middle-tier connection
9. Use TNSPING to test Oracle Net connectivity

13. Logical Backup

1. Introduction Data pump (expdp, impdp)  Utilities
2. Exporting/Importing Tables
3. Exporting/Importing Schemas
4. Exporting/Importing Table space
5. Exporting/Importing Database
6. Transportable Table space within & across the database and platforms
7. Discuss New features concept 11g

14. Oracle Backup & Recovery (User Managed)

1. Introduction
2. Design, Testing, Implementation Strategies
3. Offline(cold)/Online(hot) backups
4. Performing Complete Recovery
5. Performing Incomplete Recovery

15. Oracle Backup & Recovery (System  Managed: RMAN)

1. Introduction
2. RMAN Architecture & Rman commands
3. Configuration
4. Setting up Catalog
5. Online/Offline Backup using RMAN
6. Backups Options
7. Incremental Backups,
8. Scripts,
9. Complete Recovery
10. Incomplete Recovery
11. Table Space Point in Time Recovery (TSPITR)
12. Disaster Recovery
13. Recovery of Corrupted DB-Blocks
14. RMAN 11g new features

           
16. Cloning & Refresh

1. Database Refresh Using RMAN
2. Database refresh Using Manual
3. DB refresh Using Expdp and Empdp
4. Migration Using Expdp and Impdp
5. Migration Using Rman

17. Patching Activity

1. Database Patch Management Introduction
2. Applying Interim and Patch set Patches
3. Patch History & Documentation

18. Oracle Performance Tuning

1. Why Tuning required?
2. Types of Tuning
3. Proactive Vs Reactive Tuning
4. Tuning through effective DB Configurations
5. Health Management/Periodical Checkup
6. table Defragmentation

19. Introduction to Oracle Real Application Clusters

1. What is a cluster?
2. Types of clustering Technologies
3. Advantages of RAC over the standalone databases

Certification

Certification assistance provided with proper guidance and certification notes.