Oracle DBA

ORACLE 11g / 12C  DBA ( REAL TIME )

Many companies across the world hire Oracle DBAs with good knowledge.

In this course, students will gain thorough knowledge about Oracle DBA Concepts & Architecture.

Students will also have hands-on exposure to Oracle Installation, Configuration and Administration.

The focus is more on practical setup and configuration so that students will gain thorough hands-on

Knowledge required to manage Oracle databases in real time.

Students will also be exposed to Real time scenarios that will be implemented in typical Database Projects.

The course will be implemented on Linux operating system platform.

Course Pre-requisites

 Prior knowledge on BASIC SQL

 Basic Linux commands

DBA Centre Highlights

·         Technology Training

·         Lab Practice with Internet Facility

·         Real Time Scenarios and solutions

·         DBA Tools

·         ITIL Infrastructure

·         Real Time Project Concepts

·         Sample DBA Project

·         Interview Questions

·         Interview Preparation Sessions

·         Guidance on Resume preparation

·         Guidance on Oracle Certification

·         One Year Support

Oracle 11g / 12c DBA Topics

1.       Introduction to DBA

      What is Database? Why Database?

Major Databases and Database Vendors, Editions

Roles and Responsibilities of DBA

2.   Installing Oracle Linux

Installing Oracle 11g Database Server

Requirements for Installation

Installing Oracle Software

3.      Creating Oracle Database

Planning the Database

Creating Database

Database & Instance

4.      Oracle Database Architecture (General Overview)

            Memory Structures – SGA, PGA

            Background Processes

            Server Processes

            Database Files

Physical & Logical Structures

5.      Starting & Stopping Database

Startup & Shutdown modes

            Starting & Stopping the database   

            Read-only & Restricted modes

      6.   Parameters & Parameter Files

            Initialization Parameters

            Static and Dynamic parameters

            Parameter Files

Text & Server Parameter Files

System & Session Level Parameters

Changing Parameter values

7.      Data Dictionary

 Understanding Data Dictionary

 Static & Dynamic Performance Views

 Using Data Dictionary

8.      Managing Diagnostic data

              Diagnostic files

 Automatic Diagnostic Repository (ADR)

 Viewing Diagnostic data

       9.A Oracle Database Architecture (In Details, All Components will explain in depth)

       

       9.B Managing Data Files & Tablespaces

            Tablespace and Data Files Concepts

            Blocks, Extents, Segments

            Understanding Space Management

            Creating & Managing Tablespaces

            Big file Tablespaces

            Tablespace Quotas

            Configuring Multi-Block Support

     

     10. Oracle Managed Files (OMF)

            File Naming Conventions using OMF

            Creating Tablespaces with OMF

     11. Managing Temporary Tablespaces

           Understanding Temporary Tablespaces

           Managing Temporary Tablespaces

          Temporary Tablespace Groups

    12. Managing Security for Users

          Creating Users Accounts

          Account management

          Schema , Session

          Using profiles to implement complex

          passwords and resource limits

   13.  Privileges & Roles

          Understanding Privileges , Managing Privileges

          Understanding Roles,  Managing Roles

  14.   Managing Undo Data

          Transactions and Undo Data ,Configuring Undo Retention

          Managing Undo data , Creating Undo Tablespaces

          

 15.  Managing Control Files

        Understanding Control Files

        Multiplexing Control Files

        Backing up Control Files

 16. Redo Log Files & Archiving

       Online & Archived Redo Log Files

       Managing Online Redo Log Files

       Fast Recovery Area (FRA)

      Configuring Database Archive mode

17. Oracle Net Services

      Understanding Oracle Net Services

      Net Listener, Naming Methods

      Net configuration tools- netca, netmgr

      Configuring Listener & Naming methods

      Establishing Database connectivity from Oracle Database Clients

      Distributed Databases, Database Links

18. Oracle Data Pump

      Concepts of Logical backups & Refresh

      Data Pump Exports & Imports

19. Backup and Recovery

      Backup & Recovery Concepts

      Recovery Catalog

      Full & Incremental Backups

      Image Copy & Backup Set backups

      Backup & Recovery using RMAN

      Hot & Cold backups using RMAN

      Complete & In-Complete Recovery

      SQL & DESCRIBE commands in RMAN

20. Transportable Tablespaces

     Concepts of Transportable Tablespaces

     Transporting Tablespaces across Databases

21. Flashback Technologies

     Flashback Database

     Flashback Table

     Flashback Drop Table

22. Database Performance Tuning

      Oracle Tools for Performance Tuning

      AWR, ADDM, ASH

      Execution Plans, using EXPLAIN PLAN

      Application Tracing, TKPROF

      Constraints and Partitioned Tables and Indexes

23. Data Guard

      Overview of Data Guard

      Benefits of Implementing Data Guard

      Standby Database Concepts

      RMAN CLONE

      Implementing Physical Standby Database

24. Database Upgrade

      Oracle 11g to Oracle 12C

25. Oracle 12 C Installation and Create Database

      Oracle Multitenant Architecture

      Exploring the seed database

      Multitenant Container Database Architecture

      Pluggable Databases (PDB)

     Creating CDBs & PDBs

     Managing CDBs & PDBs