Build your ultimate AI agent
Course Description
In this course, you will learn how to use SQL to support decision making. It is based on a case study about an online movie rental company with a database about customer information, movie ratings, background information on actors and more. You will learn to apply SQL queries to study for example customer preferences, customer engagement, and sales development. This course also covers SQL extensions for online analytical processing (OLAP), which makes it easier to obtain key insights from multidimensional aggregated data.
Prerequisites
Curriculum
Course outline
1
Introduction to business intelligence for a online movie rental database
The first chapter is an introduction to the use case of an online movie rental company, called MovieNow and focuses on using simple SQL queries to extract and aggregated data from its database.
- Introduction to data driven decision making50 XP
- Exploring the database50 XP
- Exploring the table renting100 XP
- Filtering and ordering50 XP
- Working with dates100 XP
- Selecting movies100 XP
- Select from renting100 XP
- Aggregations - summarizing data50 XP
- Summarizing customer information100 XP
- Ratings of movie 25100 XP
- Examining annual rentals100 XP
2
Decision Making with simple SQL queries
More complex queries with GROUP BY, LEFT JOIN and sub-queries are used to gain insight into customer preferences.
3
Data Driven Decision Making with advanced SQL queries
The concept of nested queries and correlated nested queries is introduced and the functions EXISTS and UNION are used to categorize customers, movies, actors, and more.
4
Data Driven Decision Making with OLAP SQL queries
The OLAP extensions in SQL are introduced and applied to aggregated data on multiple levels. These extensions are the CUBE, ROLLUP and GROUPING SETS operators.
S
Data-Driven Decision Making in SQL
Course
Complete
