DBMS Extensions and Example Data Warehouses-Course objectives
Course introduction video
()
Course objectives video lecture
()
Powerpoint lecture notes for lesson 1
Get help and meet other learners in this course. Join your discussion forums!
DBMS Extensions and Example Data Warehouses-Course topics and assignments
Course topics and assignments video lecture
()
Powerpoint lecture notes for lesson 2
Optional textbook
DBMS Extensions and Example Data Warehouses-DBMS extensions
DBMS extensions video lecture
()
Powerpoint lecture notes for lesson 3
DBMS Extensions and Example Data Warehouses-Relational database schema patterns
Relational database schema patterns video lecture
()
Powerpoint lecture notes for lesson 4
DBMS Extensions and Example Data Warehouses-Colorado Education Data Warehouse
Colorado Education Data Warehouse video lecture
()
Powerpoint lecture notes for lesson 5
DBMS Extensions and Example Data Warehouses-Data warehouse standards in health care
Data warehouse standards in health care video lecture
()
Powerpoint lecture notes for lesson 6
DBMS Extensions and Example Data Warehouses-Course software requirements
Overview of software requirements and installation
SQL statements for Store Sales tables
SQL statements for Inventory data warehouse tables
DBMS Extensions and Example Data Warehouses-Quiz
Optional textbook reading material
SQL Subtotal Operators-GROUP BY clause review
GROUP BY clause review video lecture
()
Powerpoint lecture notes for lesson 1
Additional problems for lesson 1
SQL Subtotal Operators-SQL CUBE operator
SQL CUBE operator video lecture
()
Powerpoint lecture notes for lesson 2
Additional problems for lesson 2
SQL Subtotal Operators-SQL ROLLUP operator
SQL ROLLUP operator video lecture
()
Powerpoint lecture notes for lesson 3
Additional problems for lesson 3
SQL Subtotal Operators-SQL GROUPING SETS operator
SQL GROUPING SETS operator video lecture
()
Powerpoint lecture notes for lesson 4
Additional problems for lesson 4
SQL Subtotal Operators-Variations of subtotal operators
Variations of subtotal operators video lecture
()
Powerpoint lecture notes for lesson 5
Additional problems for lesson 5
SQL Subtotal Operators-Quiz and Assignment
Optional textbook reading material
Module 2 Assignment
Self Evaluation for the Module 2 Assignment
SQL Analytic Functions-Processing Model and Basic Syntax
Processing Model and Basic Syntax video lecture
()
Powerpoint lecture notes for lesson 1
Additional problems for lesson 1
SQL Analytic Functions-Extended Syntax and Ranking Functions
Extended Syntax and Ranking Functions video lecture
()
Powerpoint lecture notes for lesson 2
Additional problems for lesson 2
SQL Analytic Functions-Window Comparisons I
Window Comparison I video lecture
()
Powerpoint lecture notes for lesson 3
Additional problems for lesson 3
SQL Analytic Functions-Window Comparisons II
Window Comparisons II video lecture
()
Powerpoint lecture notes for lesson 4
Additional problems for lesson 4
SQL Analytic Functions-Functions for Ratio Comparisons
Functions for Ratio Comparisons video lecture
()
PostgreSQL Query Patterns for RATIO_TO_REPORT
()
Powerpoint lecture notes for lesson 5
Additional problems for lesson 5
SQL Analytic Functions-Quiz and Assignment
Optional reading material
Module 3 Assignment
Self Evaluation for the Module 3 Assignment
Materialized View Processing and Design-Background on Traditional Views
Background on traditional views video lecture
()
Powerpoint lecture notes for lesson 1
Additional problems for lesson 1
Materialized View Processing and Design-Materialized view definition and processing
Materialized view definition and processing video lecture
()
Powerpoint lecture notes for lesson 2
Additional problems for lesson 2
Materialized View Processing and Design-Query Rewriting Rules
Query Rewriting Rules video lecture
()
Powerpoint lecture notes for lesson 3
Materialized View Processing and Design-Query Rewriting Examples
Query Rewriting Examples video lecture
()
Powerpoint lecture notes for lesson 4
Additional problems for lesson 4
Materialized View Processing and Design-Quiz and Assignment
Optional textbook reading material
Module 4 Assignment
Self Evaluation for the Module 4 Assignment
Physical Design and Governance-Storage Architectures
Storage Architectures video lecture
()
Powerpoint lecture notes for lesson 1
Physical Design and Governance-Scalable Parallel Processing Approaches
Scalable Parallel Processing Approaches video lecture
()
Powerpoint lecture notes for lesson 2
Physical Design and Governance-Big data issues
Big data issues video lecture
()
Powerpoint lecture notes for lesson 3
Physical Design and Governance-Data Governance
Data Governance video lecture
()
Powerpoint lecture notes for lesson 4
Physical Design and Governance-Quiz and Assignment
Optional textbook reading material
SQL for Data Mining Input-Motivation and Background
Video for Lesson 1
()
Slides for Lesson 1
SQL for Data Mining Input-SQL Coding for Simple Item Sets and Association Rules
Video for Lesson 2
()
Slides for Lesson 2
SQL Examples for Lesson 2
SQL Statements to Create and Populate the Order Entry Tables
SQL for Data Mining Input-Statement Patterns for Item Sets and Association Rules
Video for Lesson 3
()
Slides for Lesson 3
SQL Examples for Lesson 3
SQL for Data Mining Input-SQL Coding to Evaluate Association Rules
Video for Lesson 4
()
Slides for Lesson 4
SQL Examples for Lesson 4
SQL for Data Mining Input-SQL Coding to Generate Matrix Input for Association Rule Mining
Video for Lesson 5
()
Slides for Lesson 5
SQL Examples for Lesson 5
SQL for Data Mining Input-SQL Coding to Generate Nested Input for Association Rule Mining
Video for Lesson 6
()
Slides for Lesson 6
SQL Examples for Lesson 6
SQL for Data Mining Input-Overview of SQL for Training Data with Top Event History
Video for Lesson 7
()
Slides for Lesson 7
SQL for Data Mining Input-SQL Coding to Generate Training Data with Top Event History
Video for Lesson 8
()
Slides for Lesson 8
SQL Examples for Lesson 8
SQL for Data Mining Input-Closing
Closing Lecture
()
SQL for Data Mining Input-Quiz and Assignment
Assignment for Module 6
Self Evaluation for the Module 6 Assignment