ORACLE DBA TRAINING
Oracle DBA Training Course Overview
Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today’s organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.

All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today.

Database Administrator Job Growth
DBAs play an important and responsible role in every company’s Information Technology (IT) department.

PRE-REQUISITES:
SQL, PL/SQL,LINUX
.
INTRODUCTION TO ORACLE
Exploring the Oracle Database Architecture
Creating an Oracle Database
Managing the Database Instance
Managing Database Storage Structures (Table spaces & Segments)
Administering User Security
Managing Data Concurrency
Managing Undo Data
Configuring the Oracle Network Environment
Backup and Recovery Concepts (cold, hot & RMAN)
Use of RMAN Recovery Catalog & Configuring Backup Settings
Performing Database Backups with RMAN
Performing Database Recovery
Moving Data – Export & Import, External Tables & SQL Loader
Using Flashback Technology I
Using Flashback Technology II
Implementing Oracle Database Auditing
Implementing Oracle Database Auditing
Database Maintenance
Performance Management
Managing Performance by SQL Tuning
Diagnosing the Database
Managing Space
Managing Space for the Database
Managing the ASM Instance
Duplicating a Database / Cloning Database
Data Guard
Installing your Oracle Software
Database Patches & Database Upgrades
Introduction to Real Application Clusters
OLTP vs OLAP
Data modeling
Snake-Flow diagram
Dimensions and Facts
IQD preparation
IQD publishing
Cube generation
Cube publishing into portal
Validations
Adhoc reports
Zero suppression reports
Performance and Tuning with OLAP
Backup and recovery in OLAP