Data-Driven Decision Making in SQL

Start Free Preview

Buying via our links supports this free directory · Affiliate disclosure.
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
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Intermediate

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Preview (Paid Upgrade)

Technical
Content Medium

Text & Interactive

Video Access

Streaming Only

Specification
Access

Subscription

SKU: data-driven-decision-making-sql Category: Tags: , Brand:

Use SQL to answer business questions on a movie rental database with joins, nested queries and the OLAP operators CUBE, ROLLUP and GROUPING SETS.

At a glance
Duration4 hrs
LevelIntermediate
CertificateCertificate of Completion
LanguageEnglish
AccessSubscription
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

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.


Our take

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

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    Data-Driven Decision Making in SQL
    Data-Driven Decision Making in SQL
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0