Oracle DBA 11g/12c – Database Administration for Junior DBA

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.

What you’ll learn

• Final Goal: Get a job as an Oracle Database Administrator (Oracle DBA)
• As an Oracle Database Administrator (Oracle DBA), you would be able to understand the Database Architecture, which will help you to perform your DBA duties with a better understanding.
• As an Oracle Database Administrator (Oracle DBA), you would be able to Install the necessary Oracle Software/Database
• As an Oracle Database Administrator (Oracle DBA), you would be able to Administer User accounts in the Database
• As an Oracle Database Administrator (Oracle DBA), you would be able to Manage Tablespace’s to provide the required space for the data
• As an Oracle Database Administrator (Oracle DBA), you would be able to perform Backup and Recovery as needed.
• As an Oracle Database Administrator (Oracle DBA), you would be able to diagnose the problems and if required will be able to work with Oracle Support
• As an Oracle Database Administrator (Oracle DBA), you would be able to configure the Listeners for users to communicate
• Oracle PL/SQL Fundamentals vol. I & II

Description

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.

The ‘Oracle 11g/12c DBA’ course presents concepts and Demo’s to the students so they can learn with ease.

This Oracle DBA 11g/12c – Database Administration for Junior DBA course is right for you if you want to become an Oracle Database Administrator(Oracle DBA).

Every organization has Database Administrators to maintain the organization’s database. Becoming a good DBA relies on a good understanding of the overall architecture of Oracle Database.

I have covered both Oracle Database 11g and Oracle Database 12c in this Oracle DBA 11g/12c – Database Administration for Junior DBA course to help you get to know the differences and to be able to work with organizations that are still on Oracle Database 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!!!

Who this course is for:

• Students who want to start their careen in Database Administration

Created by Amarnath Reddy
Last updated 2/2018
English
Size: 1.3 GB

Download Course

https://www.udemy.com/course/oracledbatraining/