Foundation To Oracle Database In Oracle Cloud Infrastructure

Basics, Architecture , Database Deployments, Connectivity Scenarios in OCI [*** GETTING UPDATED WITH NEW CONTENT***]

What you'll learn
What is Cloud Computing : IaaS/PaaS/SaaS
Types of Cloud Deployments : Public / Private / Hybrid
Top Cloud Vendors in the Industry
Introduction to Oracle Cloud & it's IaaS/PaaS/SaaS Offerings
Demo: How to Sign-Up / Sign-In to Oracle Cloud
Introduction to Oracle Cloud Infrastructure (OCI: Second Gen Cloud)
Deep Dive into Architecture of OCI
What are Availability Domains/ Compartments/VCN's / OCPU's / Shapes ?
Comparing OCI Vs OCI-Classic
Demos: How to Create Compartments & VCN's
Understanding Database Cloud Services: ODCS/Exadata Cloud Service/ Exadata@Customer
Demo: Deploy a Database in OCI-Classic
Demo : Deploy a Database in OCI
Understanding SSH Connectivity
Creating Public & Private Keys in Unix / Windows (GitBash & Putty)
Connect to Oracle Cloud Machines as admin user/ root
Sql Developer. Connectivity , with blocked ports (1521)
Connect from AWS EC2 Windows Server to Oracle Cloud Database
Oracle Openworld 2019 Enhancements
What are Autonomous Databases ?
What are Autonomous Database Variants ?
Differences between ATP & ADW
How to Provision an Autonomous Database
Demo: Connectivity Method for Autonomous Databases
Create a new VM DB System (Updated Lecture)
How to Patch the Grid Infrastructure from 19.9 to 19.10
How to Patch the Oracle RDBMS Version from 19.9 to 19.10
Requirements
Oracle DBA's
Oracle Developers
Oracle DevOps
Description
I will be looking to delve deeper into the Oracle Cloud Infrastructure and  demystify the entire dilemma around this.We will start with the very basics like : What is Cloud Computing , What are the Types of Cloud : Pubic / Private / Hybrid? What are the meanings of the important acronyms like IaaS/ PaaS/ SaaS.A good understanding will be given about Oracle Cloud , it's Subscription Models , Demos will be done to show the Sign-up & Sign-in to Oracle Cloud.Then the discussion will move onto the OCI (Second Generation Cloud ) .Will perform a Deep Dive into the Architecture of OCI. We will take a look into important concepts like : What are Compartments / VCN's / Availability Domains  / Shapes& OCPu's. A couple of demos for the creation of Compartments / VCN's will be done.The next milestone would be getting an understanding around Database Cloud Services like : ODCS / Exadata Service / Exadata Cloud@Customer. After this we shall perform demos : Provisioning Database in OCI & OCI-ClassicThe last milestone would be related to Understanding ssh connectivity, There will be Demos showing how you create public / Private keys in Unix & Windows , Demo showing the ssh connectivity from Windows server & Unix Sever will be done. Will demonstrate how to connect as Admin User / Root on Oracle Cloud Machines. In the end we will challenge ourselves and will connect AWS EC-2 machine in Amazon cloud to Oracle Database in Oracle Cloud. The last demo will be on Sql Developer connectivity using the SSH Tunnels where the listener port 1521 has been blocked.

Overview

Section 1: Introduction & About Myself

Lecture 1 Introduction & What will you learn from the course ?

Section 2: Introduction to Cloud Computing

Lecture 2 What is Cloud Computing ?

Lecture 3 Benefits of Cloud Computing

Lecture 4 Types of Cloud Services: IaaS/PaaS/SaaS

Lecture 5 Types of Cloud Deployments: Public / Private / Hybrid

Lecture 6 Top Cloud Vendors

Section 3: Introduction to Oracle Cloud

Lecture 7 Introduction to Oracle Cloud

Lecture 8 Oracle Cloud Subscription Models

Lecture 9 Understanding Estimator Calculator

Lecture 10 Understanding the Sign-up Process

Lecture 11 Demo: Sign-up to Oracle Cloud

Lecture 12 Demo: Sign-in & Browse Oracle Cloud Dashboard

Section 4: Oracle Cloud Infrastructure (Gen2 Cloud)

Lecture 13 Introduction to Oracle Cloud Infrastructure (OCI)

Lecture 14 Architecture of OCI

Lecture 15 OCI-Classic VS OCI

Lecture 16 Oracle Data Regions & Availability Domains

Lecture 17 What are Shapes & OCPU's ?

Lecture 18 What are Compartments ?

Lecture 19 What is a Virtual Cloud Network (VCN) ?

Lecture 20 What is Block Storage / Object Storage ?

Lecture 21 Demo: Creating a Compartment

Lecture 22 Demo : Creating a Virtual Cloud Network (VCN)

Lecture 23 Connect with Me !!!

Section 5: Database Cloud Services

Lecture 24 Oracle Database Cloud Service

Lecture 25 Oracle Database Exadata Cloud Service

Lecture 26 Oracle Database Exadata Cloud@Customer

Lecture 27 Oracle Database Exadata Express Cloud Service-Managed

Lecture 28 Oracle Database Schema Cloud Service - Managed

Lecture 29 Create a Public & Private Key on your Laptop (More Explanation in Later Lessons)

Lecture 30 Demo : Database Deployment in OCI-Classic

Lecture 31 Understand SSH Connectivity

Lecture 32 Subscribe to Our YouTube Channel

Section 6: Practical Scenarios Covering SSH Understanding & Connectivity in Cloud

Lecture 33 Important Linux Users in Oracle Cloud Environments

Lecture 34 Demo : How to Create Public & Private Keys in Unix

Lecture 35 Demo: How to Connect to Database Deployment in OCI-Classic

Lecture 36 Demo: How to Become a Root User in Oracle Cloud

Lecture 37 Demo: Create Public & Private Keys in Windows (Git-Bash)

Lecture 38 Demo: Connect from AWS-EC2 (Windows) Instance using Gitbash to OCI Database

Lecture 39 Demo: Connect from a Windows Server to Oracle Cloud using Putty

Lecture 40 Demo: How to connect using SQL Developer to OCI Database

Section 7: Conclusion

Lecture 41 Conclusion

Section 8: Oracle Open World 2019 Enhancements

Lecture 42 Oracle Open World 2019 Enhancements

Lecture 43 A 10 Second Survey

Section 9: Autonomous Databases

Lecture 44 What is Autonomous Database ?

Lecture 45 Autonomous Database Variants

Lecture 46 Differences between ATP & ADW

Lecture 47 How to Connect to Autonomous Databases

Lecture 48 Provision an ATP Database

Section 10: How to Perform DB Patching in OCI

Lecture 49 Article

Lecture 50 Create an Environment for Patching

Lecture 51 Checking the VM DB Environment

Lecture 52 Patching Grid Infrastructure

Lecture 53 Patching Oracle RDBMS & Database

Section 11: Patching in OCI : Command Line Method

Lecture 54 Lab Work

Lecture 55 Upgrading the Cloud Tooling to Latest Level

Lecture 56 Patching Grid Infrastructure using dbcli

Lecture 57 Patching Oracle RDBMS Version & Database

Lecture 58 New Course: Demystifying Oracle Database Security:On-Prem & Oracle Cloud

Lecture 59 Course Link

Section 12: Configure Database Vault for Autonomous Database

Lecture 60 Demo: Configure Database Vault for ADB

Beginner to the World of Cloud Computing & Any Experienced DBA's / Developers looking to get Understanding around Oracle Cloud