Skip to main content
HomeSQLData-Driven Decision Making in SQL

Data-Driven Decision Making in SQL

4.4+
43 reviews
Intermediate

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

Start Course for Free
4 Hours15 Videos54 Exercises
38,088 LearnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies


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.
  1. 1

    Introduction to business intelligence for a online movie rental database

    Free

    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.

    Play Chapter Now
    Introduction to data driven decision making
    50 xp
    Exploring the database
    50 xp
    Exploring the table renting
    100 xp
    Filtering and ordering
    50 xp
    Working with dates
    100 xp
    Selecting movies
    100 xp
    Select from renting
    100 xp
    Aggregations - summarizing data
    50 xp
    Summarizing customer information
    100 xp
    Ratings of movie 25
    100 xp
    Examining annual rentals
    100 xp

In the following tracks

Associate Data Analyst in SQLSQL for Business Analysts

Datasets

MovieNow

Collaborators

Collaborator's avatar
Hadrien Lacroix
Collaborator's avatar
Mona Khalil
Irene Ortner HeadshotIrene Ortner

Consultant @ Applied Statistics

Irene did her PhD in Statistics at Vienna University of Technology. During a postdoc at KU Leuven she focused in her research on fraud and anomaly detection with statistical and machine learning tools. Now she works as consultant and data scientist for Applied Statistics bridging the gap between science and business applications.
See More
Tim Verdonck HeadshotTim Verdonck

Professor at KU Leuven

Tim Verdonck is a professor in Statistics and Data Science at the Department of Mathematics of KU Leuven (Belgium). He is also a visiting professor at the School of Economics, Management and Statistics at the University of Bologna (Italy), where he gives a course in the Master in Quantitative Finance. He is chairholder of the BNP Paribas Fortis Chair in Fraud Analytics, which investigates the use of predictive analytics in the context of payment fraud. Tim Verdonck is also chairholder of the Allianz Chair Prescriptive Business Analytics in Insurance. His research interests are in the development and application of robust statistical methods for financial, actuarial and economic data sets.
See More
Bart Baesens HeadshotBart Baesens

Professor in Analytics and Data Science at KU Leuven

Bart Baesens is professor in Analytics and Data Science at the Faculty of Economics and Business of KU Leuven, and a lecturer at the University of Southampton (UK). He has done extensive research on big data & analytics, credit risk analytics and fraud analytics. He regularly tutors, advises and provides consulting support to international firms with respect to their big data, analytics and fraud & credit risk management strategy.
See More

Don’t just take our word for it

*4.4
from 43 reviews
67%
19%
12%
0%
2%
Sort by
  • Tamish U.
    9 months

    It was a really good where along with introducing new keywords, a complete revision of sorts was done of the previous courses.

  • Karamagi D.
    10 months

    It was okay

  • Sarah S.
    10 months

    well explained, good exercises

  • DERMAIN B.
    10 months

    A very insightful and well rounded course. It showcase how to use critical thinking to analyze database using SQL

  • 遠忻 周.
    10 months

    Datacamp's courses and exercises are easy to understand. Really recommend for beginner like me.

"It was a really good where along with introducing new keywords, a complete revision of sorts was done of the previous courses."

Tamish U.

"It was okay"

Karamagi D.

"well explained, good exercises"

Sarah S.

Join over 13 million learners and start Data-Driven Decision Making in SQL today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.