Foundation to Oracle Database in Oracle Cloud Infrastructure

Name: Foundation to Oracle Database in Oracle Cloud Infrastructure
Rating: 4.6 (3590 reviews)

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

Created byKshitij Joy (Cloud Alchemy)

Last updated 3/2025

English

English [Auto],Spanish [Auto],

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

Course content

14 sections • 61 lectures • 4h 33m total length

Introduction & What will you learn from the course ?6:12
Explore cloud fundamentals and Oracle Cloud Infrastructure, second generation, including compartments and vcns, bring your own license agreement and pay-as-you-go pricing, with database deployment and SSH connectivity demos.

What is Cloud Computing ?1:31
Benefits of Cloud Computing5:22
Discover how cloud computing reduces costs, speeds provisioning, and scales resources to boost productivity, performance, and reliability with mirrored data and availability domains.
Types of Cloud Services: IaaS/PaaS/SaaS4:31
Explore the three cloud service types - IaaS, PaaS, and SaaS - within a stacked model, from infrastructure to software, with examples like Oracle Cloud and pay-as-you-go resources.
Types of Cloud Deployments: Public / Private / Hybrid6:31
Top Cloud Vendors3:55
Analyze top cloud vendors using company filings and earnings data, revealing Microsoft as the leader, followed by AWS, IBM, and Oracle, with a focus on Oracle Cloud Infrastructure.

Introduction to Oracle Cloud2:49
Oracle Cloud Subscription Models8:56
Discover Oracle cloud subscription models for IaaS and PaaS, including universal credit services and bring your own license. Compare metered and non-metered options and understand pricing for SaaS.
Understanding Estimator Calculator4:22
Understanding the Sign-up Process3:57
Learn how to sign in to Oracle Cloud by creating a free account, selecting a data region, and entering email, verification code, and credit card details.
Demo: Sign-up to Oracle Cloud4:57
Sign up for Oracle Cloud using the try for free option, complete three simple steps, verify with a mobile code, and start using infrastructure and database services with free credits.
Demo: Sign-in & Browse Oracle Cloud Dashboard3:18
Sign in to the Oracle Cloud dashboard with your cloud account name, email, and password, then customize your my services view to show MySQL or big data compute edition.

Introduction to Oracle Cloud Infrastructure (OCI)4:58
Architecture of OCI7:46
Explore Oracle's second-gen cloud architecture, from fast connect and public internet to data regions with multiple availability domains. Learn off-box vcN virtualization and governance with compartments and IAM.
OCI-Classic VS OCI4:21
Oracle Data Regions & Availability Domains7:34
What are Shapes & OCPU's ?3:35
Explore shapes and ocpus to understand configurations, CPU cores, and RAM, learn how Oracle Compute Unit maps to physical processors with hyper-threading, and compare VM shapes where storage stays constant.
What are Compartments ?5:01
Oracle Cloud Infrastructure compartments provide security and isolation by organizing resources as logical containers, with each resource assigned to one compartment and shareable across compartments and vcns.
What is a Virtual Cloud Network (VCN) ?4:03
Explore how Oracle Cloud Infrastructure's virtual cloud network provides a software-defined network with subnets, routing tables, and gateways, using CIDR ranges across availability domains.
What is Block Storage / Object Storage ?5:02
Demo: Creating a Compartment3:21
Create a demo compartment to organize resources and enforce isolation across cloud networks, compute instances, and block volumes, and avoid placing resources in the root compartment.
Demo : Creating a Virtual Cloud Network (VCN)5:09
Create a virtual cloud network (VCN) in the demo compartment using the OCI dashboard; it auto-creates CIDR, internet gateway, a route table, and three subnets across availability domains.
Connect with Me !!!0:02

Oracle Database Cloud Service8:57
Explore Oracle Database cloud deployment options—ODCS, Exadata Cloud Service, Exadata at Customer, Exadata Express, and schema cloud service—compare VM vs bare metal, editions, transparent data encryption, and pay-as-you-go vs monthly-flex.
Oracle Database Exadata Cloud Service3:37
Explore Oracle Exadata cloud service, delivering the full Exadata power in the cloud, with Oracle managing infrastructure while you control the database, RAC, in-memory, and active data guard.
Oracle Database Exadata Cloud@Customer3:57
Explore how Oracle Exadata Cloud@Customer brings a private on-premise Exadata cloud to your data center, offering identical Exadata service with low latency and Oracle-managed infrastructure.
Oracle Database Exadata Express Cloud Service-Managed3:36
Oracle Database Schema Cloud Service - Managed3:31
Create a Public & Private Key on your Laptop (More Explanation in Later Lessons)
Please create your public & private keys on your laptop as this would be needed in the next Lecture. More Explanation on the details of each component will be done in the later lessons.
Demo : Database Deployment in OCI-Classic14:45
Deploy a database in Oracle Cloud Infrastructure Classic by creating an instance, configuring DB name and PDB, selecting license type and edition, and enabling SSH access.
Understand SSH Connectivity4:01
Subscribe to Our YouTube Channel & Connect on Linked in0:19

Important Linux Users in Oracle Cloud Environments1:43
Identify the main linux users in Oracle cloud environments, including OPC, Oracle user, grid user, and root, and learn when to use sudo to switch to root for tasks.
Demo : How to Create Public & Private Keys in Unix3:29
Demo: How to Connect to Database Deployment in OCI-Classic3:24
Connect to an Oracle Cloud Infrastructure database deployment via a public IP with ssh, access the CDB and PDBs, and perform admin tasks as sysdba.
Demo: How to Become a Root User in Oracle Cloud2:30
Demo: Create Public & Private Keys in Windows (Git-Bash)4:11
Demo: Connect from AWS-EC2 (Windows) Instance using Gitbash to OCI Database5:49
Demonstrates connecting an AWS EC2 Windows instance to an Oracle Cloud VM DB server using Git Bash and SSH keys, adding the public key on OCI and accessing VM ORCL.
Demo: Connect from a Windows Server to Oracle Cloud using Putty3:23
Demo: How to connect using SQL Developer to OCI Database7:09

What is Autonomous Database ?5:27
Autonomous Database Variants2:31
Differences between ATP & ADW4:34
Compare ADW and ATP: ADW uses columnar data for analytics, ATP uses row data for OLTP. Understand how parallelization, automatic indexing, and real-time statistics optimize performance for warehousing versus OLTP.
How to Connect to Autonomous Databases5:45
Provision an ATP Database5:50
Provision an autonomous transaction processing database in Oracle Cloud Infrastructure by selecting ATP, a compartment, a display name, and workload type, then choose shared or dedicated infrastructure.

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-Classic

The 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.

Who this course is for:

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

Foundation to Oracle Database in Oracle Cloud Infrastructure

What you'll learn

Explore related topics

Course content

Introduction & About Myself1 lecture • 6min

Introduction to Cloud Computing5 lectures • 22min

Introduction to Oracle Cloud6 lectures • 28min

Oracle Cloud Infrastructure (Gen2 Cloud)11 lectures • 51min

Database Cloud Services9 lectures • 43min

Practical Scenarios Covering SSH Understanding & Connectivity in Cloud8 lectures • 32min

Conclusion1 lecture • 1min

Oracle Open World 2019 Enhancements1 lecture • 1min

Autonomous Databases5 lectures • 24min

New Course : Cybersecurity Fundamentals for Beginners - Learning with Demos1 lecture • 3min

Requirements

Description

Who this course is for: