Oracle 11g DBA

Have Queries? Ask us +91 72592 22234

Course Overview

Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Oracle 11g DBA which gives you the opportunity to interact with a Oracle 11g DBA instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants. Prepare Database Designing and Oracle Application Server Internals

Course Content

Introduction to SQL 

  • Introduction
  • Basic SQL statements,restricting&sorting data
  • single row functions
  • Joins
  • Group functions,subqueries
  • Isql * plus,manipulating data
  • creating &managing tables
  • constraints,views
  • other database objects,controlling user access
  • controlling user access
  • Sql workshop
  • Set operators,date time functions
  • Advanced subqueries
  • Hierarchical retrival
  • Extentions to DML and DDL


  • Introduction
  • Oracle architectural components
  • Oracle installation
  • creation of new database
  • Identifying database administrative users
  • Managing an oracle instance
  • Dynamic & datadictionary views
  • managing the control file
  • Maintaining redo log files
  • Maintaining tablespaces&datafiles
  • Creating and managing undo tables spaces
  • Describing storage hierarchy
  • Storage structures and relationships
  • managing undo data, Managing tables
  • Managing Indexes,Identifying unused indexes


  • Networking overview
  • server side configuration
  • client side configuration
  • oracle shared server
  • backup & recovery overview
  • Logical backups
  • configuration of the database archivelog
  • Instance and media recovery structures
  • RMAN configuration
  • user managed backups
  • complete recovery
  • incomplete recovery
  • RMAN backups
  • RMAN respiratory maintenance
  • RMAN catalog creation and usage


  • introduction to PT
  • Diagnostic and tuning tools
  • tuning the shared pool
  • tuning the DB cache
  • Dynamic instance resizing
  • Sizing other SGA components
  • tuning the shared server
  • optimizers
  • sql statement tuning
  • managing statistics
  • using oracle block efficiency
  • partitioning of tables
  • materialized views
  • locking mechanism
  • tuning operating system

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234