Subscription Includes
$ 110   8.77

Basics of Oracle Cloud Infrastructure (OCI) - Always Free Tier

Created by GUHARAJANM, Last Updated 08-Jun-2021, Language:English

Basics of Oracle Cloud Infrastructure (OCI) - Always Free Tier

Oracle autonomous aatabase creation & access via - sqldeveloper, APEX, ML and Linux-VM instance creation & Access (Char & GUI)

Created by GUHARAJANM, Last Updated 08-Jun-2021, Language:English

What Will I Get ?

  • 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)


  • Knowledge on Oracle Database / SQL and Linux commands would be beneficial
  • Account with Oracle Cloud Infrastructure - Free tier access. The course guides you to get OCI account


About a year back, Oracle started offering Oracle Cloud infrastructure with Free tier offering. Its Unique among most of the Infrastructure cloud Offering. Oracle started offering their 2 instances of their Oracle Autonomous Database and 2 compute instance (like Linux) as always free. With above one can always learn & explore the POC of application of their choice, including building web site and hosting free of cost (an example).

This unique course covers critical and essential concept of Oracle Cloud Infrastructure (OCI). To make understanding better there are demonstrations and Quiz as appropriate.

The topics of coverage includes the following.

  • Cloud vs On Prem analogy – For better understanding of cloud.

  • What’s Cloud & its characteristics

  • Getting in & accessing Oracle Cloud infrastructure.

  • Oracle cloud infrastructure – components.

  • What’s autonomous Database.

  • Creating Autonomous Database on Cloud

  • Autonomous 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 data

Learn 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)

Course Content


CEO, Capstone Solutions, Trainer

 He is having over 25 + years of IT industry experience  (Product development, Consulting & Training).

Althrough his career he has worked on assignments with fortune 500 companies across the globe. His last engagement was with Oracle India (initially with Oracle 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.

Was also instrumental in design, development and roll-out of Graduate Hire program on Oracle Products & cloud 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  related project management, Internet of things, database modeling and design. Has plans to create more, as his passion has been on knowledge acquisition and sharing which he has acquired over 2 decades.

He holds a Bachelor's degree in engineering (Computer science) with MBA and a certified PMP since 2007