Buy Now AED 239.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Relational Database Support for Data Warehouses
  • Level Foundation
  • المدة 71 ساعات hours
  • الطبع بواسطة University of Colorado System
  • Offered by

عن

Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.

الوحدات

Course objectives

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • Course introduction video
  • Course objectives video lecture

2 Readings

  • Powerpoint lecture notes for lesson 1
  • Get help and meet other learners in this course. Join your discussion forums!

Course topics and assignments

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Course topics and assignments video lecture

2 Readings

  • Powerpoint lecture notes for lesson 2
  • Optional textbook

DBMS extensions

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • DBMS extensions video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Relational database schema patterns

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Relational database schema patterns video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Colorado Education Data Warehouse

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Colorado Education Data Warehouse video lecture

1 Readings

  • Powerpoint lecture notes for lesson 5

Data warehouse standards in health care

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data warehouse standards in health care video lecture

1 Readings

  • Powerpoint lecture notes for lesson 6

Course software requirements

    • 3 Readings
Show info about module content

3 Readings

  • Overview of software requirements and installation
  • SQL statements for Store Sales tables
  • SQL statements for Inventory data warehouse tables

Quiz

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Module 1 concept quiz

1 Readings

  • Optional textbook reading material

GROUP BY clause review

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • GROUP BY clause review video lecture

2 Readings

  • Powerpoint lecture notes for lesson 1
  • Additional problems for lesson 1

SQL CUBE operator

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • SQL CUBE operator video lecture

2 Readings

  • Powerpoint lecture notes for lesson 2
  • Additional problems for lesson 2

SQL ROLLUP operator

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • SQL ROLLUP operator video lecture

2 Readings

  • Powerpoint lecture notes for lesson 3
  • Additional problems for lesson 3

SQL GROUPING SETS operator

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • SQL GROUPING SETS operator video lecture

2 Readings

  • Powerpoint lecture notes for lesson 4
  • Additional problems for lesson 4

Variations of subtotal operators

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Variations of subtotal operators video lecture

2 Readings

  • Powerpoint lecture notes for lesson 5
  • Additional problems for lesson 5

Quiz and Assignment

    • 3 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Module 2 concept quiz
  • Quiz for the module 2 assignment
  • Reflective Quiz for the Module 2 Assignment

3 Readings

  • Optional textbook reading material
  • Module 2 Assignment
  • Self Evaluation for the Module 2 Assignment

Processing Model and Basic Syntax

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Processing Model and Basic Syntax video lecture

2 Readings

  • Powerpoint lecture notes for lesson 1
  • Additional problems for lesson 1

Extended Syntax and Ranking Functions

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Extended Syntax and Ranking Functions video lecture

2 Readings

  • Powerpoint lecture notes for lesson 2
  • Additional problems for lesson 2

Window Comparisons I

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Window Comparison I video lecture

2 Readings

  • Powerpoint lecture notes for lesson 3
  • Additional problems for lesson 3

Window Comparisons II

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Window Comparisons II video lecture

2 Readings

  • Powerpoint lecture notes for lesson 4
  • Additional problems for lesson 4

Functions for Ratio Comparisons

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • Functions for Ratio Comparisons video lecture
  • PostgreSQL Query Patterns for RATIO_TO_REPORT

2 Readings

  • Powerpoint lecture notes for lesson 5
  • Additional problems for lesson 5

Quiz and Assignment

    • 3 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Module 3 concept quiz
  • Quiz for the Module 3 Assignment
  • Reflective Quiz for the Module 3 Assignment

3 Readings

  • Optional reading material
  • Module 3 Assignment
  • Self Evaluation for the Module 3 Assignment

Background on Traditional Views

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Background on traditional views video lecture

2 Readings

  • Powerpoint lecture notes for lesson 1
  • Additional problems for lesson 1

Materialized view definition and processing

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Materialized view definition and processing video lecture

2 Readings

  • Powerpoint lecture notes for lesson 2
  • Additional problems for lesson 2

Query Rewriting Rules

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Query Rewriting Rules video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Query Rewriting Examples

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Query Rewriting Examples video lecture

2 Readings

  • Powerpoint lecture notes for lesson 4
  • Additional problems for lesson 4

Quiz and Assignment

    • 3 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Module 4 concept quiz
  • Quiz for the module 4 assignment
  • Reflective Quiz for the Module 4 Assignment

3 Readings

  • Optional textbook reading material
  • Module 4 Assignment
  • Self Evaluation for the Module 4 Assignment

Storage Architectures

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Storage Architectures video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Scalable Parallel Processing Approaches

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Scalable Parallel Processing Approaches video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Big data issues

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Big data issues video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Data Governance

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data Governance video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Quiz and Assignment

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Module 5 concept quiz

1 Readings

  • Optional textbook reading material

Motivation and Background

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Video for Lesson 1

1 Readings

  • Slides for Lesson 1

SQL Coding for Simple Item Sets and Association Rules

    • 1 Videos
    • 3 Readings
Show info about module content

1 Videos

  • Video for Lesson 2

3 Readings

  • Slides for Lesson 2
  • SQL Examples for Lesson 2
  • SQL Statements to Create and Populate the Order Entry Tables

Statement Patterns for Item Sets and Association Rules

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Video for Lesson 3

2 Readings

  • Slides for Lesson 3
  • SQL Examples for Lesson 3

SQL Coding to Evaluate Association Rules

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Video for Lesson 4

2 Readings

  • Slides for Lesson 4
  • SQL Examples for Lesson 4

SQL Coding to Generate Matrix Input for Association Rule Mining

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Video for Lesson 5

2 Readings

  • Slides for Lesson 5
  • SQL Examples for Lesson 5

SQL Coding to Generate Nested Input for Association Rule Mining

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Video for Lesson 6

2 Readings

  • Slides for Lesson 6
  • SQL Examples for Lesson 6

Overview of SQL for Training Data with Top Event History

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Video for Lesson 7

1 Readings

  • Slides for Lesson 7

SQL Coding to Generate Training Data with Top Event History

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Video for Lesson 8

2 Readings

  • Slides for Lesson 8
  • SQL Examples for Lesson 8

Closing

    • 1 Videos
Show info about module content

1 Videos

  • Closing Lecture

Quiz and Assignment

    • 2 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept Quiz for Module 6
  • Reflective Quiz for the Module 6 Assignment

1 Discussions

  • Revisions in lessons 7 and 8

2 Readings

  • Assignment for Module 6
  • Self Evaluation for the Module 6 Assignment

Auto Summary

"Relational Database Support for Data Warehouses" is a foundational course in the Data Science & AI domain, offered by Coursera. It focuses on using SQL for business intelligence, managing summary data, and understanding data warehouse implementations. The course covers storage architectures, scalable parallel processing, data governance, and big data impacts, with hands-on assignments using Oracle or PostgreSQL. Available with Starter, Professional, and Paid subscriptions, this course is ideal for those looking to enhance their data warehousing skills for business intelligence.

Michael Mannino
Instructor

Michael Mannino