Udemy

Platform

English

Language

Databases

Category

Full Oracle Database Administration With High Availability

You will find Oracle Database Administration, Oracle 12C RAC, Oracle 12C R2 Backup and Recovery ( RMAN ) in this course!

4.05 (38 reviews)

Full Oracle Database Administration With High Availability

Students

22 hours

Content

May 2021

Last Update
Regular Price


What you will learn

This course is a complete set of Oracle Database Administration with High Availability.

You will become an expert in subjects like Oracle DBA, Oracle 12C Release 2, Oracle 12C R2 Backup and Recovery ( using RMAN), Oracle Data Guard

You would be able to install the necessary Oracle Software/Database

Creating and Starting Oracle Database

Database Concepts And Fundamentals

Inserting, Updating and Deleting Data In The Table

Using Ampersand Subtition To Make More Dynamic Queries

Backup and recovery concepts in Oracle

Setting up the laboratory environment

Creating and managing recovery catalog

Using flashback Technologies in Oracle

Managing RMAN backups

Setting Up Oracle Enterprise Linux

What is Real Application Cluster?

Install Grid Infrastructure, Database Software and Create database

Administer Database Instances and Cluster Databases

Learn about Oracle RAC One Node

To convert RAC database to RAC One Node and administer it

Design and Deployment Techniques

Data Guard Administration for Oracle 12C R2

Creating Virtual Machines

Basic Usage of Data Guard Broker Utility

Switchover and Failover Operations on Physical Standby Database via both SQLPlus and Data Guard Broker

Creating Far Sync Instance

Configuring Primary and Standby Databases for far sync Instance

Switchover & Failover Operations on Logical Standby Database via both SQLPlus and Data Guard Broker


Description

Hey there,

Welcome to my Full Oracle Database Administration With High Availability course.

This course is a complete set of Oracle Database Administration with High Availability.

Through this course, you will learn all the features of High Availability and will become an expert in Oracle Database Administration. We gathered all the subjects like Oracle DBA, Oracle 12C Release 2, Oracle 12C R2 Backup and Recovery ( using RMAN), Oracle Data Guard, and all High Availability features that you need to know about Oracle Databases in the real world in one course.

If you say I want to specialize in the database and want to learn database subjects in every aspect, you are at the right place!

In the course, you will have down-to-earth way explanations with hands-on examples. During the course, we focus more on the practical side of Oracle Databases. All my students will have a chance to learn not only the whats but also learn the whys and hows.

This course starts with very basics. First, you will learn how to install the tools. Then the show will start and we will start with introducing the Oracle Database architecture, this course will take you all away from performing basic database operations up to implementing advanced operation options.

At the end of the course;

  • DML ( Data Manipulating Language ) and TCL ( Transaction Control Language ),

  • Retrieving Data,

  • Restricting And Sorting Data,

  • Using Single-Row Functions and Customize Output,

  • Using Conversion Functions and Conditional Expressions,

  • Reporting Aggregated Data Using The Group Functions,

  • Defining Table Joins and Displaying Data from multiple Tables,

  • Using Subqueries,

  • Backup and recovery concepts in Oracle

  • Setting up the laboratory environment

  • Creating and managing the recovery catalog

  • Using flashback Technologies in Oracle

  • Backing up the database

  • Reporting on RMAN operations.

  • Managing RMAN backups

  • Using Data Recovery Advisor of Oracle

  • Restoring and recovering database and database objects.

  • The point-in-time recovery concept in Oracle will be crystal clear for you.

  • What is RAC ( Real Application Cluster )

  • Creating Virtual Machines

  • Administer Database Instances and Cluster Databases

  • Oracle RAC One Node

  • How to Convert RAC Database to RAC One Node

  • Workload Management

  • Monitoring Performance

  • Design and Deployment Techniques

  • Cloning Oracle RAC

  • Managing backup, and restoring cluster database

  • Add and Delete Node From Cluster

  • What is Dataguard

  • Cloning Virtual Machines

  • Installing Database Software and Creating Database

  • Creating Physical Standby Database

  • Managing Physical Standby Database

  • Basic usage of Data Guard Broker Utility

  • Creating and managing snapshot databases

  • Switchover and failover operations on physical standby database via both SQLPlus and Data Guard Broker

  • Creating Far Sync Instance

  • Configuring primary and standby databases for far sync instance

  • Creating Logical Standby database

  • Managing Logical Standby database

Fresh Content

Oracle is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. And this course introduces all the Oracle Database High Availability features fundamental to manage Oracle Database and designing a backup and recovery.

Why would you want to take this course? 

Our answer is simple: The quality of teaching.

When you enroll, you will feel our seasoned developers' expertise. 

Step-by-Step Way, Simple and Easy With Exercises

By the end of the course, you’ll have a firm understanding of the Oracle Database in all aspects and valuable insights on how things work under the hood and you'll also be very confident, and hungry to learn more.

Video and Audio Production Quality

All our videos are created/produced as high-quality video and audio to provide you the best learning experience.

You will be,

  • Seeing clearly

  • Hearing clearly

  • Moving through the course without distractions

You'll also get:

Lifetime Access to The Course

Fast & Friendly Support in the Q&A section

Udemy Certificate of Completion Ready for Download


Dive in now to our Full Oracle Database Administration With High Availability course

We offer full support, answering any questions.

See you in the course!


Content

Getting Started to Oracle DBA

What We Will Learn?

Setting Up

Downloading Oracle Software

Extracting Files

Installing Oracle 12c Database

Startup Instance on Windows

