Data-Driven Decision Making in SQL
Learn how to analyze a SQL table and report insights to management.
Commencer Le Cours Gratuitement4 heures15 vidéos54 exercices47 602 apprenantsDéclaration de réalisation
Créez votre compte gratuit
ou
En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.Formation de 2 personnes ou plus ?
Essayer DataCamp for BusinessApprécié par les apprenants de milliers d'entreprises
Description du cours
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.
Formation de 2 personnes ou plus ?
Donnez à votre équipe l’accès à la plateforme DataCamp complète, y compris toutes les fonctionnalités.Dans les titres suivants
SQL pour les analystes commerciaux
Aller à la piste- 1
Introduction to business intelligence for a online movie rental database
GratuitThe 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 xpExploring the database50 xpExploring the table renting100 xpFiltering and ordering50 xpWorking with dates100 xpSelecting movies100 xpSelect from renting100 xpAggregations - summarizing data50 xpSummarizing customer information100 xpRatings of movie 25100 xpExamining 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.
Grouping movies50 xpFirst account for each country.100 xpAverage movie ratings100 xpAverage rating per customer100 xpJoining movie ratings with customer data50 xpJoin renting and customers100 xpAggregating revenue, rentals and active customers100 xpMovies and actors100 xpMoney spent per customer with sub-queries50 xpIncome from movies100 xpAge of actors from the USA100 xpIdentify favorite actors of customer groups50 xpIdentify favorite movies for a group of customers100 xpIdentify favorite actors for Spain100 xpKPIs per country100 xp - 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 query50 xpOften rented movies100 xpFrequent customers100 xpMovies with rating above average100 xpCorrelated nested queries50 xpAnalyzing customer behavior100 xpCustomers who gave low ratings100 xpMovies and ratings with correlated queries100 xpQueries with EXISTS50 xpCustomers with at least one rating100 xpActors in comedies100 xpQueries with UNION and INTERSECT50 xpYoung actors not coming from the USA100 xpDramas with high ratings100 xp - 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 operator50 xpGroups of customers100 xpCategories of movies100 xpAnalyzing average ratings100 xpROLLUP50 xpNumber of customers100 xpAnalyzing preferences of genres across countries100 xpGROUPING SETS50 xpQueries with GROUPING SETS50 xpExploring nationality and gender of actors100 xpExploring rating by country and gender100 xpBringing it all together50 xpCustomer preference for genres100 xpCustomer preference for actors100 xp
Formation de 2 personnes ou plus ?
Donnez à votre équipe l’accès à la plateforme DataCamp complète, y compris toutes les fonctionnalités.Dans les titres suivants
SQL pour les analystes commerciaux
Aller à la pisteensembles de données
MovieNowcollaborateurs
prérequis
Data Manipulation in SQL
Qu’est-ce que les autres apprenants ont à dire ?
Inscrivez-vous 15 millions d’apprenants et commencer Data-Driven Decision Making in SQL Aujourd’hui!
Créez votre compte gratuit
ou
En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.