SQL connect, loader, Data pump with Autonomous DB & Linux-VM
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.
Instructor
Having over 25 + years of IT industry experience (Product development, Consulting & Training).
His last engagement was with Oracle India (initially with consulting and then with Oracle university) , which was for more than 12 years. Prior to this, had worked with Cap Gemini (formerly iGate Global Solution), GE to name a few.
Had managed projects and programs in Enterprise Resource Planning and Business Intelligence implementations in the range of 3000 man days with revenue about 6mil US$ per year. These projects are on industry domains, such as Oil and Gas, Process Manufacturing, Hi-Tech Retail & Telecom across the globe.
Was awarded with "pace setter" , "best managed " project awards in recognition of efforts in project management.
He was also instrumental in design, development and roll-out of Graduate Hire program on Oracle Products stack for partner IT services companies in recent times.
Right from college was fascinated about devices and sensor interaction with computer, which made him focus on micro-controller in early 90's and that eventually attracted him towards field of Internet of things and Machine learning, AI these days.
Due to his vast experience, he has crafted varied unique courses in Udemy related project management, Internet of things, ERP & BI, Database modeling and design, SQL, Linux and more importantly on Cloud Infrastructure. Has plans to create more, as his passion has been on knowledge acquisition and sharing.
He is certified as
Oracle Cloud Infrastructure 2021 Architect Professional.
Oracle Cloud Infrastructure 2021 Architect Associate.
Oracle Cloud Infrastructure 2021 Cloud Operations Associate.
Oracle Cloud Infrastructure Security 2021 Certified Associate
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Machine Learning using Autonomous Database 2021 Certified Specialist
Also certified in Python, IOT by NPTEL (Govt of India ) recently.
He holds a degree in engineering (Computer science) with MBA and a certified PMP since 2007