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

ORACLE FUNDAMENTALS -1

  • 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

ORACLE FUNDAMENTALS -II

  • 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

PERFORMANCE TUNING

  • 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.
-Waseem

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.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234