Advanced Course

Monthly SQL Practice – July 2024

Check out this month's advanced challenge! Test your SQL skills by performing tasks using the database of a digital music store.

5.00 ★★★★★ ★★★★★ (2 ratings)

300 learners enrolled

Lifetime access

limited to this course only

$39

Want a better deal?

Get unlimited lifetime access to all 75 present and future courses

Unlimited lifetime access

to all 75 present and future courses

$599

Free trial Yes

Certificate of completion Yes

Time to complete 2 h

Coding challenges 16

Skills you will gain

  • Create complex SQL reports for using JOINs
  • Joining many tables in a single query
  • Practice complex JOINs, including outer joins, self-joins
  • Correctly filter and aggregate data with different kinds of JOINs

Last reviews

Description

Welcome to this month’s SQL Practice! New tasks are waiting for you. If you have finished our SQL Basics and SQL JOINs courses or simply want to test your database skills, this is a good resource. Are you ready to solve the business problems in this SQL practice?

Help Chinook's management power up the music store!

In this SQL Practice, you will help Chinook, a digital music store. Its management has hired you, an SQL specialist, to gain important insights into the business. You will identify popular tracks, calculate revenue, prepare marketing campaigns, and do much more.

A music store

It is up to you to get the answers to these and other questions using your SQL skills!

Hint: In each exercise, you can see a sample of the data. Look in the left-hand menu for the Database button.

Have fun!

Table of contents

Course progress 0%

Exercises completed 0/16

  1. Challenge

    0/16

    Practice writing SQL queries with our SQL coding practice! Every month, we release a new set of interactive exercises with real-time feedback.

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Reviews (0)

Average rating

5.00/5

★★★★★ ★★★★★ (2 ratings)

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%