Have a question?
Message sent Close

DBA Oracle certification (OCA)

An Oracle Database Administrator (DBA) is primarily responsible and accountable for performing database administration. With massive cloud-based database computing, database services, high performance and reliability requirements, data integration, transformation, storage, etc., as well as with complex and huge applications both in-premise and cloud-based, the role of Oracle DBAs has assumed significant importance in today’s industry scenario and hence a DBA gets highly paid and are always in demand.

19 students enrolled

Image

In this course, I have covered both Oracle Database 11g and Oracle Database 12c so that you get to know the differences and can work in organizations, who are still in 11g.

Step by Step methodology followed is…

  • Learn the fundamentals of database to set the stage for Oracle Architecture
  • Understand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues).
  •  Install Oracle Database 11g & 12c (Manual method and using DBCA)
  • Tablespace management to manage space to store the data.
  • UNDO Tablespace management to manage undo space.
  • REDO Log file management to manage redo space.
  • Manage users and security
  • Networking (Configuring Listeners and TNS entries)
  • Understand various Data dictionary tables/views
  • Diagnose issues using Diagnose data and generate packages for Oracle Support.
  • Backup and Recovery (User Managed)
  • Backup and Recovery (RMAN)
  • Materialized Views
  • Table Partitioning
  • Project Work

Let’s start and I will take you step by step to lead your journey into the DBA world!!!

 

Be the first to add a review.

Please, login to leave a review