Oracle SQL for Data Analytics and Data warehousing overview

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview – Topics of coverage

Chapter 2: Whats a business application?

Lecture 1: What is business application

Lecture 2: Difference between OLTP and OLAP

Chapter 3: Relational Database and SQL

Lecture 1: What is Relational Database?

Lecture 2: Business flows, ER diagrams and RDBMS

Lecture 3: Structured Query Language – Introduction

Lecture 4: ER Diagram – Tables commonly used in this course

Chapter 4: What is an Oracle Instance?

Lecture 1: What is an Oracle Instance?

Chapter 5: Quiz 1

Chapter 6: Difference environment to practice Oracle SQL

Lecture 1: Difference environment to practice Oracle SQL

Lecture 2: Oracle Apex SQL environment and dataset for learning

Chapter 7: Oracle SQL : Select statement – Arithmetic, Concatenate, Distinct functions

Lecture 1: Select statement – Arithmetic, Concatenate, Distinct functions

Lecture 2: Select Statement – Demonstration – Arithmetic, Concatenate, Distinct function

Chapter 8: Oracle SQL: Select Statement – Filtering data – using where clause

Lecture 1: Demonstration Select Statement – Filtering data – using where clause

Lecture 2: Oracle SQL: Select Statement-Filtering date – using where clause with Operators

Chapter 9: Oracle SQL: Select statement – Functions

Lecture 1: Oracle SQL: Select statement – Functions 1

Lecture 2: Oracle SQL: Select statement – Demonstration – Functions

Lecture 3: Oracle SQL: Select statement – Functions 2 – Nested, Case,Decode

Chapter 10: Quiz 2

Chapter 11: Analytics function used in Data warehousing / Business Intelligence

Lecture 1: Analytics functions – Min, Max, Avg, Nvl, Std dev

Lecture 2: Analytics functions – Demonstration – Min, Max, Avg, Nvl, Std dev

Lecture 3: Analytics functions – Group By and having clause

Lecture 4: Analytics functions – Demonstration – Group by and having clause

Lecture 5: Analytics functions – Rollup and Cube functions

Lecture 6: Analytics function – Demonstration – Rollup and Cube functions

Lecture 7: Analytics Function – Select statement – Hierarchical

Lecture 8: Analytics Functions – Select Statement – Demonstration – Hierarchical

Chapter 12: Oracle SQL : Retrieving Data from multiple tables – JOINS

Lecture 1: Different Types of Joins – Natural and equi joins

Lecture 2: Demonstration 1 – Natural and equi joins

Lecture 3: Demonstration 2 – Natural and Equi Joins

Lecture 4: Joining table to itself towards data retrieval – Self Joins

Lecture 5: Demonstration – Self Joins

Lecture 6: Outer Joins between tables

Lecture 7: Demonstration – Outer joins between tables

Lecture 8: Oracle SQL: What is subquery

Lecture 9: Demonstration – Subquery

Lecture 10: Other DMLs

Chapter 13: Quiz 3

Chapter 14: Data Definition Language

Lecture 1: Data Definition Language

Lecture 2: Demonstration – Data definition Language

Chapter 15: DB – Schema, Synonym, Sequence, Index – Overview

Lecture 1: DB – Schema, Synonym, Sequence, Index – Overview

Chapter 16: Do's, Don't and Tuning Sql – Overview

Lecture 1: Do's, Don't and Tuning Sql – Overview

Chapter 17: What is Data Dictionary?

Lecture 1: What is Data Dictionary?

Chapter 18: Quiz 4

Chapter 19: DataWarehouse and Business Intelligence : An overview

Lecture 1: DataWarehouse and Business intelligence

Lecture 2: Dimension models

Lecture 3: DWH Schema – Star and Snowflake schema

Lecture 4: Fact and Dimension table

Chapter 20: Quiz 5

Chapter 21: Bonus Lecture: Concluding remarks & Next steps

Lecture 1: Bonus Lecture: Concluding remarks & Next steps