Oracle Cloud Infrastructure (Oci) - Essentials

Autonomous Database creation & access via - sqldeveloper, APEX, ML and Linux instance creation & Access (Char & GUI)

What you'll learn
Oracle Cloud Infrastructure (OCI) - Understanding Key critical functionality & Key terminalogy
Provisioning and Setting up all new Oracle Cloud Autonomous Database
Autonomous Database access through Oracle SQL developer web & through Client
Oracle Apex functionality provisioning and Overview.
Data Analytics and Visualization through Oracle Machine learning notebook - Overview
Provisioning of Cloud - Oracle Linux environment and Access through SSH Putty
Creating Linux GUI environment and accessing through VNC
Installing & using Jupyter notebook (python) on Oracle Linux GUI environment
Accessing Oracle Cloud DB tables through Python (SODA)
Requirements
Knowledge on Oracle Database / SQL and Linux commands would be beneficial
Account with Oracle Cloud Infrastructure - Free tier access.
Access to Oracle Cloud Infrastructure (Free tier would be OK)
Description
This unique course covers critical and essential concept of Oracle Cloud Infrastructure (OCI). To make understanding better there are demonstrations and Quiz as appropriate.Oracle has restructured its Oracle cloud offering about a year back. Earlier it had offered Oracle cloud Infra only for 30 days as trial. Now they have included an always free tier service as well. This mean you can always use the Oracle cloud free tier service always free without restriction of any time period.  When one compares with other service provider the trials period is only for month, very few offer always free tier service but the feature or usage is very limited, unlike Oracle cloud.Oracle Cloud offer following in always free tier.Two Autonomous Oracle Database Two Compute engine - can be used to create Linux VMThe topic of coverage includes the following.Cloud vs On Prem analogy – For better understanding of cloud.What’s Cloud & its characteristicsGetting in & accessing Oracle Cloud infrastructure.Oracle cloud infrastructure – components.What’s autonomous Database.Creating Autonomous Database on CloudAutonomous Database tools - usage and associated demonstration.Accessing sql developer through web and sql developer client.Populating cloud table from spreadsheet.Oracle APEX tool•Creating workspace.•Navigation in Oracle APEX.•Loading data from spreadsheet.•Creating a simple report.Data analytics and visualization using Oracle ML.Oracle Cloud Infrastructure terminology.Compute Engine – creation of Oracle Linux instance on VM (Virtual machine) and access.Step by Step demonstration of creation of Linux instance and accessing it from Remote via putty.Computer Engine – Enabling the Oracle LINUX GUI and accessing through VNC.Installation and access -Jupyter Notebook on cloud Oracle Linux (VM) & access.SODA for Python - Using python to access the Autonomous DB table dataLearn about Oracle Cloud Infrastrucute (OCI) and Zoom up your career opportunities.. There are ample handson-demo to make understanding better.Happy learning and exploring Oracle Cloud Infrastructure (OCI)

Overview

Section 1: Introduction

Lecture 1 Course Overview - Topics of coverage

Section 2: What's cloud - Introduction

Lecture 2 Cloud vs On premise analogy

Lecture 3 Cloud Overview - Definition

Lecture 4 Cloud - Service models - Saas, Paas, Iaas

Lecture 5 Cloud Deployement models and advantage of Cloud over On-Premises

Section 3: Oracle Cloud - Free tier access

Lecture 6 Getting Oracle Cloud free tier access - Part 1

Lecture 7 Getting Oracle Cloud free tier access - Part 2

Section 4: Oracle Cloud Infrastructure Offering - An Overview

Lecture 8 Oracle Cloud Infrastructure Offering

Section 5: What is Autonomous Database?

Lecture 9 What is Autonomous Database?

Section 6: Provisioning autonomous Database on Oracle cloud

Lecture 10 Provisioning autonomous Database on Oracle cloud - Part 1

Lecture 11 Provisioning autonomous Database on Oracle cloud - Part 2

Section 7: Autonomous Database Developer tools

Lecture 12 Autonomous Database Developer tools

Section 8: Using SQL developer web & client tool with Autonomous Data Base

Lecture 13 Overview and connection with SQL developer web

Lecture 14 Creating table and populating table in Autonomous database

Lecture 15 Connecting with SQL developer client with Autonomous Database

Section 9: Oracle APEX on cloud

Lecture 16 Why to use Oracle APEX?

Lecture 17 Creation of Oracle APEX workspace

Lecture 18 Navigation in Oracle APEX

Lecture 19 Loading data and creation an application report using APEX

Lecture 20 Sample Application install and further learnings on APEX

Section 10: Data Analytics and Visualization using Oracle Machine Learning (OML)

Lecture 21 Creation of Oracle Machine Learning User

Lecture 22 Provisioning Zappelin Notebook - Export & Import

Lecture 23 Using SQL scripts for Data Visualization in OML

Lecture 24 Using Python Scripts for Data visualization in OML

Section 11: Oracle Cloud Infrastructure (Core) - Terminology & Virtualization

Lecture 25 Oracle Cloud Infrastructure (Core) - Terminalogy

Lecture 26 Virtualization Overview - Cloud

Section 12: Cloud Core Infrastructure - Creating Oracle Linux instance

Lecture 27 Oracle Cloud - Linux (VM) instance

Lecture 28 Steps involved in creating Oracle Linux cloud instance and access - Overview

Lecture 29 Creation of private and public keys using Puttygen - Prerequisite for access

Lecture 30 Creation of compartment and VCN(Virtual cloud network)

Lecture 31 Creation of cloud - Oracle Linux Vitual Machine (VM) instance

Lecture 32 Connecting to Oracle Linux Virtual instance through SSH - Putty

Lecture 33 Using SFTP to transfer files to cloud Linux (VM) instance

Lecture 34 Block Volume - Adding memory to instance

Section 13: Cloud Core infrastructure - Creating & Access Oracle Linux in GUI mode

Lecture 35 Oracle Linux (VM) instance GUI - Overview

Lecture 36 Steps in creating and accessing Cloud - Oracle Linux (VM) instance GUI

Lecture 37 Installation of server GUI and tiger VNC server

Lecture 38 Setting VNC access password and configuring VNC service file

Lecture 39 Starting VNC server and firewall entries for VNC server

Lecture 40 Dowloading tigerVNC client -viewer

Lecture 41 SSH client -Putty configuration

Lecture 42 Accessing Oracle Cloud Linux (VM) GUI

Section 14: Installing and accessing Jupyter Notebook on Oracle Cloud Linux(VM)

Lecture 43 Installing Jupyter Notebook on Oracle Cloud Linux(VM)

Lecture 44 Accessing Jupyter Notebook on Oracle Cloud Linux (VM)

Section 15: Accessing Oracle Autonomous DB through Python

Lecture 45 Simple Oracle Document Access(SODA) using python - Overview & Steps.

Lecture 46 Installing cx_Oracle and Ora instant Client on Oracle Cloud Linux instance(VM)

Lecture 47 Moving the Oracle Cloud Wallet files to Oracle cloud linux directory

Lecture 48 Connecting and Retrieving Autonomous DB table data using Python-Jupyter Notebook

Lecture 49 Changes to take care in windows environment

Section 16: Bonus Lecture

Lecture 50 Bonus Lecture

Software developers and IT engineer who wish to quickly upskill on Oracle Cloud Insfrastrucure,Computer science student who wish to explore Oracle Cloud Insfrastructure,Solution Architect - who wish to explore Oracle Cloud Infrastructure.