Relational Database Support for Data Warehouses

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

Created by: Michael Mannino

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

icon
Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a electron course? Or looking for more detail on Michael Mannino's Relational Database Support for Data Warehouses? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community

icon
Course Description

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.

icon
Instructor Details

Michael Mannino

My involvement with database technology and education spans more than 35 years in academic positions, research, and consulting. I have been a faculty member at the University of Florida, University of Texas at Austin, and University of Washington before joining the Business School at the University of Colorado Denver. My work in this specialization is a culmination of teaching data warehouse development for 15 years along with writing a supporting textbook and conducting research projects. In my teaching, It is my pleasure and privilege to share my excitement and extensive background to help you embark on an adventure towards a rewarding and challenging career as a data warehouse or business intelligence professional.

icon
Reviews

4.6

57 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By saumya on 28-Jan-19

EXCELLENT COURSE

By Dushyant S on 2-Feb-19

Nice Course

By MOHIT K J on 11-Jan-19

Great course to learn the BI concepts

By Alejandro O B on 21-Aug-18

great

By Francisco I S R on 14-Oct-18

nice course very useful

By Robert L on 5-Mar-16

Yet again, professor Michael Mannino presents a very well prepared course that achieves optimal results in limited time. in this course, he ties everything together from the first two courses and gives good practice with real world requirements.just putting these courses on my CV helped me to get my first job with Data Warehouses. and then i found myself well prepared for the challenges of my new job. THANK YOU!

By Himanshu V on 25-Jun-16

Had a great experience

By Abhijit D on 11-Jun-16

Excellent Lessons taught by Prof. Maninho. Big Thanks.

By Thadi N on 11-Jun-16

Great

By Petrov A Y on 24-Dec-17

I learned a lot new from the course. It contains detailed explanations of all topics. Thanks.

By Matthew D on 12-Apr-17

I loved the SQL lessons in this course. There were lots of examples to practice.

By Matt L on 16-Sep-17

Enjoyable course - Professor Mannino has an excellent vision for periodically reviewing, repeating, then extending to new concepts, which is the right way to build skill. This course features subtotals and analytic functions in SQL, and query rewriting using materialized views. I am now at the point I have a lot of confidence with Oracle 12c and query capability. The problems are the right balance of meaningful challenge and skill building while still being able to complete them on evenings and weekends. In addition, the course delivers an understanding of context, technologies and platforms from which BI is created with trade-offs and policy important to commercial enterprise.