Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Oracle Database Administration 12c and 19c | 1Z0-082 exam

person icon James Njoroge

4.3

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

updated on icon Updated on Jun, 2025

language icon Language - English

person icon James Njoroge

English [CC]

category icon Office Productivity,Oracle,

Lectures -80

Duration -5.5 hours

Lifetime Access

4.3

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

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 this course can enable you to 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.

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 DBAs, Designers, EBS consultants, and anyone interacting with the Oracle database who wants a better understanding of how the database operates

Goals

  • 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

  • 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

Oracle Database Administration 12c and 19c | 1Z0-082 exam

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

3 Lectures
  • play icon Overview 02:20 02:20
  • play icon Roles of a Oracle Database Administrator 02:07 02:07
  • play icon Topics to be Covered 04:45 04:45

Oracle Database Architecture

3 Lectures
Tutorialspoint

Memory Components

5 Lectures
Tutorialspoint

Process Structures

11 Lectures
Tutorialspoint

Storage Structures

2 Lectures
Tutorialspoint

Architecture Recap

1 Lectures
Tutorialspoint

Database Management Tools

5 Lectures
Tutorialspoint

Instance Management

11 Lectures
Tutorialspoint

Database Startup and Shutdown Process

7 Lectures
Tutorialspoint

Trace Files and Alert Log file

5 Lectures
Tutorialspoint

Dynamic Performance and Data Dictionary views

2 Lectures
Tutorialspoint

Oracle Net Configuration

5 Lectures
Tutorialspoint

Logical Storage vs Physical Storage in Oracle

16 Lectures
Tutorialspoint

Database User and Security

4 Lectures
Tutorialspoint

Instructor Details

James Njoroge

James Njoroge

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515