Sari la conținutul principal

course

Data-Driven Decision Making in SQL

IntermediarNivel de calificare

Actualizat 11.2025

Learn how to analyze a SQL table and report insights to management.

Începeți Cursul Gratuit

SQLData Literacy4 oră15 videos54 exercises4,550 XP66,676Declarație de realizare

Creează-ți contul gratuit

sau

Continuând, acceptați Termenii și condițiile de utilizare, Politica de confidențialitate și faptul că datele dvs. sunt stocate în SUA.

Îndrăgit de cursanți din mii de companii

Instruirea a 2 sau mai multe persoane?

Încercați DataCamp for Business

Descrierea cursului

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.

Cerințe preliminare

Data Manipulation in SQL

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 making

Exploring the database

Exploring the table renting

Filtering and ordering

Working with dates

Selecting movies

Select from renting

Aggregations - summarizing data

Summarizing customer information

Ratings of movie 25

Examining annual rentals

Începeți Capitolul

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.

Grouping movies

First account for each country.

Average movie ratings

Average rating per customer

Joining movie ratings with customer data

Join renting and customers

Aggregating revenue, rentals and active customers

Movies and actors

Money spent per customer with sub-queries

Income from movies

Age of actors from the USA

Identify favorite actors of customer groups

Identify favorite movies for a group of customers

Identify favorite actors for Spain

KPIs per country

Începeți Capitolul

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.

Nested query

Often rented movies

Frequent customers

Movies with rating above average

Correlated nested queries

Analyzing customer behavior

Customers who gave low ratings

Movies and ratings with correlated queries

Queries with EXISTS

Customers with at least one rating

Actors in comedies

Queries with UNION and INTERSECT

Young actors not coming from the USA

Dramas with high ratings

Începeți Capitolul

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.

OLAP: CUBE operator

Groups of customers

Categories of movies

Analyzing average ratings

Number of customers

Analyzing preferences of genres across countries

GROUPING SETS

Queries with GROUPING SETS

Exploring nationality and gender of actors

Exploring rating by country and gender

Bringing it all together

Customer preference for genres

Customer preference for actors

Începeți Capitolul

Data-Driven Decision Making in SQL

Curs
finalizat

Obțineți o Declarație de Realizări

Adaugă aceste acreditări la profilul, CV-ul sau profilul tău LinkedIn
Distribuie-l pe rețelele sociale și în evaluarea performanței taleÎnscrie-te Acum

Alătură-te 19 milioane de cursanți și începe Data-Driven Decision Making in SQL chiar azi!

Creează-ți contul gratuit

sau

Continuând, acceptați Termenii și condițiile de utilizare, Politica de confidențialitate și faptul că datele dvs. sunt stocate în SUA.

Dezvoltați-vă abilitățile de gestionare a datelor cu DataCamp pentru mobil

Fă progrese din mers cu cursurile noastre mobile și provocările zilnice de programare de 5 minute.