Pular para o conteúdo principal
InícioSQLData-Driven Decision Making in SQL

Data-Driven Decision Making in SQL

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

Comece O Curso Gratuitamente
4 horas15 vídeos54 exercícios
45.713 aprendizesTrophyDeclaração de Realização

Crie sua conta gratuita

GoogleLinkedInFacebook

ou

Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.
GroupTreinar 2 ou mais pessoas?Experimente o DataCamp For Business

Amado por alunos de milhares de empresas

Descrição do Curso

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.
Para Empresas

GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados
Experimente O DataCamp for BusinessPara uma solução sob medida , agende uma demonstração.

Nas seguintes faixas

Certificação disponível

Analista de dados associado em SQL

Ir para a trilha

SQL para analistas de negócios

Ir para a trilha
  1. 1

    Introduction to business intelligence for a online movie rental database

    Gratuito

    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.

    Reproduzir Capítulo Agora
    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
  2. 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.

    Reproduzir Capítulo Agora
    Grouping movies
    50 xp
    First account for each country.
    100 xp
    Average movie ratings
    100 xp
    Average rating per customer
    100 xp
    Joining movie ratings with customer data
    50 xp
    Join renting and customers
    100 xp
    Aggregating revenue, rentals and active customers
    100 xp
    Movies and actors
    100 xp
    Money spent per customer with sub-queries
    50 xp
    Income from movies
    100 xp
    Age of actors from the USA
    100 xp
    Identify favorite actors of customer groups
    50 xp
    Identify favorite movies for a group of customers
    100 xp
    Identify favorite actors for Spain
    100 xp
    KPIs per country
    100 xp
  3. 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.

    Reproduzir Capítulo Agora
    Nested query
    50 xp
    Often rented movies
    100 xp
    Frequent customers
    100 xp
    Movies with rating above average
    100 xp
    Correlated nested queries
    50 xp
    Analyzing customer behavior
    100 xp
    Customers who gave low ratings
    100 xp
    Movies and ratings with correlated queries
    100 xp
    Queries with EXISTS
    50 xp
    Customers with at least one rating
    100 xp
    Actors in comedies
    100 xp
    Queries with UNION and INTERSECT
    50 xp
    Young actors not coming from the USA
    100 xp
    Dramas with high ratings
    100 xp
  4. 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.

    Reproduzir Capítulo Agora
    OLAP: CUBE operator
    50 xp
    Groups of customers
    100 xp
    Categories of movies
    100 xp
    Analyzing average ratings
    100 xp
    ROLLUP
    50 xp
    Number of customers
    100 xp
    Analyzing preferences of genres across countries
    100 xp
    GROUPING SETS
    50 xp
    Queries with GROUPING SETS
    50 xp
    Exploring nationality and gender of actors
    100 xp
    Exploring rating by country and gender
    100 xp
    Bringing it all together
    50 xp
    Customer preference for genres
    100 xp
    Customer preference for actors
    100 xp
Para Empresas

GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

Nas seguintes faixas

Certificação disponível

Analista de dados associado em SQL

Ir para a trilha

SQL para analistas de negócios

Ir para a trilha

conjuntos de dados

MovieNow

colaboradores

Collaborator's avatar
Hadrien Lacroix
Collaborator's avatar
Mona Khalil

pré-requisitos

Data Manipulation in SQL
Irene Ortner HeadshotIrene Ortner

Consultant @ Applied Statistics

Ver Mais

O que os outros alunos têm a dizer?

    Junte-se a mais de 14 milhões de alunos e comece Data-Driven Decision Making in SQL hoje mesmo!

    Crie sua conta gratuita

    GoogleLinkedInFacebook

    ou

    Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.