Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development Oracle Database

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!
Rating: 4.2 out of 54.2 (17 ratings)
180 students
Created by Oak Academy
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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

Course content

51 sections • 155 lectures • 21h 52m total length

  • Preview03:33
  • Project Files and Course Documents
    00:05

  • Downloading Oracle Software
    03:53
  • Extracting Files
    00:29
  • Installing Oracle 12c Database
    03:59
  • Startup Instance on Windows
    03:23
  • Shutdown Instance
    03:00
  • Make SQL Developer Run Faster
    01:48
  • Oracle Live SQL
    03:42

  • Download Virtualbox
    00:54
  • Download Linux
    03:39
  • Download Oracle Software
    01:20
  • Install Virtualbox
    01:35
  • Create Virtual Machine
    01:09
  • Install Linux
    08:11
  • Prerequests
    11:02
  • Oracle Software Installation
    06:31
  • Create Database
    02:59

  • Preview05:34
  • Connect Database From Client
    01:20

  • Learn Data, Database and RDBMS Concepts
    16:08

  • What is DDL?
    00:57
  • Connect and Start to Create Objects
    03:34
  • Create Tablespace
    01:37
  • Create User
    01:40
  • Create Table
    03:31
  • Create Synonym
    02:22
  • Alter Objects
    03:30
  • Drop Objects
    03:13
  • Section Practice
    03:51

  • DML and TCL
    01:02
  • Insert Data to Table
    04:55
  • Update Table Data
    04:27
  • Delete from Table
    05:32

  • Basic Select Statement
    17:23
  • "Like" Operator
    04:32
  • Preview05:11
  • Limiting The Resultset
    06:15
  • Using Ampersand (&) Subtition
    04:22
  • Single Row Operators
    03:49
  • Single Row Functions
    17:30
  • Conversion Functions
    13:48
  • Using Group Functions
    10:40
  • Restricting Reported Data
    02:15
  • Joining Tables
    30:10
  • Using Subqueries
    21:54
  • Exists And Not Exists
    03:41
  • "With" Clause
    03:50
  • Using The Set Operators
    07:32
  • What We Have Learned?
    04:40

  • Schema Objects With SQL Developer
    53:02
  • Using Dictionary Views To Manage Schema
    05:43
  • What We Have Learned In This Section?
    01:14

  • Controlling User Access
    13:49
  • Section Summary
    00:44

Requirements

  • 12 GB memory
  • 60 GB of free disk space
  • A computer with access to the internet
  • Basic Computer Knowledge with (Win7/8/10)
  • Desire to learn Oracle Nothing else! It’s just you, your computer and your ambition to get started today

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!

Who this course is for:

  • Anyone who is Oracle Database beginner but wants to become expert
  • DBA`s who are looking to sharpen their skills to the expert level
  • DBA`s that manage other RDBMS and want to immigrate Oracle
  • DBA`s that manage other RDBMS and want to immigrate Oracle
  • Anyone who wants to become an Oracle DBA at a big company

Instructor

Oak Academy
LONG LIVE TECH KNOWLEDGE
Oak Academy
  • 4.3 Instructor Rating
  • 3,595 Reviews
  • 24,943 Students
  • 151 Courses

Hi there,

By 2024, there will be more than 1 million unfilled computing jobs and the skills gap is a global problem. This was our starting point.

At OAK Academy, we are the tech experts who have been in the sector for years and years. We are deeply rooted in the tech world. We know the tech industry. And we know the tech industry's biggest problem is the “tech skills gap” and here is our solution.

OAK Academy will be the bridge between the tech industry and people who

-are planning a new career

-are thinking career transformation

-want career shift or reinvention,

-have the desire to learn new hobbies at their own pace

Because we know we can help this generation gain the skill to fill these jobs and enjoy happier, more fulfilling careers. And this is what motivates us every day.

We specialize in critical areas like cybersecurity, coding, IT, game development, app monetization, and mobile. Thanks to our practical alignment we are able to constantly translate industry insights into the most in-demand and up-to-date courses,

OAK Academy will provide you the information and support you need to move through your journey with confidence and ease.

Our courses are for everyone. Whether you are someone who has never programmed before, or an existing programmer seeking to learn another language, or even someone looking to switch careers we are here.

OAK Academy here to transforms passionate, enthusiastic people to reach their dream job positions.

If you need help or if you have any questions, please do not hesitate to contact our team.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.