Oracle DBA Training/DBA Classroom Training/DBA Online Training

Oracle DBA Training

 

Oracle DBA Training program with 100% COMPLETE PRACTICAL and REAL-TIME subject. Course starts from the Basics of PL/SQL to Intermediate concepts like ARMAN Backups to Advanced concpets like RAC and Indepth Tuning Techniques.
Course includes Resume Guidance, Interview and Certification Guidance. Register Today

 

Schedules & Timings

 

 Training Modes:   Online / Classroom / Video
   
 Training Silos: Fast-Track / One-One / Weekend

 * Job Support Available

Register Today 

 

 

  Trainer Name Exp Details
  1   Mr Satish 7+ Years   Profile
       
  2   Mr Suresh 12+ Years   Profile
 
Hadoop Training - Highlights
Register Today 

 

  Completely Real-time and Practical

  Introduction to Database Management Systems

  Oracle Database Architecture

  Starting & Stopping Oracle Database

  Managing Tablespaces & Data Files

  Patching Oracle Applications

  User Managed (Manual) Backup and Recovery

 

One Real-Time Project

 



 

 

Oracle DBA Training Course Content

Oracle DBA Training

Module: I


Ch 1: Introduction to Database Management Systems
  • What is Database? Why Database?
  • Major Databases and Database Vendors
  • Roles and Responsibilities of DBA
Ch 2: Oracle Database Architecture
  • What is Database Instance?
  • Memory Structures – SGA, PGA
  • Background Processes
  • Server Processes
  • Database Files
  • Physical & Logical Structures
Ch 3: Installing Oracle Database Software
  • Planning for Oracle Database Software Installation
  • Understanding Oracle Universal Installer (OUI)
  • Installing Oracle 12cR1 database software
Ch 4: Creating Oracle Database
  • Planning for an Oracle Database Creation
  • Creating an Oracle Database using MANUAL method
  • Creating an Oracle Database using Graphical Tool (DBCA)
Ch 5: Starting & Stopping Oracle Database
  • Startup & Shutdown Modes
  • Starting & Stopping the Database
  • Read-only & Restricted Modes
Ch 6: Parameter Files, Diagnostic Data & Data Dictionary
  • Understanding Initialization Parameters
  • Managing Diagnostic Data
  • Automatic Diagnostic Repository (ADR)
  • Understanding Data Dictionary
  • Understanding Static & Dynamic Performance Views
Ch 7: Managing Tablespaces & Data Files
  • Tablespace and Data Files Concepts
  • Creating & Managing Tablespaces
  • Understanding Small file Tablespaces and Big file Tablespaces
  • Blocks, Extents, Segments
  • Understanding Extent Management
  • Understanding Space Management
  • Creating Undo Tablespaces
  • Configuring Undo Retention
  • Creating Temporary Tablespaces
  • Managing Temporary Tablespaces
Ch 8: Patching Oracle Applications
  • Patch Classification
  • One –off patches,Mini Packs, Maintenance packs
  • Family Packs
  • Patch File Structure
  • Patch Drivers
  • Auto Patch
  • Downloading a Patch
  • Metalink
  • Querying a patch
  • Downloading a patch
  • Applying a Patch
  • Interactive and Non-Interactive Patching
  • Auto patch Modes
  • Test Mode
  • Pre-Install Mode
  • Merging Patches
  • Applying Merged patches
  • Adpatch Command Line options
  • Patch Failures
  • Restarting the Auto patch
  • Monitoring patch progress
Ch 9: Managing Controlfiles
  • Creating Controlfiles
  • Multiplexing Control files
  • Creating Backup Controlfiles
  • Renaming Files in Controlfile
Ch 10: Redo Log Files & Archiving
  • Understanding Online Redo Log Files
  • Managing Online Redo Log Files
  • Configuring Database in Archivelog Mode
  • Understanding Archived Redo Log Files
Ch 11: Oracle Database Cloning
  • Planning for Database Cloning
  • Cloning Oracle Home
  • Cloning Database (Manual & RMAN)

Module: II


Ch 12: Configuring Oracle Net Services
  • Introduction to Oracle Net Services Components
  • Oracle Listener Configuration(Dynamic & Static Listeners)
  • Dynamic Service Registration
  • Naming Methods Configuration
  • Enabling Database for allowing Client Connections
  • NETCA (Network Configuration Assistant) for Oracle Net Services
  • Understanding the importance of TNS_ADMIN directory
Ch 13: Users and Roles Management
  • Creating User Accounts
  • Managing User Accounts
  • Understanding Privileges
  • Managing Privileges
  • Understanding Roles
  • Managing Roles
  • Using DB Profiles for Efficient Resources
  • Locking & Unlocking Users
Ch 14: User Managed (Manual) Backup and Recovery
  • Planning for a Backup and Recovery Strategy
  • Taking Offline Backup for a Database
  • Taking Online Backup for a Database
  • Cloning Database using Cold Backup
  • Cloning Database using Hot Backup
  • Restoring Database from a Backup
Ch 15: RMAN Backup and Recovery
  • Advantages of RMAN Backup over User Managed Backup
  • Backup Database using RMAN (Normal & Compressed)
  • Backup Database using RMAN Catalog
  • Querying the RMAN Metadata
  • Cloning Database using RMAN Duplicate Database
  • Restoring Database from Backup - Media Failure
  • Configuring Backup Retention Policies
  • Purging Expired Arhivelogs and Old Backup Pieces
Ch 16: Oracle Database Upgrades
  • Understanding Oracle Database Versions
  • Upgrading Database to Oracle 12c - Previous Patchset
  • Upgrading Database to Oracle 12c - Previous Release
  • Patching Oracle Database
  • Oracle Interim Patch Installer (OPATCH)
  • Interim Patches, Bundle Patches, and PSUs
Ch 17: Oracle Database Migration Tools
  • Understanding the need for Migration Tools
  • Understanding Logical Backups
  • Advantages of Data Pump over Export/Import Tools
  • Data Pump Export Modes
  • Advanced Features in Oracle Data Pump Export
  • Understanding Transportable Tablespaces
Ch 18: Oracle Multitenant Databases Architecture
  • Understanding Container Database (CDB)
  • Understanding Pluggable Databases (PDB)
  • Understanding the differences in Architecture
  • Advantages of Container Databases
  • Users, Roles, and Privileges in CDBs
Ch 19: Creating Container Databases
  • Creating a Non-CDB Database using DBCA Tool
  • Creating a CDB Database using DBCA Tool
  • Converting a Non-CDB Database to Container DB
  • Plugging and Un-plugging Pluggable Databases
  • Cloning a Pluggable Database
Ch 20: Oracle Database Performance Tuning
  • Handling Performance Issues in Real World
  • Using V$ Dynamic Views for Performance
  • Enabling Tracing for User Sessions
  • Understanding EXPLAIN PLAN
  • TKPROF Utility @ Trace Files
  • Gathering Statistics for a Table, Schema, and Database
  • Automatic Workload Repository (AWR)
  • Generating AWR Reports
  • Understanding Oracle Database Wait Events
Ch 21: Advanced Oracle Database Concepts
  • Understanding Automatic Storage Management
  • Understanding Real Application Clusters
  • Disaster Recovery Solutions - Oracle Data Guard

Register Today