We may earn an affiliate commission when you visit our partners.
Michael Mannino
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/hkjh0e/relational
Here's a deal for you
Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Get offer
What's inside
Syllabus
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 will learn about DBMS extensions, a review of schema patterns, data warehouses used in practice problems and assignments, and examples of data warehouses in education and health care. This informational module will ensure that you have the background for success in later modules that emphasize details and hands-on skills. You should also read about the software requirements in the lesson at the end of module 1. I recommend that you install Oracle Cloud or PostgreSQL this week before assignments begin in week 2. If you have taken other courses in the specialization, you may already have installed Oracle Cloud or PostgreSQL.
Read more
Syllabus
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 will learn about DBMS extensions, a review of schema patterns, data warehouses used in practice problems and assignments, and examples of data warehouses in education and health care. This informational module will ensure that you have the background for success in later modules that emphasize details and hands-on skills. You should also read about the software requirements in the lesson at the end of module 1. I recommend that you install Oracle Cloud or PostgreSQL this week before assignments begin in week 2. If you have taken other courses in the specialization, you may already have installed Oracle Cloud or PostgreSQL.
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Examines SQL for data mining, which is valuable for experts in the industry
Taught by Michael Mannino, who is recognized for their work in data warehousing for business intelligence
Develops SQL skills, which are highly relevant in an academic setting for data warehousing and business intelligence
Instructs learners on query formulation for data mining tasks, which is unique and provides an edge in the workplace
Provides optional advanced material for advanced query formulation skills, which is useful for learners seeking expert-level knowledge
Offers interactive materials, such as practice problems and graded assignments, which strengthen an existing foundation for intermediate learners
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Practical sql for data warehouses
According to learners, this course provides a largely positive experience, focusing on essential SQL techniques for data warehousing and business intelligence. Students particularly highlight the value of learning SQL analytic functions, materialized views, and aggregate operators like CUBE and ROLLUP. The assignments are frequently described as hands-on, practical, and effective at solidifying understanding, although some found them challenging. The instructor, Professor Rundensteiner, is noted as knowledgeable and engaging. A common warning is the potential difficulty with the technical setup, specifically the installation of Oracle or PostgreSQL.
May benefit from existing SQL experience.
"The pace felt right for someone with some prior SQL knowledge."
"...applying them in the assignments felt like a jump in difficulty. Might be better suited for those with more prior experience."
"The assignments require good SQL skills, which is appropriate for the topic."
Professor Rundensteiner is knowledgeable.
"Professor Rundensteiner is engaging and knows his stuff."
"Professor Rundensteiner is knowledgeable and engaging."
"The instructor's passion for the subject is evident."
Hands-on practice that solidifies learning.
"Assignments were challenging but fair, helping solidify understanding."
"The assignments using either Oracle or PostgreSQL are hands-on and highly valuable."
"Assignments were practical and reinforced learning effectively."
"Assignments were challenging but very rewarding."
Covers key SQL for BI/DW like analytic functions.
"The material on SQL analytic functions and materialized views is particularly useful for anyone working with data warehouses or large databases."
"Excellent course that dives into the practical SQL techniques (ROLLUP, CUBE, Analytic Functions) essential for data warehousing."
"Analytic functions and CUBE/ROLLUP were explained thoroughly."
"Covers essential SQL techniques for data warehouses like analytic functions and aggregate extensions."
Database installation can be a pain point.
"Installation of Oracle or PostgreSQL can be a bit tricky for some..."
"The instructions for setup (specifically Oracle Cloud) were not as clear as they could be, leading to frustration."
"However, the technical setup (Oracle) was a major pain point."
"Setup instructions for the database could be improved, but overall, the hands-on practice is very valuable."
"Setup can be an issue."
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Relational Database Support for Data Warehouses with these
activities:
Read 'Data Warehouses: Theory and Practice'
Show steps
Gain essential background knowledge and best practices from industry experts.
View
Corporate Information Factory
on Amazon
Show steps
-
Read chapters 1-4 to gain foundational understanding
-
Review the case studies and examples
-
Take notes and summarize key concepts
Oracle SQL Developer Tutorial for SQL Subtotal Operators
Show steps
Learn how to use SQL subtotal operators to summarize data, a core skill for data warehouse analysis.
Browse courses on
SQL
Show steps
-
Follow the tutorial for guided practice using SQL
Develop SQL queries using analytic functions
Show steps
Solidify your understanding of SQL analytic functions through hands-on query building.
Browse courses on
SQL
Show steps
-
Create sample data and tables
-
Practice writing queries using analytic functions, such as RANK, LAG, andPERCENTILE_CONT
-
Analyze the results and compare different functions
Four other activities
Expand to see all activities and additional details
Show all seven activities
Solve SQL Analytic Functions exercises on LeetCode
Show steps
Enhance your problem-solving skills with challenging SQL analytic functions exercises.
Browse courses on
SQL
Show steps
-
Attempt the 'Evaluate Expression' problem
-
Work through the 'Count Good Nodes in Binary Tree' exercise
Write a technical blog post on Materialized Views
Show steps
Deepen your knowledge and share your understanding of Materialized Views, a key concept for optimizing query performance.
Browse courses on
Data Warehousing
Show steps
-
Research the topic thoroughly
-
Write a draft of the blog post
-
Proofread and refine your post
Collaborate on a data warehouse design project
Show steps
Apply your knowledge in a collaborative setting, enhancing your teamwork and communication skills.
Browse courses on
Data Warehousing
Show steps
-
Form a team with other learners
-
Brainstorm and develop a data warehouse design
-
Present your project to the class
Attend a workshop on Data Governance and Data Quality
Show steps
Gain insights from experts and stay current with best practices in data governance and quality.
Browse courses on
Data Warehousing
Show steps
-
Register for the workshop
-
Actively participate in the workshop sessions
-
Follow up on any recommended resources
Read 'Data Warehouses: Theory and Practice'
Show steps
Gain essential background knowledge and best practices from industry experts.
View
Corporate Information Factory
on Amazon
Show steps
Show steps
Show steps
- Read chapters 1-4 to gain foundational understanding
- Review the case studies and examples
- Take notes and summarize key concepts
Oracle SQL Developer Tutorial for SQL Subtotal Operators
Show steps
Learn how to use SQL subtotal operators to summarize data, a core skill for data warehouse analysis.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Follow the tutorial for guided practice using SQL
Develop SQL queries using analytic functions
Show steps
Solidify your understanding of SQL analytic functions through hands-on query building.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Create sample data and tables
- Practice writing queries using analytic functions, such as RANK, LAG, andPERCENTILE_CONT
- Analyze the results and compare different functions
Four other activities
Expand to see all activities and additional details
Show all seven activities
Solve SQL Analytic Functions exercises on LeetCode
Show steps
Enhance your problem-solving skills with challenging SQL analytic functions exercises.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Attempt the 'Evaluate Expression' problem
- Work through the 'Count Good Nodes in Binary Tree' exercise
Write a technical blog post on Materialized Views
Show steps
Deepen your knowledge and share your understanding of Materialized Views, a key concept for optimizing query performance.
Browse courses on
Data Warehousing
Show steps
Show steps
Show steps
- Research the topic thoroughly
- Write a draft of the blog post
- Proofread and refine your post
Collaborate on a data warehouse design project
Show steps
Apply your knowledge in a collaborative setting, enhancing your teamwork and communication skills.
Browse courses on
Data Warehousing
Show steps
Show steps
Show steps
- Form a team with other learners
- Brainstorm and develop a data warehouse design
- Present your project to the class
Attend a workshop on Data Governance and Data Quality
Show steps
Gain insights from experts and stay current with best practices in data governance and quality.
Browse courses on
Data Warehousing
Show steps
Show steps
Show steps
- Register for the workshop
- Actively participate in the workshop sessions
- Follow up on any recommended resources
Career center
Learners who complete Relational Database Support for Data Warehouses will develop knowledge and skills
that may be useful to these careers:
Data Warehouse Architect
Data Warehouse Architect
A Data Warehouse Architect designs and builds data warehouses, which are used to store and manage large amounts of data. They work with business stakeholders to understand their data needs, and then design and implement data warehouse solutions that meet those needs. In this course, you will learn the fundamentals of data warehousing, including data modeling, data integration, and data quality. This knowledge will be essential for success in a role as a Data Warehouse Architect.
Data Warehouse Manager
Data Warehouse Manager
A Data Warehouse Manager is responsible for the overall management of a data warehouse. They work with data warehouse architects and developers to ensure that the data warehouse is running smoothly and efficiently, and they also work with business stakeholders to ensure that the data warehouse is meeting their needs. In this course, you will learn the fundamentals of data warehouse management, including data governance, data security, and data quality management. This knowledge will be essential for success in a role as a Data Warehouse Manager.
Data Warehouse Developer
Data Warehouse Developer
A Data Warehouse Developer builds and maintains data warehouses. They work with data warehouse architects to design and implement data warehouse solutions, and they also write code to extract, transform, and load data into data warehouses. In this course, you will learn how to use SQL to extract, transform, and load data, and how to develop data warehouse applications. This knowledge will be essential for success in a role as a Data Warehouse Developer.
Data Integration Architect
Data Integration Architect
A Data Integration Architect designs and implements data integration solutions. They work with business stakeholders to understand their data needs, and they design and implement data integration solutions that meet those needs. In this course, you will learn the fundamentals of data integration, including data modeling, data mapping, and data transformation. This knowledge will be essential for success in a role as a Data Integration Architect.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst helps businesses understand their data and make better decisions. They use data analysis and visualization tools to identify trends and patterns in data, and to develop insights that can help businesses improve their performance. In this course, you will learn how to use SQL to query and analyze data, and how to use data visualization tools to present your findings. This knowledge will be essential for success in a role as a Business Intelligence Analyst.
Data Governance Analyst
Data Governance Analyst
A Data Governance Analyst develops and implements data governance policies and procedures. They work with business stakeholders to understand their data needs, and they develop policies and procedures to ensure that data is used in a consistent and reliable manner. In this course, you will learn the fundamentals of data governance, including data quality management, data security, and data privacy. This knowledge will be essential for success in a role as a Data Governance Analyst.
Data Analyst
Data Analyst
A Data Analyst collects, cleans, and analyzes data to provide insights that can help businesses make better decisions. They use a variety of statistical and data mining techniques to identify trends and patterns in data. In this course, you will learn how to use SQL to query and analyze data, and how to use data visualization tools to present your findings. This knowledge will be essential for success in a role as a Data Analyst.
Database Analyst
Database Analyst
A Database Analyst designs and develops database systems. They work with business stakeholders to understand their data needs, and they design and implement database solutions that meet those needs. In this course, you will learn the fundamentals of database design and development, including data modeling, query optimization, and performance tuning. This knowledge will be essential for success in a role as a Database Analyst.
Data Architect
Data Architect
A Data Architect designs and develops data architectures. They work with business stakeholders to understand their data needs, and they design and implement data architectures that meet those needs. In this course, you will learn the fundamentals of data architecture, including data modeling, data integration, and data governance. This knowledge will be essential for success in a role as a Data Architect.
Data Privacy Analyst
Data Privacy Analyst
A Data Privacy Analyst is responsible for ensuring that data is used in a compliant and ethical manner. They work with business stakeholders to understand their data privacy needs, and they develop and implement data privacy policies and procedures to ensure that data is used in a compliant and ethical manner. In this course, you will learn the fundamentals of data privacy, including data protection laws and regulations, data security, and data ethics. This knowledge will be essential for success in a role as a Data Privacy Analyst.
Data Security Analyst
Data Security Analyst
A Data Security Analyst is responsible for ensuring that data is protected from unauthorized access, use, disclosure, disruption, modification, or destruction. They work with business stakeholders to understand their data security needs, and they develop and implement data security policies and procedures to ensure that data is protected from unauthorized access, use, disclosure, disruption, modification, or destruction. In this course, you will learn the fundamentals of data security, including data encryption, data access control, and data backup and recovery. This knowledge will be essential for success in a role as a Data Security Analyst.
Data Quality Analyst
Data Quality Analyst
A Data Quality Analyst is responsible for ensuring that data is accurate, complete, and consistent. They work with business stakeholders to understand their data needs, and they develop and implement data quality policies and procedures to ensure that data meets those needs. In this course, you will learn the fundamentals of data quality management, including data profiling, data cleansing, and data validation. This knowledge will be essential for success in a role as a Data Quality Analyst.
Data Scientist
Data Scientist
A Data Scientist is a highly skilled professional who uses data to solve business problems. They have a deep understanding of data mining, machine learning, and statistical modeling. In this course, you will learn how to use SQL to query and analyze data, and how to use data mining techniques to identify trends and patterns in data. This knowledge will be essential for success in a role as a Data Scientist.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software applications. They work with business stakeholders to understand their software needs, and they design and develop software applications that meet those needs. In this course, you will learn the fundamentals of software engineering, including software design, software development, and software testing. This knowledge will be essential for success in a role as a Software Engineer.
Database Administrator
Database Administrator
A Database Administrator, also known as a DBA, ensures that an organization's databases run smoothly, securely, and optimally. They also manage and maintain the physical and logical structure of databases, including storage, memory, and access control. In this course, you will learn the fundamentals of relational database management systems, including data modeling, query optimization, and performance tuning. This knowledge will be essential for success in a role as a Database Administrator.
For more career information including salaries, visit:
OpenCourser.com/course/hkjh0e/relational
Reading list
We've selected 24 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Relational Database Support for Data Warehouses.
This classic text on database systems provides a comprehensive overview of the field, from basic concepts to advanced topics. It valuable resource for both students and professionals.
Offers comprehensive insights into dimensional modeling, a critical concept in data warehousing.
Practical guide to dimensional modeling, a key technique for designing data warehouses. It must-read for anyone who wants to build a successful data warehouse.
Offers accessible explanations and practical examples of data analytics concepts, providing a broader context for the course's focus on relational database support.
This comprehensive reference guide provides a detailed overview of Oracle Database 12c, covering all aspects of data warehousing, from design and implementation to administration and maintenance. It is an invaluable resource for learners who wish to gain in-depth knowledge of Oracle's data warehousing capabilities.
Provides a comprehensive overview of ETL (Extraction, Transformation, and Load) processes in data warehousing. It valuable resource for learners who wish to gain a deeper understanding of the techniques and best practices involved in data integration and data warehousing.
Provides a comprehensive overview of SQL, a powerful language for data manipulation and analysis. It valuable resource for both students and professionals who want to learn about SQL.
Provides a comprehensive overview of data mining, a powerful technique for extracting knowledge from data. It valuable resource for both students and professionals who want to learn about data mining.
Save
Provides a comprehensive overview of database administration, a critical role for ensuring the smooth operation of databases. It valuable resource for both students and professionals who want to learn about database administration.
Provides a thorough introduction to data warehousing concepts and technologies. It useful resource for both beginners and experienced data warehouse professionals.
Provides a comprehensive overview of business intelligence and data warehousing. It valuable resource for both students and professionals who want to learn about business intelligence and data warehousing.
Save
Provides a comprehensive overview of data mining techniques. It valuable resource for both students and professionals who want to learn about data mining.
Offers a comprehensive overview of the Hadoop ecosystem, including Hadoop Distributed File System (HDFS), MapReduce, and Hive. While it is not directly focused on data warehousing, it provides valuable insights into big data processing technologies that can be used in conjunction with data warehouses.
Save
This widely used textbook covers a broad range of data mining concepts and techniques, providing learners with a strong foundation in the field. It valuable resource for those interested in exploring data mining in the context of data warehouses.
Save
Provides a comprehensive overview of data governance, a critical practice for ensuring the accuracy, completeness, and security of data. It valuable resource for both students and professionals who want to learn about data governance.
Provides a comprehensive overview of Apache Spark, a popular big data processing framework. While it is not directly focused on data warehousing, it offers valuable insights into big data processing technologies that can be used in conjunction with data warehouses.
Save
Provides a comprehensive overview of big data technologies and best practices. It valuable resource for both students and professionals who want to learn about big data.
Save
Provides a concise overview of SQL, a powerful language for data manipulation and analysis. It valuable resource for both students and professionals who want to learn about SQL.
Provides detailed information about Oracle's data warehousing solutions, complementing the course's coverage of Oracle Cloud.
Provides a detailed overview of Oracle data warehousing technologies. It useful resource for both Oracle data warehouse administrators and developers.
Provides a solid foundation in data mining and machine learning techniques, complementing the course's optional module on SQL for data mining input.
Save
Offers practical guidance on using R for data science tasks, providing additional insights into data analysis and visualization.
Provides comprehensive coverage of using Python for data analysis, complementing the course's focus on SQL.
Save
Provides insights into the emerging concept of data mesh, complementing the course's coverage of data governance and physical design.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/hkjh0e/relational
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Rating
4.6
Effort
71 hours to complete
Via
Coursera
Institution
University of Colorado System
Instructor
Michael Mannino
Language
English
Transcripts
Español
Français
Português
Deutsch
Italiano
中文
العربية
한국어
日本語
हिंदी
Nederlands
Svenska
Pусский
Türkçe
Polski
Ελληνικά
українська мова
magyar nyelv
Bahasa Indonesia
ไทย
қазақша
اُردُو,
فارسی
বাংলা
پښتو
آذربایجان دیلی
This course belongs to a
collection
called
Data Warehousing for Business Intelligence. It's comprised of five courses:
- Relational Database Support for Data Warehouses (viewing)
- Data Warehouse Concepts, Design, and Data Integration
- Business Intelligence Concepts, Tools, and Applications
- Design and Build a Data Warehouse for Business Intelligence Implementation
- Database Management Essentials
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser