Preparing Course Practice Environment (part 1 of 2)

Preparing Course Practice Environment (part 2 of 2)

Introduction to RDBMS

Overview of RDBMS (part 1 of 2)

Overview of RDBMS (part 2 of 2)

Overview on Oracle Database (part 1 of 2 )

Overview on Oracle Database (part 2 of 2)

Overview on Oracle Database Technologies

About Oracle Database Administrator (DBA)

Database Architecture

Oracle Database Architecture (part 1 of 2)

Oracle Database Architecture (part 2 of 2)

Database Tablespaces and Datafiles

Installing and Creating Oracle Databases

Oracle DB Software Installation (part 1 of 2)

Oracle DB Software Installation (part 2 of 2)

Practice- Installing Oracle Database Software in Linux

Practice- Installing Oracle Database Software in Windows

Creating an Oracle Database (part 1 of 3)

Creating an Oracle Database (part 2 of 3)

Creating an Oracle Database (part 3 of 3)

Practice- Creating Oracle Databases (part 1 of 2)

Practice- Creating Oracle Databases (part 2 of 2)

Oracle Database Management Tools

Practice- Using SQL-Plus

Practice- Using SQL Developer

Oracle Database Basic Administration

Starting up and Shutting Down Database Instances

Practice- Starting up and Shutting Down DB Ins

Database Initialization Parameters (part 1 of 2)

Database Initialization Parameters (part 2 of 2)

Practice- Managing Init Parameters

Data Dictionary

Practice- Querying Data Dictionary

Using Oracle Database Documentation (part 1 of 2 )

Using Oracle Database Documentation (part 2 of 2 )

Fundamentals of Oracle Database Multitenancy

Oracle Database Multitenant Architecture (part 1 of 2)

Oracle Database Multitenant Architecture (part 2 of 2)

Practice- Creating a CDB Database

Creating PDBs (part 1 of 2)

Creating PDBs (part 2 of 2)

Practice- Creating PDBs

Basic Multitenant Administration Tasks

Practice- Performing Basic CDB Admin Tasks

Managing Oracle Database Components

Database Memory Concepts (part 1 of 2 )

Database Memory Concepts (part 2 of 2 )

Managing Database Memory (part 1 of 2)

Managing Database Memory (part 2 of 2)

Practice- Managing Database Memory

Database Storage Structures

Managing Tablespaces (part 1 of 4)

Managing Tablespaces (part 2 of 4)

Managing Tablespaces (part 3 of 4)

Managing Tablespaces (part 4 of 4)

Practice - Managing Tablespaces (part 1 of 2)

Practice - Managing Tablespaces ( part 2 of 2 )

Managing Data Files

Practice - Managing Data Files

Managing Resumable Space Allocation (part 1 of 2)

Managing Resumable Space Allocation (part 2 of 2)

Practice - Managing Resumable Space Allocation

Managing Undo Data (part 1 of 3)

Managing Undo Data (part 2 of 3)

Managing Undo Data (part 3 of 3)

Practice - Managing Undo Data

Introduction of section- Managing Database Segments

Shrinking Segments (part 1 of 2)

Shrinking Segments (part 2 of 2)

Practice - Shrinking Segments

Using Deferred Segment Creation

Practice - Using Deferred Segment Creation

Using Table Compression (part 1 of 2)

Using Table Compression (part 2 of 2)

Practice - Using Table Compression

Introducing the Section

Managing Database Users (part 1 of 2)

Managing Database Users (part 2 of 2)

Managing User Privileges (part 1 of 2)

Managing User Privileges (part 2 of 2)

Managing Roles (part 1 of 2)

Managing Roles (part 2 of 2)

Managing User Profiles (part 1 of 2)

Managing User Profiles (part 2 of 2)

Practice Managing Users and User Security (part 1 of 2)

Practice Managing Users and User Security (part 2 of 2)

Managing Local and Common Users

Querying Container Data Objects

Practice - Managing Local and Common Users (part 1 of 2)

Practice - Managing Local and Common Users (part 2 of 2)

Applying the Principle of Least Privileges

Administrative Accounts and Privileges

Using OS Authentication ( Part 1 of 2 )

Using OS Authentication ( Part 2 of 2 )

Using Password File Authentication

Practice - Using Database Authentication Methods

Introducing the Section

Configuring Oracle Network Environment (part 1 of 4)

Configuring Oracle Network Environment (part 2 of 4)

Configuring Oracle Network Environment (part 3 of 4)

Configuring Oracle Network Environment (part 4 of 4)

Practice - Configuring Oracle Network Environment ( part 1 of 4 )

Practice - Configuring Oracle Network Environment ( part 2 of 4 )

Practice - Configuring Oracle Network Environment ( part 3 of 4 )

Practice - Configuring Oracle Network Environment ( part 4 of 4 )

Using Database Links ( part 1 of 2 )

Using Database Links ( part 2 of 2 )

Practice - Using Database Links

Introducing the Section

Configuring Databases for Shared Server (part 1 of 3)

Configuring Databases for Shared Server (part 2 of 3)

