Oracle Data Integrator Web & Data Analysis-Autonomous DB
Build expertise in Oracle Data Integrator Web, Data Analysis & Data insights with Oracle Autonomous Database - OCI
What you will learn
Provisioning of Oracle Autonomous Database on Oracle Cloud infrastructure
Data loading to Cloud Autonomous Database from local & cloud
Extract & load from Source to Target Database using Oracle Cloud Transforms (web ODI)
Data transformation using Oracle Cloud transform (Web ODI)
Data Analysis & Data Insight tool in Oracle Cloud Infrastructure
One source to learn with hands-on activity for provisioning of Oracle DB, EL-T with web ODI, Data analysis & Data insight on Cloud - OCI
Why take this course?
Oracle Cloud Infrastructure (OCI) is a set of complementary cloud services that enable you to build and run a range of applications and services in a highly available hosted environment.
OCI provides Oracle Autonomous Database and associated DWH like EL-T & analysis tools on single platform, so that any one can build a prototype & then migrate it to OCI for commercial purpose too
From a learning perspective too, it become a effective single platform on which one can learn all about
Provision of Oracle Autonomous database:
Accessing database through Cloud console, Client SQL developer, Oracle Apex
ELT process through OCI-Data transform : Web Oracle Data integrator
Data Analysis
Data insights.
Following are the topics of coverage in this course:
•Getting Access to Oracle Cloud Infrastructure.
•What is a compartment in OCI & provisioning it.
•What is Autonomous Oracle DB and Provisioning the same.
•Access Autonomous Oracle DB on OCI
•Cloud Console.
•Client SQL developer.
•Oracle APEX.
•Data loading into Oracle Autonomous DB
•As local file
•Oracle cloud bucket.
•Overview about Datawarehouse and the extract, load & transform.
•Data loading using Data transform process
•Creating DB Connection & testing
•Initiating Data load from Source to Target.
• Data transformation using Web ODI & validation
• Dependency building between Dataflow – using workflow along with Jobs & schedule
•Dimensional Modelling
•Data analysis in OCI
•Data Insight in OCI
Happy Learning!