Companies Home Search Profile
TrainingHub TrainingHub

Oracle Data Integrator Web & Data Analysis-Autonomous DB

Focused View

Guha Rajan M., B.Engg, MBA, PMP

3:00:16

42 View
  • 1. Topics of Coverage.mp4
    06:17
  • 1. Getting Access to Oracle Cloud Infrastructure - Free tier - Part1.mp4
    04:42
  • 2. Getting Access to Oracle Cloud Infrastructure - Part 2.mp4
    05:36
  • 1. What is an Oracle Autonomous Database.mp4
    04:46
  • 1. Significance of Compartment and provisioning compartment in OCI.mp4
    04:10
  • 1. Provisioning Oracle Autonomous Database on Oracle Cloud Infrastructure.mp4
    07:48
  • 1. Different option to connect to Autonomous DB.mp4
    03:10
  • 2. Connecting through SQL Web to Autonomous DB.mp4
    06:40
  • 3. Connecting through SQL Developer Client with DB wallet.mp4
    10:49
  • 4. Connecting to DB with Oracle APEX.mp4
    10:39
  • 1.1 Countries.csv
  • 1.2 Days Months.xlsx
  • 1.3 Devices.xlsx
  • 1.4 Movie Sales 2020.zip
  • 1. Data loading using OCI console from local csv file.mp4
    09:21
  • 2. Data loading using CSV stored in Cloud bucket.mp4
    07:35
  • 1. Datawarehouse and Extract, Load, Transform - overview.mp4
    10:03
  • 1. Creation of connection in Web ODI.mp4
    08:28
  • 2. Initiating Dataload between Source & Target DB using Web Oracle Data Integrator.mp4
    08:59
  • 3. Validation of Load Data on the Target DB.mp4
    07:57
  • 1. Data transformation using Web Oracle Data Integrator - Demo.mp4
    10:17
  • 2. Data Validation post Data Transformation = Demo.mp4
    06:07
  • 1. Building Dependency between Data Flows using Workflow.mp4
    07:56
  • 1. Understanding Dimensional model..mp4
    10:01
  • 2. Data Analysis tool in OCI - Demo.mp4
    10:44
  • 1. What is Data Insight & its Significance.mp4
    07:24
  • 2. Data insight tool with Oracle Autonomous Data base on OCI.mp4
    07:15
  • 1. Concluding Remarks.mp4
    03:32

    • Description

    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

    Who is this for?

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

    • More details

    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 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!


    Who this course is for:

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

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category

    Oracle Data Integrator

    Guha Rajan M., B.Engg, MBA, PMP
    Guha Rajan M., B.Engg, MBA, PMP
    Instructor's Courses
    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 asOracle Cloud Infrastructure 2021 Architect Professional.Oracle Cloud Infrastructure 2021 Architect Associate.Oracle Cloud Infrastructure 2021 Cloud Operations Associate. Oracle Cloud Infrastructure Security 2021 Certified AssociateOracle Autonomous Database Cloud 2021 Certified SpecialistOracle Machine Learning using Autonomous Database 2021 Certified SpecialistAlso 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
    Udemy
    Udemy
    View courses Udemy
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 24
    • duration 3:00:16
    • Release Date 2023/04/11

    Courses related to Oracle Data Integrator

    Subtitle
    Tutorial Data Integration for Talend Practical for Beginners
    Udemy Ido Charar
    Ido Charar
    Tutorial Data Integration for Talend Practical for Beginners
    2:11:54
    English subtitles
    02/19/2023