STARTS

May 22nd 2017

Relational Database Support for Data Warehouses (Coursera)

Taught 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.


Relational Database Support for Data Warehouses is course 3 of 5 in the Data Warehousing for Business Intelligence Specialisation.

Evaluate business needs; design a data warehouse; and integrate, and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.

Syllabus

Week 1: DBMS Extensions and Example Data Warehouses

Week 2: SQL Subtotal Operators

Week 3: SQL Analytic Functions

Week 4: Materialized View Processing and Design

Week 5: Physical Design and Governance