Welcome To Eazygurus

Oracle DBA

Course Name         :   Oracle DBA
Duration                 :  35 hrs

STUDENTS ENROLLED

    • Introduction to Oracle 11g DBA
      • Introduction about roles and responsibilities of oracle DBA
      • Oracle Software Installation
      • Introduction about 11g features
    • Architecture
      • Physical Structure
      • Logical Structure
      • Memory Structure
      • System Global Area(SGA)
      • Program Global Area(PGA)
      • Background Processes
      • Oracle Server
      • SQL Statement Execution
    • Start up and Shutdown Options in Oracle
    • Database Creation
      • Manual Script
      • Oracle Managed Files(OMF)
    • Tablespace Management
      • Types of Tablespaces
      • Status of Tablespaces
      • Modes of Tablespaces
    • User Management
      • User Creation
      • Privileges
      • Roles
      • Quota
      • Profile
    • Renaming a Datafile
    • Space/Storage Management
      • Storage Parameters
      • Segments, Extents, Blocks
    • UNDO Management
      • States of UNDO
    • Flashback Technologies
      • Flashback Query
      • Flashback Drop Table
      • Flashback Versions Query
      • Flashback Transaction Query
    • Server Parameter (SP) File Creation
    • Oracle Managed Files (OMF)
    • Networking
    • Database(DB) Links
      • Types of DB Links
    • Materialized Views
      • Refresh Options
    • Control File Management
      • Multiplexing of Control File
    • Renaming of Instance
    • Redolog File Management
      • States of Redolog File
      • Adding of new log member, log group
      • Dropping a log file
    • Archivelog Management
    • Dropping a Database
    • Backup and Recovery
      • Logical Backups – Export, Import
      • Physical Backups – Cold, Hot
      • Data Pump
      • Recovery Manager(RMAN)
      • Recovery Scenarios
    • Database Reorganization
    • Transportable Tablespace
    • Performance Tuning
      • Memory Tuning
      • Explain Plan
      • TKPROF
      • Automatic Workload Repository (AWR)
      • Automatic Database Diagnostic Monitor (ADDM)
    • Automatic Storage Management (ASM)
    • Database Cloning
      • Cold Backup
      • RMAN
    • Oracle Installation on Red Hat Linux
    • Oracle Enterprise Manager (OEM)
    • Renaming a Database
    • Row Chaining and Row Migration
    • Data Guard
      • Protection Modes
      • Physical Standby
      • Logical Standby
      • Snapshot Standby
      • Active Data Guard
      • Switchover and Failover

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.