India-flagINDIA : +91-8099902123   usa-flagUSA : 201-710-8393
Call Me Back
Training

training courses

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

If you want to know more about Oracle DBA Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com