ORACLE DBA 12c

Uclid IT School
Hyderabad
12000 11000
2 MONTHS


Course Summary

IT, Software & Hardware
2 MONTHS
Class room
Experienced

Course Overview

This course provides students with comprehensive understanding of Oracle Database Architecture and Administration. It provides hands-on exposure to all aspects of Database Administration like Installing, Administering, Backing up, Securing, Tuning Oracle Databases and provides knowledge and skills required to transform individuals into a complete DBA Professional.


Course Description

One of the most sought-after and highly rewarding IT Career is ‘Oracle DBA’. Major IT organizations and IT using organizations across the world recruit DBAs to support their Oracle Database environments. There is ever increasing demand for highly skilled DBAs across IT Industry.


Topics Covered

    1.Introduction to DBA
    ? What is Database? Why Database?
    ? Major Databases and Database Vendors
    ? Roles and Responsibilities of DBA
    2.Oracle Database Architecture
    ? Database & Instance
    ? Memory Structures – SGA, PGA
    ? Background Processes
    ? Server Processes
    ? Database Files
    ? Physical & Logical Structures
    3. Installing Oracle 12c Database Server
    ? Requirements for Installation
    ? Oracle Universal Installer (OUI)
    ? Installing Oracle Software
    4. Creating Oracle Database
    ? Planning the Database
    ? Creating Database
    ? Exploring the seed database
    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. 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. Managing Undo Data
    ? Transactions and Undo Data
    ? Managing Undo data
    ? Creating Undo Tablespaces
    ? Configuring Undo Retention
    11. Managing Temporary Tablespaces
    ? Understanding Temporary Tablespaces
    ? Managing Temporary Tablespaces
    ? Temporary Tablespace Groups
    12. Managing Control Files
    ? Understanding Control Files
    ? Multiplexing Control Files
    ? Backing up Control Files
    13. Redo Log Files & Archiving
    ? Online & Archived Redo Log Files
    ? Managing Online Redo Log Files
    ? Fast Recovery Area (FRA)
    ? Configuring Database Archive mode
    14. Oracle Managed Files (OMF)
    ? OMF Concepts and Use
    ? File Naming Conventions using OMF
    ? Creating Tablespaces with OMF
    15. User Administration
    ? Creating Users Accounts
    ? Account management
    ? Schema , Session, Killing Sessions
    ? Using profiles to implement complex passwords and resource limits
    16.Privileges & Roles
    ? Understanding Privileges
    ? Managing Privileges
    ? Understanding Roles
    ? Managing Roles
    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
    ? Configuring Shared Servers and Dispatchers
    18.Database Links
    ? Distributed Databases
    ? Creating Database Links
    ? Managing Database Links
    19. Backup and Recovery using RMAN
    ? 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. Flashback Technologies
    ? Oracle Flashback Technologies
    ? Flashback Database
    ? Flashback Table
    ? Flashback Drop Table
    21. Oracle Data Pump
    ? Concepts of Logical backups & Refresh
    ? Data Pump Exports & Imports
    22. Transportable Tablespaces
    ? Concepts of Transportable Tablespaces
    ? Transporting Tablespaces across Databases
    23. Database Cloning
    ? Cloning Concepts and Considerations
    ? Cloning Techniques
    ? Cloning Oracle Home and Database
    ? Manual Cloning
    ? Cloning using RMAN
    24. Data Guard
    ? Overview of Data Guard
    ? Benefits of Implementing Data Guard
    ? Standby Database Concepts
    ? Implementing Physical Standby database
    25. Database Patching
    ? Patching Concepts
    ? Interim Patches, CPU, PSU patches
    ? Patch Sets
    ? Downloading & Analysing Patches
    ? Applying Patches
    26. Database Upgrade
    ? Understanding the upgrade process
    ? Upgrade methods
    ? Upgrading Oracle11g to Oracle 12c
    27. Database Performance Tuning
    ? Oracle Tools for Performance Tuning
    ? Instance & Database Tuning
    ? Execution Plans, using EXPLAIN PLAN
    ? Application Tracing, TKPROF
    ? AWR, ADDM, ASH
    28. Oracle Multitenant Architecture
    ? Multitenant Architecture
    ? Pluggable Databases (PDB) & Container Database (CDB)
    ? Creating & Managing CDBs & PDBs
    ? Users, Roles, Privileges in CDB
    ? Parameters in CDB
    ? Backup, Recovery of CDBs & PDBs

See other jobs

Share Course on :
VISUAL BASIC Program
United Global Soft Institute
Hyderabad
45

CNC COURSE
SR Technologies Institute
Hyderabad
45