Oracle DBA Training

Share course

Introduction

  • Unix Basic Commands
  • Oracle 12c New Features

Introduction to Oracle SQL Statements

  • Select Statements
  • Operators 
  • Expression 
  • Conditions
  • orderby/Group BY Clauses
  • where/having clauses
  • Aggregate functions
  • Date/Time Functions

Oracle Architecture

  • Oracle Memory Structures
  • Background Processes
  • Parameter Management – Important Parameters
  • Oracle File Structures
  • Storage Structures – 
  • Tablespaces
    • Segments
    • Extents
    • Blocks
  • Oracle Block Structure
  • Tablespaces & Datafiles Management
  • Redolog Management
  • Archive Logs
  • Undo Management
  • Control File Management
  • Temporary Tablespaces
  • Network Management – 
    • Listener
    • Tnsnames.ora
    • SQLNet.ora
  • Complete understanding of Architecture Diagram
  • Controlling Oracle Database (Start/Stop modes)

Oracle Architecture – II

  • Schema Objects 
    • Tables
    • Indexes
    • Synonyms
  • Data Dictionary
  • Understanding Profiles
  • User Management
  • Understanding Roles
    • System Privileges
    • Object privileges

Database Transactions

  • Understand DDL/DML and DCL transactions
  • Oracle Enqueues & Latches 
  • Locks 
  • Blocking

 

 

Oracle Installation

  • Oracle Installation on Unix 
    • Using OUI  and Silent Installation
  • Creating Oracle Database Manually
  • Oracle Client Tools Overview 
    • SQLPLUS
    • SQLDeveloper
    • Toad

Oracle Backup

  • What is backup and different types of Backups
  • Consistent Backup Vs Inconsistent Backup
  • User Managed Backup
  • RMAN based backup
  • Logical Backups using export or expdp

Oracle Recovery

  • Types of Oracle recovery
  • User Managed recovery 
    • Complete
    • Incomplete
  • Rman managed recovery 
    • complete
    • Incomplete
  • IMP/IMPDP
  • Backup strategies

Simple Performance Troubleshooting Steps

  • What is optimizer and how it works?
  • Statistics collection for database objects
    • how important it is?
  • Optimizer modes
  • Important optimizer parameters
  • Methods to collect object statistics
  • Execution plan for a statement
  • AWR,ADDM report generation
  • SQL Tuning advisor
  • Understanding SGA Sizing
  • Understaning PGA Sizing

Oracle Flashback

  • Flash Recovery Area: Concepts, Benefits, Configuration and Monitoring

 

Key Highlights

  • PSN trainings is a leading online training provider across the globe. Our online training team is highly qualified, experienced and skilled with real time      industry experience.

PSN Trainings Highlights:

  • Instructor Led Online Courses  with 24x7 On-Demand Support
  • World Class Trainers with +12 years Industry Experience. Instructors are not just trainers they are Consultants
  • We provide  24/7 Server access to help our trainees practice exercises
  • Teaching Material Prepared by Experts from PSN Trainings who have real time experience
  • Hands on Lab Assignments
  • 100% Placement Assistance
  • Project Based learning to get hands-on experience on a real life application!
  • Providing high quality interactive and cost effective online Training
  • Live Interactive classes by industry experts.

Trainer Information:

  • Having 10  years of  IT Industry Experience
  • 6  years  of Oracle DBA Real Time  Experience
  • Having  5 yrs experience  as an online trainer for Oracle DBA
  • Held up to 80+ batches in past 5 years
  • Trainer has an excellent practical & industrial knowledge

 Faculty is very good at giving real time examples ,so it became very easy for me to learn and practice and implement it in my project..
 Rahul

 

 

 I completed Oracle DBA  from Make my class institute . Very well environment for study and best institute for ever.
 Ram
 

 

 

 Very experienced Trainer for Oracle DBA  and very good knowledge.Trainer  covered Oracle 12c Features too in my Oracle DBA Course 
 Shubanjan
 

 

Enquiry