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.
This course is part of the Data Warehousing for Business Intelligence Specialization
28,029 already enrolled
Offered By


About this Course
6,536 recent views
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 3 of 5 in the
Approx. 22 hours to complete
English
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessSkills you will gain
- Data Warehousing
- Materialized View
- Data Warehouse
- SQL
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Course 3 of 5 in the
Approx. 22 hours to complete
English
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessOffered by
Syllabus - What you will learn from this course
4 hours to complete
DBMS Extensions and Example Data Warehouses
4 hours to complete
7 videos (Total 44 min), 14 readings, 1 quiz
6 hours to complete
SQL Subtotal Operators
6 hours to complete
5 videos (Total 39 min), 12 readings, 3 quizzes
5 hours to complete
SQL Analytic Functions
5 hours to complete
6 videos (Total 59 min), 12 readings, 3 quizzes
6 hours to complete
Materialized View Processing and Design
6 hours to complete
5 videos (Total 54 min), 11 readings, 3 quizzes
Reviews
- 5 stars67.52%
- 4 stars27.14%
- 3 stars3.09%
- 2 stars1.54%
- 1 star0.68%
TOP REVIEWS FROM RELATIONAL DATABASE SUPPORT FOR DATA WAREHOUSES
by RSMay 27, 2020
The most important topics are covered in a clear and organized way
by STAug 7, 2016
Well designed course to understand basic concepts and execute in project.
by DRMay 9, 2016
Enjoyed learning about the Rate to Ratio and Cumulative Distribution fuctions
by ANMay 29, 2016
This course was very exciting, a little bit difficult, but interesting. Thank Professor
About the Data Warehousing for Business Intelligence Specialization

Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.