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'll 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

Requirements

Access to Oracle Cloud infrastructure - OCI free tier

Basic understanding of Oracle RDBMS

Description

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 tooFrom 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 OCIHappy Learning!

Overview

Section 1: Introduction

Lecture 1 Topics of Coverage

Section 2: Getting Access to Oracle Cloud Infrastructure

Lecture 2 Getting Access to Oracle Cloud Infrastructure - Free tier - Part1

Lecture 3 Getting Access to Oracle Cloud Infrastructure - Part 2

Section 3: What is an Oracle Autonomous Database

Lecture 4 What is an Oracle Autonomous Database

Section 4: Significance of Compartment in OCI & Provisioning Compartment in OCI

Lecture 5 Significance of Compartment and provisioning compartment in OCI

Section 5: Provisioning Oracle Autonomous Database on Oracle Cloud Infrastructure

Lecture 6 Provisioning Oracle Autonomous Database on Oracle Cloud Infrastructure

Section 6: Different Option to connect to Oracle Autonomous Database

Lecture 7 Different option to connect to Autonomous DB

Lecture 8 Connecting through SQL Web to Autonomous DB

Lecture 9 Connecting through SQL Developer Client with DB wallet

Lecture 10 Connecting to DB with Oracle APEX

Section 7: Data loading to Autonomous DB with Developer tools

Lecture 11 Data loading using OCI console from local csv file

Lecture 12 Data loading using CSV stored in Cloud bucket

Section 8: Datawarehouse and Extract Load and Transform process Overview

Lecture 13 Datawarehouse and Extract, Load, Transform - overview

Section 9: Creation of Connection, Dataload Job & validation between Source and Target DB

Lecture 14 Creation of connection in Web ODI

Lecture 15 Initiating Dataload between Source & Target DB using Web Oracle Data Integrator

Lecture 16 Validation of Load Data on the Target DB

Section 10: Introduction to Data transformation with Web Oracle Data integrator

Lecture 17 Data transformation using Web Oracle Data Integrator - Demo

Lecture 18 Data Validation post Data Transformation = Demo

Section 11: Building Dependency between Data Flows using Workflow

Lecture 19 Building Dependency between Data Flows using Workflow

Section 12: OLAP - Dimensional Model and Data analysis tool in Oracle Cloud Autonomous DB

Lecture 20 Understanding Dimensional model.

Lecture 21 Data Analysis tool in OCI - Demo

Section 13: What's New - Data Insights - An overview

Lecture 22 What is Data Insight & its Significance

Lecture 23 Data insight tool with Oracle Autonomous Data base on OCI

Section 14: Concluding Remarks

Lecture 24 Concluding Remarks

IT Analysts,Engineering student with CSE / IT background,Management Students