ORACLE DBA TRAINING

Home - - ORACLE DBA TRAINING

ORACLE DBA TRAINING

May 21, 2021 382 Views
ORACLE

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-7774892805 or mail us on contact@intelogik.com

Course Info

Social Links