What We Will Learn in Oracle DBA Sections

Let's See What We Will Cover In This RMAN Course

What We Will Learn in Oracle RAC Sections

Download Virtualbox

Download Oracle Software

Extracting Files

Download Linux

Installing Oracle 12c Database

Startup Instance on Windows

Make SQL Developer Run Faster

Shutdown Instance

Oracle Live SQL

Create Virtual Machine

Install Virtualbox

Install Linux

Oracle Software Installation For Linux

Prerequests

Create Database For Linux

Connect Database From Client

Startup & Shutdown Instance From Client

What is DDL

Create User

Create Tablespace

Create Synonym

Create Table

Alter Objects

Section Practice

Drop Objects

Learn Data, Database and RDBMS Concepts

DML and TCL

Insert Data to Table

Update Table Data

Delete from Table

Basic Select Statement

Sorting Data

Limiting The Resultset

Single Row Operators

Like Operator

Single Row Functions

Restricting Reported Data

Conversion Functions

Exists And Not Exists

Using Subqueries

With Clause

Joining Tables

Using Group Functions

Using The Set Operators

What We Have Learned

What We Have Learned In This Section

Using Dictionary Views To Manage Schema

Schema Objects With SQL Developer

Section Summary

Controlling User Access

Manipulating Large Data Sets

Be Ready For The Homework

Prerequisites

Oracle Software Installation

Clone Virtual Machine

Create Catalog Database

Create Primary Database

Create Sample Data

Introduction to Backup and Recovery

Starting and Interacting with the RMAN Client

Create Recovery Catalog

Flashback Database and Restore Points Presentation

Flashback Database and Restore Points

Backup Database Concepts

Backup Database - Advanced Topics

Backup Database

Maintaining RMAN Backups and Repository Records Presentation

Maintaining RMAN Backups and Repository Records

Reporting on RMAN Operations

Managing Recovery Catalog Presentation

Managing Recovery Catalog

Data Repair Concepts

Data Recovery Advisor

Validating Database Files and Backups

Performing Datafile Recovery

Performing Tablespace Recovery

Performing PDB Recovery

Performing Database Recovery

Let's Wrap Up What We Covered In This RMAN Course

Database Point In Time Recovery

Tablespace Point In Time Recovery

Intro to RAC

Performing Block Media Recovery

Install Grid Prerequisites Part1

Install Grid Infrastructure

Create Shared Disk

Install Grid Prerequisites Part2

Start Crs

Start Database

Disable CRS

Stop Database & CRS

Add & Delete Service

Kill a Session & Set Spfile Parameter

Administration of RAC One Node

Monitoring Performance

Workload Management

Design & Deployment Techniques

Clone Oracle RAC

Introduction to Recevery & RMAN

Restore Database

Add Node to Cluster

Delete Node from Cluster

Useful Scripts Usage

First Controls of Day

Opatch-AWR-ASH

ORA Errors Solutions

Monthly Controls

What We Have Learned

Understanding the Oracle Data Guard Administration

What is Oracle Data Guard

Redo Transport Services

Apply Services

Install Prerequisites

Creating Physical Standby Presentation

Creating Physical Standby Practice

Managing Snapshot Database

Role Transitions Presentation

Switchover on Physical Standby

Failover on Physical Standby

Managing Physical Standby

What is Far Sync Instance

Far Sync Instance Practice

Creating Logical Standby

Creating Logical Standby Practice

Managing Logical Standby

Failover on Logical Standby

Switchover on Logical Standby