Oracle Data Warehousing
Week-Wise schedule

Week 1 Day 1 Introduction to Data Warehousing
Day 2 Data Warehouse Design: Overview
Day 3 Characteristics of a Data Warehouse , Comparing OLTP and Data
Day 4 Data Warehouse Architectures
Day 5 Data Warehouse objects & Schemas
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 2 Day 1 Data Warehouse Tuning : Optimizing Star Queries
Day 2 Introducing Bitmap Join Indexes
Day 3 Understanding Star Query
Day 4 Optimization and Bitmap Joined Index
Day 5 Partitioning Basics : Partitioned Tables and Indexes
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 3 Day 1 Partitioning Methods : Partitioning Types Partition
Day 2 Pruning and Star queries
Day 3 Parallelism Concepts : Operations That Can Be Parallelized , How Parallel Execution Works?
Day 4 Degree of Parallelism : Parallel execution plan , Automatic Parallelism
Day 5 Parallel Operations in Data Warehouses : Query,DDL,DML
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 4 Day 1 Query Parallel DDL Parallel DML , Balancing the Workload
Day 2 ETL: Extraction and Transportation : Extraction Methods
Day 3 Capturing Data With Change Data
Day 4 Sources and Modes of Change Dat
Day 5 Publish and Subscribe Model: The Publisher and the Subscriber
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions
Week 5 Day 1 Synchronous and Asynchronous CDC
Day 2 Asynchronous AutoLog Mode and Asynchronous HotLog Mode
Day 3 Transportation in a Data Warehouse ,Transportable Tablespaces
Day 4 ETL: Loading : Loading Mechanisms
Day 5 Applications of External Tables : Defining external tables with SQL*Loader
Day 6 Login to take the quiz     Login to contribute quiz questions     Login as guide to review quiz questions

Back

List of Practice Lab Rooms to connect

No Practice Lab Rooms were created to connect