Configuring Databases for Shared Server (part 3 of 3)

Practice - Configuring Databases for Shared Server

Introducing the Section

Managing the Fast Recovery Area

Practice - Managing the Fast Recovery Area

Managing the Redo Log (part 1 of 4)

Managing the Redo Log (part 2 of 4)

Managing the Redo Log (part 3 of 4)

Managing the Redo Log (part 4 of 4)

Managing the Archived Redo Log Files (part 1 of 2)

Managing the Archived Redo Log Files (part 2 of 2)

Practice - Enabling the ARCHIVELOG Mode

Introducing the Section

Introducing Backup and Recovery

Introduction to RMAN ( part 1 of 3 )

Introduction to RMAN ( part 2 of 3 )

Introduction to RMAN ( part 3 of 3 )

Practice - Introducing RMAN

Performing RMAN Full Backups - Part I ( 1 of 2 )

Performing RMAN Full Backups - Part I ( 2 of 2 )

Practice - Performing RMAN Full Backups - Part I ( 1 of 2 )

Practice - Performing RMAN Full Backups - Part I ( 2 of 2 )

Performing RMAN Full Backups - Part II ( 1 of 3 )

Performing RMAN Full Backups - Part II ( 2 of 3 )

Performing RMAN Full Backups - Part II ( 3 of 3 )

Practice - Performing RMAN Backups - Part II

Performing Incremental Backups ( 1 of 3 )

Performing Incremental Backups ( 2 of 3 )

Performing Incremental Backups ( 3 of 3 )

Practice - Performing Incremental Backups

logo

Introducing the Section

Configuring RMAN Persistent Settings (part 1 of 2)

Configuring RMAN Persistent Settings (part 2 of 2)

Practice - Configuring RMAN Persistent Settings

Introducing RESTORE and RECOVER Commands

Performing Recovery Part I - Performing Full Recovery

Practice - Performing Recovery Part I

Performing Recovery Part II - Switching Data Files and Performing PITR (1 of 2)

Performing Recovery Part II - Switching Data Files and Performing PITR (2 of 2)

Practice - Performing Recovery Part II

Automating RMAN Backup Jobs

Practice - Automating RMAN Backup Jobs (part 1 of 2)

Practice - Automating RMAN Backup Jobs (part 2 of 2)

Introducing the Section

Using RMAN in Oracle Multitenant Databases

Practice - Using RMAN in Oracle Multitenant Databases ( part 1 of 2 )

Practice - Using RMAN in Oracle Multitenant Databases ( part 2 of 2 )

Duplicating a Database using RMAN - Part I (1 of 3)

Duplicating a Database using RMAN - Part I (2 of 3)

Duplicating a Database using RMAN - Part I (3 of 3)

Duplicating a Database using RMAN - Part II (1 of 2)

Duplicating a Database using RMAN - Part II (2 of 2)

Practice - Duplicating Databases and PDBs using RMAN

Using RMAN Recovery Catalog ( part 1 of 3 )

Using RMAN Recovery Catalog ( part 2 of 3 )

Using RMAN Recovery Catalog ( part 3 of 3 )

Practice - Using RMAN Recovery Catalog

Using Data Recovery Advisor ( part 1 of 2 )

Using Data Recovery Advisor ( part 2 of 2 )

Practice Using Data Recovery Advisor

Introducing the Section

Flashback Database

Practice - Performing Flashback Database

Introducing the Section

Using Oracle Data Pump ( part 1 of 3 )

Using Oracle Data Pump ( part 2 of 3 )

Using Oracle Data Pump ( part 3 of 3 )

Practice - Using Oracle Data Pump

Using SQL Loader ( part 1 of 4 )

Using SQL Loader ( part 2 of 4 )

Using SQL Loader ( part 3 of 4 )

Using SQL Loader ( part 4 of 4 )

Practice - Using SQL Loader

Using External Tables

Practice - Using External Tables

Automating Tasks with the Scheduler

Practice - Automating Tasks with the Scheduler

Introducing the Section

Using ADR Command Interpreter

Practice - Using ADR Command Interpreter

Introducing the Section

Patching Oracle Databases ( 1 of 3 )

Patching Oracle Databases ( 2 of 3 )

Patching Oracle Databases ( 3 of 3 )

Practice - Applying RU Patches on Oracle Databases

Introducing the Section

Introducing Automatic Storage Management (part 1 of 3)

Introducing Automatic Storage Management (part 2 of 3)

Introducing Automatic Storage Management (part 3 of 3)

Practice - Creating Oracle Database with ASM (part 1 of 4)

Practice - Creating Oracle Database with ASM (part 2 of 4)

Practice - Creating Oracle Database with ASM (part 3 of 4)

Practice - Creating Oracle Database with ASM (part 4 of 4)

Practice - Applying RU Patches on Oracle Restart

Introducing the Section

Upgrading Oracle Databases (part 1 of 2)

Upgrading Oracle Databases (part 2 of 2)

Practice - Upgrading Oracle Database

Practice - Upgrading Oracle Grid Infrastructure

Download Course Materials