Comprehensive Oracle Database Training

Learn how to manage Oracle instances, configure the network environment, and implement database security.

Data Recovery and Backup Mastery

Master the art of manual and automatic backups, utilize the Data Recovery Advisor, and perform data import and export operations.

Optimized Performance and Resource Management

Understand database architecture, utilize Flashback Technology, and automate tasks with the Scheduler for optimal performance.

About the Course

Join our Oracle Database Administration 2 course to gain expertise in preparing, managing, and securing Oracle databases. Learn essential skills like setting up database environments, managing storage structures, and automating tasks for seamless operations. Dive deep into data recovery, backup strategies, and performance optimization to excel in Oracle database management. Take the first step towards mastering Oracle database administration and elevate your career in database management.

Course Curriculum

18 Chapters · 49 Lessons

  1. 1

    SQL Fundamentals

    1. (Included in full purchase)

      Reading Data with SELECT

    2. (Included in full purchase)

      Assignment 2 (Sql Fundamentals 1)

    3. (Included in full purchase)

      Changing Data & Transactions

    4. (Included in full purchase)

      Assignment 3 (Sql Fundamentals 2)

    5. (Included in full purchase)

      Schema Objects & Meta-Data

    6. (Included in full purchase)

      Assignment 4 (Sql Fundamentals 3)

  2. 2

    Usermanaged backups and Refresh from ORCL to REFRESH

    1. (Included in full purchase)

      User managed Backup

    2. (Included in full purchase)

      Assignment 5 (Usermanaged backups and Refresh from ORCL to REFRESH)

  3. 3

    RMAN Intro/RMAN Recovery Catalog

    1. (Included in full purchase)

      Recovery Catalog

    2. (Included in full purchase)

      Assignment 6 (RMAN Intro/RMAN Recovery Catalog)

  4. 4

    Configuring Backup Settings and Creating backups

    1. (Included in full purchase)

      Configuring Backup Settings

    2. (Included in full purchase)

      Assignment 7 (Configuring Backup Settings and Creating backups)

  5. 5

    Creating Backups with RMAN

    1. (Included in full purchase)

      Creating Backups with RMAN

    2. (Included in full purchase)

      Assignment 8 (Creating Backups with RMAN (CHAPTER 5))

  6. 6

    Performing a switch copy/ Rman Cloning

    1. (Included in full purchase)

      Restore and Recovery Tasks

    2. (Included in full purchase)

      Assignment 9 (Performing a switch copy/ Rman Cloning)

  7. 7

    Rman Block Corruption

    1. (Included in full purchase)

      Assignment 10 (Rman block corruption)

  8. 8

    Flashback database

    1. (Included in full purchase)

      Flashback Database

    2. (Included in full purchase)

      Assignment 11 (Flashback)

  9. 9

    Backup Scenarios

    1. (Included in full purchase)

      Assignment 12 (Performing Backup)

  10. 10

    Schedule and Implement your Backup Strategy

    1. (Included in full purchase)

      Schedule and Implement your Backup Strategy

    2. (Included in full purchase)

      Additional Notes

    3. (Included in full purchase)

      Assignment 13 (Schedule and implement your Backup Strategy)

  11. 11

    Transparent Data Encryption

    1. (Included in full purchase)

      Transparent Data Encryption

    2. (Included in full purchase)

      Assignment 14 (Transparent Data Encryption)

  12. 12

    Datapump Import/Sql Loader

    1. (Included in full purchase)

      Assignment 15 (Datapump Import/Sql Loader)

  13. 13

    Transportable Tablespaces

    1. (Included in full purchase)

      Transportable Tablespaces

    2. (Included in full purchase)

      Assignment 16 (Transportable Tablespace)

  14. 14

    Performance Tuning

    1. (Included in full purchase)

      Performance Tuning Curriculum

    2. (Included in full purchase)

      Assignment: Performance tuning Database Preparation

    3. (Included in full purchase)

      Assignment: Optimizer Statistics

    4. (Included in full purchase)

      Assignment: Indexes

    5. (Included in full purchase)

      Assignment: AWR, ADDM, and ASH

    6. (Included in full purchase)

      Assignment: Table Partitioning

    7. (Included in full purchase)

      Assignment: Materialized Views

    8. (Included in full purchase)

      Assignment: SQL Profiles

    9. (Included in full purchase)

      Assignment: AWR and SQL Plan Baselines

    10. (Included in full purchase)

      Assignment: AMM and ASMM

  15. 15

    Oracle 12c (12c Multi-tenant Database)

    1. (Included in full purchase)

      Oracle 12c Multitenant Architecture

    2. (Included in full purchase)

      Assignment: Oracle 12c Software Installation

    3. (Included in full purchase)

      Assignment: Migrating a Schema with Data Pump to a 12c PDB

  16. 16

    Oracle 12c Dataguard

    1. (Included in full purchase)

      Oracle Data Guard

    2. (Included in full purchase)

      Assignment: Creating a Data Guard Physical Standby with the Broker in Oracle 12c

  17. 17

    Oracle Upgrade and Patching

    1. (Included in full purchase)

      A Practical Oracle Upgrade and Patching Path

    2. (Included in full purchase)

      Database Software Locations

    3. (Included in full purchase)

      Assignment: Upgrade from 10.2.0.1 to 11.2.0.3

    4. (Included in full purchase)

      Assignment: Apply PSU patches

    5. (Included in full purchase)

      Assignment: Upgrade from 11.2.0.3 to 12.2.0.1

  18. 18

    Oracle RAC (Real Application Clusters)

    1. (Included in full purchase)

      Oracle Rac Introduction

Ready for Oracle Database Administration 2?

Unlock the full potential of Oracle Database Administration 2 and propel your career to new heights. Enroll in our course now!

Enroll Now