Relational Database Support for Data Warehouses
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Course Summary
This course teaches you how to design relational databases that are robust, efficient and secure. You will also learn how to use SQL to extract data and gain insights from it.Key Learning Points
- Design robust and efficient relational databases
- Use SQL to extract insights from data
- Understand how to secure and protect data
Related Topics for further study
Learning Outcomes
- Ability to design robust and efficient relational databases
- Proficiency in SQL for data extraction
- Knowledge of data security best practices
Prerequisites or good to have knowledge before taking this course
- Basic knowledge of programming concepts
- Familiarity with databases
Course Difficulty Level
IntermediateCourse Format
- Self-paced online course
- Video lectures
- Quizzes and assignments
Similar Courses
- Database Management Essentials
- SQL for Data Analysis
- Data Warehousing for Business Intelligence
Notable People in This Field
- Kimball Group
- Martin Fowler
- CIO.com
Related Books
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. In the assignments in this course, you can use either Oracle or PostgreSQL.
Outline
- DBMS Extensions and Example Data Warehouses
- Course introduction video
- Course objectives video lecture
- Course topics and assignments video lecture
- DBMS extensions video lecture
- Relational database schema patterns video lecture
- Colorado Education Data Warehouse video lecture
- Data warehouse standards in health care video lecture
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Optional textbook
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Powerpoint lecture notes for lesson 5
- Powerpoint lecture notes for lesson 6
- Overview of software requirements
- Overview of database software installation
- Oracle installation notes
- Making connections to a local Oracle database
- SQL statements for Store Sales tables
- SQL statements for Inventory DW tables
- Optional textbook reading material
- Module 1 quiz
- SQL Subtotal Operators
- GROUP BY clause review video lecture
- SQL CUBE operator video lecture
- SQL ROLLUP operator video lecture
- SQL GROUPING SETS operator video lecture
- Variations of subtotal operators video lecture
- Powerpoint lecture notes for lesson 1
- Additional problems for lesson 1
- Powerpoint lecture notes for lesson 2
- Additional problems for lesson 2
- Powerpoint lecture notes for lesson 3
- Additional problems for lesson 3
- Powerpoint lecture notes for lesson 4
- Additional problems for lesson 4
- Powerpoint lecture notes for lesson 5
- Additional problems for lesson 5
- Optional textbook reading material
- Assignment notes
- Module 2 quiz
- Quiz for module 2 assignment
- SQL Analytic Functions
- Processing Model and Basic Syntax video lecture
- Extended Syntax and Ranking Functions video lecture
- Window Comparison I video lecture
- Window Comparisons II video lecture
- Functions for Ratio Comparisons video lecture
- PostgreSQL Query Patterns for RATIO_TO_REPORT
- Powerpoint lecture notes for lesson 1
- Additional problems for lesson 1
- Powerpoint lecture notes for lesson 2
- Additional problems for lesson 2
- Powerpoint lecture notes for lesson 3
- Additional problems for lesson 3
- Powerpoint lecture notes for lesson 4
- Additional problems for lesson 4
- Powerpoint lecture notes for lesson 5
- Additional problems for lesson 5
- Optional reading material
- Assignment notes
- Module 3 quiz
- Quiz for module 3 assignment
- Materialized View Processing and Design
- Background on traditional views video lecture
- Materialized view definition and processing video lecture
- Query Rewriting Rules video lecture
- Query Rewriting Examples video lecture
- Oracle Tools for Data Integration video lecture
- Powerpoint lecture notes for lesson 1
- Additional problems for lesson 1
- Powerpoint lecture notes for lesson 2
- Additional problems for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Additional problems for lesson 4
- Powerpoint lecture notes for lesson 5
- Additional problems for lesson 5
- Optional textbook reading material
- Assignment notes
- Module 4 quiz
- Quiz for module 4 assignment
- Physical Design and Governance
- Storage Architectures video lecture
- Scalable Parallel Processing Approaches video lecture
- Big data issues video lecture
- Data Governance video lecture
- Closing Lecture
- Powerpoint lecture notes for lesson 1
- Powerpoint lecture notes for lesson 2
- Powerpoint lecture notes for lesson 3
- Powerpoint lecture notes for lesson 4
- Optional textbook reading material
- Module 5 quiz
Summary of User Reviews
Discover the world of data warehousing with Coursera's DWRelational course. Students have praised this course for its comprehensive coverage and practical approach to the subject.Key Aspect Users Liked About This Course
comprehensive coveragePros from User Reviews
- Great course for beginners and those with some experience
- In-depth explanation of data warehousing concepts
- Real-world examples and hands-on assignments to reinforce learning
Cons from User Reviews
- Some users found the course content to be too basic
- A few technical issues reported with the online platform
- Minimal interaction with the instructor and limited opportunities for feedback
Michael Mannino
4.6 Raiting
Spring & Hibernate for Beginners (includes Spring Boot)
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Spring 5: Learn Spring 5 Core, AOP, Spring MVC, Spring Security, Spring REST, Spring Boot 2, Thymeleaf, JPA & Hibernate SPRING BOOT SECTION NOW INCLUDES OVER 6....
Full Stack Essential Training 2021: Front to Back
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Build Full Stack Apps & Spring Boot & Spring Security & Java & MySQL & Docker & Angular & Typescript & Bootstrap & Web...
FileMaker Pro 13 for beginners
- 4.3
-
![]()
![]()
![]()
![]()
![]()
This is a complete top to bottom course to learn database information management using FileMaker Pro for a beginner. Develop professional database information solutions!...
AWS Certified Data Analytics Specialty 2021 - Hands On!
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Practice exam included! AWS DAS-C01 certification prep course with exercises. Kinesis, EMR, DynamoDB, Redshift and more! Happy learning! ] But, even experienced technologists need to prepare heavily for this exam....
