Oracle Data Integrator Web & Data Analysis-Autonomous DB

Learn how to access Oracle Cloud Infrastructure’s always free tier, including autonomous database options and Linux compute virtual machines for WordPress hosting, with credit card activation steps.

Learn how to request an Oracle Cloud Infrastructure account, enter required details, enable credit card verification, and resolve issues via Oracle customer service for the free tier.

Explore Oracle autonomous database in the cloud, which automates patching, upgrades, and tuning. Learn provisioning, OLTP and data warehousing workloads, and the shift from on‑prem to Oracle Cloud with Exadata.

Explore compartments in Oracle Cloud Infrastructure to isolate resources, move resources between compartments, and enforce single-compartment access for databases, virtual machines, and the virtual cloud network.

Provision an autonomous database on Oracle Cloud Infrastructure, choose transaction processing or data warehouse, and explore built-in ODI data integration for ELT workloads.

Provisioned Oracle autonomous database; connect to learn SQL or PL/SQL and build applications via three methods: dashboard web SQL client, SQL Developer client, and Oracle Apex.

Connect to the Oracle Autonomous Database using the web edition of SQL Developer, explore the free tier limits, and run a sample select from customers to view data.

Connect to an Oracle autonomous database using the SQL Developer client with a cloud wallet, test the connection, and run a select statement to view the customer table.

Use Oracle APEX to access the autonomous database and build low-code web applications, using built-in datasets such as employee and department to populate schemas.

Learn to create database users in the OCI console, enable web access, and load data from local csv files into a new schema using the data loader.

Load CSV data from a cloud bucket into an Oracle Autonomous Database using the OCI console, create users, and upload data from cloud storage.

Explore how data warehousing supports analytics by contrasting OLTP and OLAP, explaining normalized versus denormalized schemas, star and snowflake designs, and the ELT approach in Oracle ODI.

Learn to create a web-based Oracle Cloud Data Integrator connection, upload the wallet file, test the connection, and enable cross-database data extraction and loading between OLTP and data warehousing systems.

Initiate a data load from DB2 to Oracle DB using Web Oracle Data Integrator, transferring the products table into the user three schema and running the data-load job.

Validate data loads from the DB2 Oracle database to the Oracle target using Web ODI, verifying the products table in user three and understanding job creation, execution, and incremental loads.

Demonstrates data transformation with Web ODI by extracting, filtering movie sales by quarter, cleansing data, and loading results into a target table via a drag-and-drop data flow.

Review the data flow post transformation by validating loaded results, verifying target tables, and running SQL checks for April, May, and June filters.