SQL connect, loader, Data pump with Autonomous DB & Linux-VM

SQL connect, loader, Data pump with Autonomous DB & Linux-VM

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

Understand SQL tools - like SQL Developer ,Loader, Datapump &object storage on Oracle cloud Autonomous DB with Linux(VM)

Url: View Details

What you will 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

Rating: 0

Level: Intermediate Level

Duration: 4 hours

Instructor: Guha Rajan M., B.Engg, MBA, PMP