Oracle Database Administration DBA (12c) Training: Step by Step Activity Guides /Hands-On Lab Exercise

Oracle

Share Post Now :

HOW TO GET HIGH PAYING JOBS IN AWS CLOUD

Even as a beginner with NO Experience Coding Language

Explore Free course Now

Table of Contents

Loading

This post covers Sneak Peek of Step by Step Hands-On Guides that you must perform in order to learn Oracle Database Administration 12c  to become DBA.

We use these same guides in our Oracle Database 12c Administration Workshop for DBAs where you get to learn things like Install & Configure, Start/Stop Database, EM and Patching, Backup & Recovery, Upgrade and much more.

Purpose of this post is to share what you should practice minimum to become Oracle DBA managing 12c to get Better Job.

Here’s the Sneak Peek of What You will do on your Dedicated Machine for Oracle Database Administration/DBA Training to get better Job.

1. Lab Activity Guide I: Install & Configure

We start with Install & Configuration of Oracle Database 12c in detail. We cover all the required prerequisites, download, how to start/stop database and accessing EM Console. We cover installation on Linux Machine as most of the Companies run Oracle Database on Linux/Unix.

EM (Enterprise Manager): Oracle Enterprise Manager, for lighter version also referred to as EM Express, is a web-based tool for managing Oracle Database 12c. Built inside the database server, it offers support for basic administrative tasks such as storage and user management and provides comprehensive solutions for performance diagnostics and tuning.

You should also learn how to troubleshoot EMExpress or Manager Oracle Database using EMExpress

Also read: Database statistics on AWR Report.

2. Lab Activity Guide II: Administration Tasks

Once Oracle Database 12c is installed in DBA 12c Training, We then learn how to manage CDB and PDB, Start/Stop CDB and PDB, User and Privileges Management, Tablespace management, Redo Logs and Archive mode etc.
Here CDB stands for Container Database & PDB stands for Pluggable Database, introduced in Oracle Database 12c for Multi-Tenancy & Consolidation.

3. Lab Activity Guide III: Backup and Recovery

We then learn about the most important topic that is Backup & Recovery of Oracle database 12c. We cover both CDB & PDB including recovery of both these type of Databases.

4. Lab Activity Guide IV: Patching

In this Activity Guide, we will perform more advanced tasks done by DBAs like Patching in 12c databases where we use OPatch tool to apply patches in Oracle Database.

5. Lab Activity Guide V: Database Upgrade 11g to 12c

In this Activity Guide, we will learn about Supported Upgrade Paths and will do a simple 11g to 12c version upgrade of Database.

Believe me and 100s of our DBAs who have gone through this training, If you practice these guides (You get a Dedicated Machine on Cloud to Practice) then you will learn and become proficient in Oracle Database 12c Administration

Here are some of the reasons why our students think we are the best Oracle Training Institute.

  1. Live Instructor-led Online Sessions.
  2. Unlimited FREE retake for next 3 Years.
  3. Training Material with Hands-on Lab Exercises (5 Step by Step Activity guides + Bonus Guides)
  4. Recording of Live Interactive Session for lifetime Access
  5. Dedicated Machines to Practice
  6. Email & WhatsApp Support
  7. Help in CV Preparation
  8. 100% Money Back Guarantee (If you attend sessions, practice and don’t get results, We’ll do full REFUND, check our refund policy)

K21 Academy DBA Course Insight:

Click here To REGISTER

Have queries? Contact us at contact@k21academy.com or if you wish to speak then share your phone number and country code and a convenient time to speak.

Picture of mike

mike

I started my IT career in 2000 as an Oracle DBA/Apps DBA. The first few years were tough (<$100/month), with very little growth. In 2004, I moved to the UK. After working really hard, I landed a job that paid me £2700 per month. In February 2005, I saw a job that was £450 per day, which was nearly 4 times of my then salary.