Autonomous Database creation & access via – sqldeveloper, APEX, ML and Linux instance creation & Access (Char & GUI)
This unique course covers critical and essential concept of Oracle Cloud Infrastructure (OCI). To make understanding better there are demonstrations and Quiz as appropriate.
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).
Course Content
- Introduction –> 1 lecture • 7min.
- What’s cloud – Introduction –> 4 lectures • 27min.
- Oracle Cloud – Free tier access –> 2 lectures • 10min.
- Oracle Cloud Infrastructure Offering – An Overview –> 1 lecture • 6min.
- What is Autonomous Database? –> 1 lecture • 4min.
- Provisioning autonomous Database on Oracle cloud –> 2 lectures • 11min.
- Autonomous Database Developer tools –> 1 lecture • 7min.
- Using SQL developer web & client tool with Autonomous Data Base –> 3 lectures • 24min.
- Oracle APEX on cloud –> 5 lectures • 32min.
- Data Analytics and Visualization using Oracle Machine Learning (OML) –> 4 lectures • 30min.
- Oracle Cloud Infrastructure (Core) – Terminology & Virtualization –> 2 lectures • 28min.
- Cloud Core Infrastructure – Creating Oracle Linux instance –> 8 lectures • 41min.
- Cloud Core infrastructure – Creating & Access Oracle Linux in GUI mode –> 8 lectures • 38min.
- Installing and accessing Jupyter Notebook on Oracle Cloud Linux(VM) –> 2 lectures • 6min.
- Accessing Oracle Autonomous DB through Python –> 5 lectures • 35min.
- Bonus Lecture –> 1 lecture • 3min.
Requirements
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 VM
The topic 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)