Shutdown Instance

Make SQL Developer Run Faster

Oracle Live SQL

Installation of Oracle Database on Linux

Download Virtualbox

Download Linux

Download Oracle Software

Install Virtualbox

Create Virtual Machine

Install Linux

Prerequests

Oracle Software Installation

Create Database

After Installations

Startup & Shutdown Instance From Client

Connect Database From Client

Database and RDBMS Concepts

Learn Data, Database and RDBMS Concepts

DDL (Data Definition Language)

What is DDL?

Connect and Start to Create Objects

Create Tablespace

Create User

Create Table

Create Synonym

Alter Objects

Drop Objects

Section Practice

DML (Data Manipulating Language) and TCL (Transaction Control Language)

DML and TCL

Insert Data to Table

Update Table Data

Delete from Table

Retrieving, Restricting and Reporting Data

Basic Select Statement

"Like" Operator

Sorting Data

Limiting The Resultset

Using Ampersand (&) Subtition

Single Row Operators

Single Row Functions

Conversion Functions

Using Group Functions

Restricting Reported Data

Joining Tables

Using Subqueries

Exists And Not Exists

"With" Clause

Using The Set Operators

What We Have Learned?

Schema Objects And Managing Schema

Schema Objects With SQL Developer

Using Dictionary Views To Manage Schema

What We Have Learned In This Section?

Controlling User Access

Controlling User Access

Section Summary

Manipulating Large Data Sets

Manipulating Large Data Sets

Section Summary

Homework

Be Ready For The Homework

Oracle 12C Release 2 Backup and Recovery Using RMAN

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

Downloads

Download Virtualbox

Download Linux

Download Oracle Software

Installation

Install Virtual Box

Create Virtual Machine

Install Guest Operating System

Prerequisites

Oracle Software Installation

Clone Virtual Machine

Create Primary Database

Create Catalog Database

Create Sample Data

Intro to Backup and Recovery

Introduction to Backup and Recovery

Starting and Interacting with the RMAN Client

Starting and Interacting with the RMAN Client

Create Recovery Catalog

Create Recovery Catalog

Flashback Database and Restore Points

Flashback Database and Restore Points Presentation

Flashback Database and Restore Points

Backup Database

Backup Database Concepts

Backup Database

Backup Database - Advanced Topics

Reporting on RMAN Operations

Reporting on RMAN Operations

Maintaining RMAN Backups and Repository Records

Maintaining RMAN Backups and Repository Records Presentation

Maintaining RMAN Backups and Repository Records

Managing Recovery Catalog

Managing Recovery Catalog Presentation

Managing Recovery Catalog

Data Repair Concepts

Data Repair Concepts

Data Recovery Advisor

Validating Database Files and Backups

Validating Database Files and Backups

Performing Complete Database Recovery

Performing Datafile Recovery

Performing Tablespace Recovery

Performing PDB Recovery

Performing Database Recovery

Performing Point-in-Time Recovery

Database Point In Time Recovery

Tablespace Point In Time Recovery

Performing Block Media Recovery

Performing Block Media Recovery

What We Have Learned In This RMAN Course?

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

Introduction to Oracle RAC (Real Application Cluster)

Intro to RAC

Setting Up The Environment

Create Virtual Machine

Install Guest Operating System

Install Grid Prerequisites Part1

Install Grid Prerequisites Part2

Clone Virtual Machine

Create Shared Disk

Install Grid Infrastructure

Install Database Software

Create Database

Administration of Oracle RAC

Start Crs

Start Database

Stop Database & CRS

Disable CRS

Add & Delete Service

Kill a Session & Set Spfile Parameter

RAC One Node

Administration of RAC One Node

Workload Management

Workload Management

Monitoring Performance

Monitoring Performance

Design & Deployment Techniques

Design & Deployment Techniques

Clone Oracle RAC

Managing Backup & Recovery

Introduction to Recevery & RMAN

Backup Database

Restore Database

Add & Delete Node

Add Node to Cluster

Delete Node from Cluster

Tips & Tricks

First Controls of Day

Monthly Controls

Useful Scripts Usage

Opatch-AWR-ASH

ORA Errors Solutions

Let's Start to Learn Oracle Data Guard

What is Oracle Data Guard?

Understanding the Oracle Data Guard Administration

Redo Transport Services

Apply Services

Downloads

Download Virtualbox

Download Oracle Linux

Download Oracle Software

Installations

Install Virtualbox

Create Virtual Machine

Install Guest Operating System

Install Prerequisites

Install Oracle Software

Clone Virtual Machine

Create Database

Creating Physical Standby

Creating Physical Standby Presentation

Creating Physical Standby Practice

Managing Physical Standby

Managing Physical Standby

Managing Snapshot Database

Managing Snapshot Database

Role Transitions on Physical Standby

Role Transitions Presentation

Switchover on Physical Standby

Failover on Physical Standby

Far Sync Instance

What is Far Sync Instance?

Far Sync Instance Practice

Creating Logical Standby

Creating Logical Standby

Creating Logical Standby Practice

Managing Logical Standby

Managing Logical Standby

Role Transitions on Logical Standby

Switchover on Logical Standby

Failover on Logical Standby

BONUS


Reviews

C
C24 March 2021

I am new to this and the version seems to be a bit older (18) than the one i have now (19). Still, the instructions are very clear so far.


Coupons

DateDiscountStatus
4/16/2021100% OFFExpired

3573665

Udemy ID

10/16/2020

Course created date

11/7/2020

Course Indexed date
Bot
Course Submitted by