About 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.
Created by: University of Colorado System
Taught by: Michael Mannino, Associate Professor
Business School, University of Colorado Denver
| Basic Info |
Course 3 of 5 in the
Data Warehousing for Business Intelligence Specialization.
|
| Language | English |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
Syllabus
WEEK 1
DBMS Extensions and Example Data Warehouses
Module 1 introduces the course and covers concepts that provide a context for the remainder of this course. In the first two lessons, you’ll understand the objectives for the course and know what topics and assignments to expect. In the remaining lessons, you ...
7 videos, 14 readings
Graded: Module 1 quiz
WEEK 2
SQL Subtotal Operators
Now that you have the informational context for relational database support of data warehouses, you’ll start using relational databases to write business intelligence queries! In module 2, you will learn an important extension of the SQL SELECT statement for s...
5 videos, 12 readings
Graded: Module 2 quiz
Graded: Quiz for module 2 assignment
Graded: Assignment for module 2
WEEK 3
SQL Analytic Functions
After your experience using the SQL subtotal operators, you are ready to learn another important SQL extension for business intelligence applications. In module 3, you will learn about an extended processing model for SQL analytic functions that support common...
5 videos, 12 readings
Graded: Module 3 quiz
Graded: Quiz for module 3 assignment
Graded: Assignment for module 3
WEEK 4
Materialized View Processing and Design
After acquiring query formulation skills for development of business intelligence applications, you are ready to learn about DBMS extensions for efficient query execution. Business intelligence queries can use lots of resources so materialized view processing ...
5 videos, 11 readings
Graded: Module 4 quiz
Graded: Quiz for module 4 assignment
Graded: Assignment for module 4
WEEK 5
Physical Design and Governance
Module 5 finishes the course with a return to conceptual material about physical design technologies and data governance practices. You will learn about storage architectures, scalable parallel processing, big data issues, and data governance. After this modul...
5 videos, 5 readings
Graded: Module 5 quiz
FAQs
How It Works
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Creators
University of Colorado System
The University of Colorado is a recognized leader in higher education on the national and global stage. We collaborate to meet the diverse needs of our students and communities. We promote innovation, encourage discovery and support the extension of knowledge in ways unique to the state of Colorado and beyond.
Pricing
| Audit | Purchase Course | |
|---|---|---|
| Access to course materials | Available | Available |
| Access to graded materials | Not available | Available |
| Receive a final grade | Not available | Available |
| Earn a shareable Course Certificate | Not available | Available |
Ratings and Reviews
Good course overall. Wish we had some exercises on Data Integration in Oracle
Very Interesting Course
really good.
Coursera provides universal access to the world’s best education, partnering with top universities and organizations to offer courses online.
© 2017 Coursera Inc. All rights reserved.
SS
A Bit Tricky Yet Enjoyable Session.... Learn a lot with fun. This one is a lot more interesting course