Oracle Database Administration 12c and 19c | 1Z0-082 exam
A robust scenario based Oracle Admin course: Become a good DBA and prepare to be certified in 1z0-062 or 1z0-082 exams
Course Description
Why Oracle?
It is the number one database widely used by many reputable organizations the world over.
Companies and organizations are always looking out for extremely good DBAs.
Good DBAs are well paid.
This course aims to provide a thorough grounding in the concepts and technologies that form the foundation of Oracle’s Database Server, currently known as Oracle Database 21c.
The course is intended for a wide range of Oracle Database administrators, developers, and users, from the novice to the experienced.
It is my hope that once you have this basic understanding of the product, you’ll be able to connect the dots when using Oracle database.
This course is based on Oracle Database 12c and 19c
We shall together be able to upgrade our database from 12c release to 19c release.
The new Oracle release in these cloud series is 21c, released in 2021.
What will you gain?
The skills gained in these course can enable you secure a junior Oracle DBA job
It will also help consolidate your skills if you are already a DBA
The course aims to prepare you to sit 1z0-062 exam validated for Oracle database 12c or the 1z0-082 exam validated for Oracle database 19c. You need to pass 1z0-062 or 1z0-082 exam together with 1z0-071 SQL exam to be able to get an Oracle Certified Associate (OCA) certificate.
Course Prerequisite:
SQL skills: Essential
PLSQL skills: Not Mandatory
Basic Linux Skills: Essential
Who this course is for:
- Database beginners curious to understand Oracle database
- Junior DBA's who want to up their game in handling the massive technology that is Oracle
- Senior DBA's who would wish to sharpen some skills and become certified in OCA
- Students pursuing Oracle certifications like OCA and OCP
- Oracle developers, Apps DBA's, Designers, EBS consultants and anyone interacting with the Oracle database who wants a better understanding of how the database operates
Goals
What will you learn in this course:
Understand the Oracle Database Architecture
Oracle Database Management Tools
Managing the Database Instance
Configuring Oracle Net
Understanding Oracle Logical Storage Structures
Understanding user Security
Managing Database Storage Structures
Managing Undo Data
Managing Data Concurrency
Implementing Oracle Database Auditing
Backup and Recovery Concepts and Configuration
Moving Data using Different Methods
Performing Database Maintenance
SQL Performance and Tuning
Using Resource Manager
Automating Tasks by Using Oracle Scheduler
Upgrading Oracle Database Software
Introduction to DBAAS
Prerequisites
What are the prerequisites for this course?
Knowledge in Oracle SQL
Knowledge in Oracle PL/SQL
Knowledge in basic Linux commands
Ensure you have followed my free course and installed an Oracle 12c or 19c database with the HR schema

Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
3 Lectures
-
Overview 02:20 02:20
-
Roles of a Oracle Database Administrator 02:07 02:07
-
Topics to be Covered 04:45 04:45
Oracle Database Architecture
3 Lectures

Memory Components
5 Lectures

Process Structures
11 Lectures

Storage Structures
2 Lectures

Architecture Recap
1 Lectures

Database Management Tools
5 Lectures

Instance Management
11 Lectures

Database Startup and Shutdown Process
7 Lectures

Trace Files and Alert Log file
5 Lectures

Dynamic Performance and Data Dictionary views
2 Lectures

Oracle Net Configuration
5 Lectures

Logical Storage vs Physical Storage in Oracle
16 Lectures

Database User and Security
4 Lectures

Instructor Details

James Njoroge
Oracle Database ConsultantHi,
I am an Oracle Consultant and Instructor driven to knowledge and skills transfer.
I have 15+ years experience in ICT training and 10+ years as an Oracle trainer and consultant.
I have effectively delivered corporate and classroom setting trainings to audiences drawn across different continents as an Oracle University delivery trainer.
My vast knowledge in Oracle products is what I promise to deliver throughout my courses.
I am currently a technical consultant at Technoroots Limited.
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

Our students work
with the Best


































Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now