1

Oracle Database Administration course (19C,21C) Multitenancy, Backup- Recovery, Data Guard, Patching- Upgrade

Oracle Database Administration course (19C,21C) Multitenancy, Backup- Recovery, Data Guard, Patching- Upgrade

After completing this Complete Oracle Database Administration course (19C,21C) course you will become a confident Database Administrator and will be ready to jump start your career.

You get hands-on experience in the most common administration tasks. You will create and configure Oracle Database Server for the real world production scenario ( in 99% there is no GUI on production servers ). We will go the extra mile and implement different backup strategies, perform numerous restore operations in the Oracle Database Backup&Recovery section of the course. We don’t forget about Patching operations. Because these operations are required to comply with information security policies. And we will have many more interesting assignments.


What you’ll learn

  • Oracle Database Administration
  • Oracle Database Architecture, Physical files of the DB, Memory Structures, Memory Management, Background Processes
  • How to install Oracle Database Software on the server without GUI
  • How to access Oracle Database via sqlplus, sqlcl and SQL Developer
  • Managing Database Instance: Starting and Shutting down DB, working with initialization parameters, Diagnosing problems, working with Data Dictionary
  • Oracle Net Services
  • Administering User Access, Privileges & Roles, Resource Limitation
  • Multitenancy: Creating PDBs from SEED, Clonning PDBs, creating Refreshable Clones, Unplug/Plug PDBs
  • Transparent Data Encryption (TDE)
  • Creating and Managing Tablespaces
  • Managing UNDO Data
  • Practicing different Backup and Recovery scenarious via RMAN
  • Moving Data: Data Pump, SQL Loader
  • Data Guard configuration
  • Applying the latest Database Patch
  • Database Upgrade from 19c to 21c

Course Content: 

Module1: Introduction

  • Describe the differences in Oracle Database editions, options, and packs
  • List the database offerings in Oracle Cloud
  • Explain the sample database that will be used in the course practices

  • List the major architectural components of Oracle Database
  • Explain memory structures
  • Describe background processes
  • Correlate logical and physical storage structures
  • Describe multitenant architecture

  • Connect to an Oracle Database
  • Describe the tools used to access an Oracle Database
  • Describe the Oracle-supplied user accounts for Oracle Database
  • Query the data dictionary in an Oracle Database

  • Describe initialization parameter files and initialization parameters
  • View and modify initialization parameters in SQL*Plus
  • Start up and shut down Oracle databases
  • Open and close PDBs
  • Work with the Automatic Diagnostic Repository (ADR)
  • Query dynamic performance views
  • Describe Oracle Net Services
  • Explain how listeners work
  • Configure listeners for dynamic or static service registration
  • Configure local naming for database connections
  • Test Oracle Net connectivity with tnsping
  • Configure communication between databases by creating database links
  • Explain the difference between dedicated and shared server configurations
  • Create database users
  • Grant privileges to database users
  • Create and grant roles to users or other roles
  • Revoke privileges and roles from users and other roles
  • Create and assign profiles to users
  • Explain the various authentication options for users
  • Assign quota to users
  • Apply the principle of least privilege
  • Describe the methods and tools used to create PDBs
  • Create PDBs from seed by using SQL*Plus
  • Clone PDBs by using SQL*Plus
  • Unplug and plug in PDBs by using SQL*Plus
  • Drop PDBs by using SQL*Plus

Module8:Creating Database Backups

  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups

Module9: Manage Database Instance

  • Initialization Parameters
  • Starting DB Instance
  • Diagnostic Repository05:16
  • Data Dictionary
  • Shutting Down an DB Instance

Oracle Job Interview Preparation

International Student Fee: 1000$


Flexible Class Options

  • Week End Classes For Professionals  SAT | SUN
  • Corporate Group Trainings Available
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Related Courses

Oracle Database 19c: Data Guard Administration

Oracle Database Administration – OCP/OCA

ORACLE DATA GUARD ADMINISTRATION

Oracle Database 12C Data Guard Administration Course

Oracle Database 11g – Data Guard Administration

Oracle Database 19c Administration (DBA Complete Course)

Oracle Database Admin – I
Oracle Database Admin – II

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now