What you'll learn

Creation and accessing OCI- Oracle Linux(VM) instance through SSH-putty

Provisioning Oracle Autonomous Database on Oracle Cloud

Installation and Configuring Oracle client tools towards access of Oracle Cloud Autonomous DB from Oracle Linux

Oracle Datapump feature

Oracle Datapump using SQL Developer / Oracle Linux

Oracle SQL loader feature from Oracle Linux.

Requirements

Basic knowledge of Linux command and SQL would be benefical

Access to Oracle Cloud Infrastruture (OCI) free tier.

Description

Oracle Cloud infrastructure (OCI) provides 2 Autonomous Oracle Database instance and 2 Virtual Machine (Linux) as always free tier.  This means Oracle provides some of the core services always free. This is very useful from learning and building POCs

Through this course one can learn.

Getting Access to Oracle Cloud Infrastructure (Free tier).

Creating Linux Virtual Machine in OCI.

Oracle Cloud Infrastructure offereing.

Overview about Oracle Cloud Infrastructure - Core terminaloty

Accessing the Linux Virtual Machine through Client SSH - USing Putty.

Provisioning Autonomous Oracle Database Instance.

Accessing the Database through Web SQL developer.

Accessing Cloud Autonomous Oracle DB through windows SQL developer client.

Installing Basic SQL client tools in Linux(VM).

Configuring Network connection for client tools with cloud Wallet file - TNSNAMES.ORA, SQLNET.ORA.

Connecting and accessing Autonomous Oracle Cloud Autonomous Database through SQL plus client,sql loader, Datapump from Oracle Linux (VM) instance.

Overview about SQL loader.

Invoking SQL Loader from Oralce Linux(VM) to load data into table in Oracle Autonomous DB.

What is Oracle Data Pump?

Oracle Data pump

        Through Client SQL Developer.

        Through Oracle Linux (VM).

Data transfer on cloud Object storage and local machine / Oracle Cloud Autonomous Database mounted directory.

Get in sight into the core tools functionality on Oracle Autonomous Database & Oracle Linux (VM) On Oracle Cloud Infrastructure (OCI).

With Cloud skill growing in demand, get in sight into the core tools functionality on Oracle Autonomous Database & Oracle Linux (VM) On Oracle Cloud Infrastructure (OCI).

Happy Learning.!

Who this course is for:

IT Developers with a flair to understand Oracle Cloud Infrastructure

IT Students.