Data-Driven Decision Making in SQL
Course facts
- Payment: Free Preview (Paid Upgrade)
- Learning style: Self-paced, start anytime
- Format: Text & Interactive
- Video access: Streaming Only
- Before you start: Data Manipulation in SQL
DataCamp details
- Chapters: 4
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Use SQL to answer business questions on a movie rental database with joins, nested queries and the OLAP operators CUBE, ROLLUP and GROUPING SETS.
Business questions about customers, films and revenue often sit inside a relational database, and answering them takes SQL that goes past a single SELECT. Working with the records of MovieNow, a fictional online movie rental company, you query customer details, ratings and actor data to study preferences, engagement and how rentals and income develop over time. Later lessons bring in the SQL extensions for online analytical processing, which summarize data across several dimensions at once.
What You Will Achieve
- Answer quick questions about the rental business, such as annual rentals or one movie’s ratings, with short queries
- Combine ratings, customer and actor records to name the favorite actors and movies of a customer group
- Pick out frequent customers, low raters and above-average movies by placing one query inside another
- Summarize ratings and customer counts by country, genre and gender on several levels in a single OLAP query
Program Overview
Exploring the Movie Rental Database
Introduces the MovieNow rental case and uses simple queries to pull, filter and summarize the records held in its tables.
- The MovieNow case and its tables
- Filtering, ordering and working with dates
- Aggregations that summarize data
Grouping, Joins and Nested Queries
Builds insight into customer preferences with grouped and joined queries, then sorts customers, movies and actors into categories with nested logic.
- GROUP BY, LEFT JOIN and sub-queries
- Revenue, rentals and KPIs per country
- Correlated nested queries
- EXISTS, UNION and INTERSECT
OLAP Operators for Aggregated Data
Applies three OLAP operators to aggregate data on several levels and closes with queries that combine the methods taught earlier.
- The CUBE operator
- ROLLUP
- GROUPING SETS
- Combined queries on genre and actor preferences
Certificate Awarded (Paid)
Job Outlook
Querying a business database to track customer engagement, product performance and revenue is everyday work in analytics and business intelligence teams that report to decision makers.
Good for: Analysts and SQL users who want practice turning queries into answers about customers, movies and revenue while working through one consistent case study.
Keep in mind: Every exercise works on one fictional movie rental database, so carrying the query patterns over to your own tables is left to you.
Bottom line: A case-study course that ties each query to a business question about the rental company, with a closing chapter on CUBE, ROLLUP and GROUPING SETS.
Frequently Asked Questions
What is OLAP in SQL?
Online analytical processing refers to SQL extensions that aggregate data across several dimensions in one query. The final chapter applies three of them, CUBE, ROLLUP and GROUPING SETS, to group customers, movie categories and ratings by country and gender.
What data do the exercises use?
Every exercise queries the database of MovieNow, a fictional online movie rental company. Its related tables hold customer, rental, movie, actor and cast records, so the queries grow more complex without switching to a new dataset.
Which key figures are calculated per country?
The second chapter aggregates revenue, the number of rentals and the number of active customers, then reports these figures for each country using GROUP BY, joins and sub-queries on the rental data.
How does the final chapter end?
It closes with a lesson that brings the techniques together, followed by queries on customer preference for genres and for actors that draw on several of the methods taught in earlier chapters.
User Reviews
No reviews yet. Be the first to review this course.
Write your review Cancel reply
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in, then you will return here to post.


There are no reviews yet.