This Oracle Database 11g: Administration Workshop I and Workshop 11 Release 2 course explores the fundamentals of basic database administration. Expert instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certifications.

Learn To:

  • Understand the Oracle database architecture and how its components work and interact with one another.
  • Install and configure an Oracle Database.
  • Perform backup and recovery.
  • Database Cloning and Refresh
  • Oracle datapump
  • How to patch databases
  • Create and manage users.
  • Managing auditing

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Create an Operational Database

You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup/recovery techniques.

Following are the course contents

1. Oracle Architecture

  • Oracle Instance,Oracle Server,Oracle Database.
  • Memory Structure,Types of memory structures.
  • Oracle Processes, Types of process in database .
  • Background Processes, Types of background process in database.
  • Logical Structure, Detail overview of each logical component in database.
  • Oracle Tablespaces and different types of tablespaces in database.
  • Oracle Database files and different types of database files in database.
  • Oracle Undo and Redo Tablespace (Practicals ).
  • Shared Server Mode in database.
  • Introduction to Cursor Sharing.
  • Realtime Interview Questions & Answers.

2. Rdbms installation

  • How to Create Virtual Machines (Practicals)
  • How to Create Linux Servers (Practicals)
  • Covering Pre-Installation task before database binaries installation (Practicals)
  • Create database creation using DBCA (Practicals)
  • Create database creation manually using scripts (Practicals)
  • Covering Post Installation Tasks (Practicals)
  • Realtime Interview Questions & Answers

3. Backup and Recovery

  • Covering Instance Recovery
  • User managed backup (Practicals)
  • User managed complete recovery (Practicals)
  • Recover from loss of user managed control file(different scenarios Practicals )
  • Recover from loss of user managed tablespace or critical datafile (different scenarios Practicals )
  • Recover from loss of user managed tablespace or non-critical datafile (different scenarios Practicals)
  • Recover from loss of user managed online redo log files (different scenarios Practicals)
  • Recover from loss of user managed undo tablespace or datafile (different scenarios Practicals)
  • User managed incomplete recovery (Practicals)
  • Introduction to RMAN (Recovery Manager Utility)
  • RMAN different types of Backups (Practicals)
  • RMAN different types of commands
  • RMAN Monitoring scripts (Practicals)
  • RMAN Recovery Scenarios (Practicals)
  • User managed complete recovery (Practicals)
  • Recover from loss of RMAN managed control file(different scenarios Practicals)
  • Recover from loss of RMAN managed tablespace or critical datafile (different scenarios Practicals)
  • Recover from loss of RMAN managed tablespace or non-critical datafile (different scenarios Practicals)
  • Recover from loss of RMAN managed online redo log files (different scenarios Practicals)
  • Recover from loss of user managed undo tablespace or datafile (different scenarios Practicals)
  • RMAN managed incomplete recovery (Practicals)
  • How to detect and correct corruption in Oracle database (different scenarios Practicals)
  • RMAN Duplicate for database cloning and refresh (different scenarios Practicals)
  • Realtime Interview Questions & Answers

4. Database Cloning and Refresh

  • What is cloning
  • What is data refresh
  • Difference between Cloning and data refresh
  • database refresh using user managed hot backup (Practicals)
  • database refresh using user managed cold backup (Practicals)
  • database refresh using RMAN managed hot backup (Practicals)
  • database refresh using RMAN managed cold backup (Practicals)
  • Realtime Interview Questions & Answers

5. Oracle datapump

  • Datapump Architecture
  • Datapump Methods
  • Datapump export (Practicals)
  • Datapump import (Practicals)
  • Monitoring Datapump jobs (Practicals)
  • Datapump Jobs Maintenance (Practicals)
  • Datapump different scenarios (Practicals)
  • Realtime Interview Questions & Answers

6. Patching

  • What is a Patch set/Oracle patch set?
  • What are the different types of Patches?
  • What is PSU?
  • How to apply patches manual in databases (Practicals)
  • Realtime Interview Questions & Answers

7. Administering User

  • User Authentication Methods
  • Creation of Oracle Users (Practicals)
  • User Profiles (Practicals)
  • Oracle User related Scripts (Practicals)
  • Oracle User Password Management Policy (Practicals)
  • Oracle User Privileges (Practicals)
  • Oracle User Roles (Practicals)
  • Oracle User privileges related Scripts (Practicals)
  • Oracle User roles related Scripts (Practicals)
  • Realtime Interview Questions & Answers

8. Oracle Database Auditing

  • What is Auditing ?
  • Auditing Parameters in Oracle (Practicals)
  • Auditing Options (Practicals)
  • Auditing Trail (Practicals)
  • What is Fine Grained Auditing (FGA)? (Practicals)
  • Realtime Interview Questions & Answers