Oracle DBA Training

Oracle or Oracle Database is an Relational database management system ( RDBMS) by Oracle Corporation. Oracle is among Top databases used in IT Industry.

Tech Altum's Oracle Database 11g and complete course including preparation of SQL, OCA and OCP Certification from 12 Years Experienced and OCP certified professional. In this training, our professional trainer share his experience in industry and day to day challenges that Oracle DBA has to face while working on production server.

Oracle DBA Course:

Oracle DBA course is divided in two modules, Oracle SQL and Oracle DBA. Here are our Oracle DBA Course contents in detail.

• Orcale SQL
  • Sub-Language
  • Constraints
  • Operator (IN,Like,Between,Any,All,Exists etc)
  • Set Operator
  • Joins
  • Grouping and Having
  • Function (Numeric,String and Conversion)
  • Case and Decode
  • Analytical Function (Rank,Dense_rank,Lead,Lag,Ntile,Cube,Rollup)
  • Types of Queries
  • Views
  • Synonyms
  • Index
  • Sequence
  • SQL*Loader
• Oracle DBA
  • Architecture
  • Installation
  • User/Profile/Tablespace Management
  • File Management(Multiplexing of Redo & Controlfile)
  • Indexes Management
  • Partition Management
  • Backup & Recovery (exp/inp,Datapump,RMAN)
  • Cloning
  • Patching
  • Migration/ Up-gradation
  • Flashback
  • Auditing
  • ASM (Automatic Storage Management)
  • DG (Dataguard)
  • Performance Tunning (ASH/AWR/SQL Tunning Advisor)
  • Hints