Skills you'll gain

There are 6 modules in this course

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.

SQL Subtotal Operators

SQL Analytic Functions

Materialized View Processing and Design

Physical Design and Governance

SQL for Data Mining Input

Explore more from Data Analysis