Advanced Course

Monthly SQL Practice – March 2023

Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!

5.00 ★★★★★ ★★★★★ (1 ratings)

329 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

Save $450

Unlimited lifetime access

to all 75 present and future courses

$149 $599

75% OFF

Free trial Yes

Certificate of completion Yes

Time to complete 2 h

Coding challenges 14

Skills you will gain

  • Solve complex SQL problems using advanced coding techniques
  • Use SQL aggregate functions such as COUNT() or SUM() to summarize data in SQL.
  • Create custom classifications of objects in SQL using the CASE WHEN
  • Use classifications to group objects in the GROUP BY clause.
  • Create complex SQL reports
  • Filter data using advanced GROUP BY techniques
  • Tackle industry-specific SQL challenges for practical experience

Last reviews

Description

Welcome to March 2023 SQL Practice! New tasks are waiting for you. If you’ve finished our Creating Basic SQL Reports course or if you have equivalent knowledge, this is a good way to test your database skills. You should be comfortable using CASE WHEN, GROUP BY, and aggregate functions. Are you ready to solve the problems in this month’s SQL practice?

a coffee shop

Help Shelly manage her coffee shop!

In this story, you've just been hired as an SQL specialist. You will help Shelly who runs a coffee shop. Shelly would like to gather data to help expand the business. Can you find the most popular menu items? Can you calculate the total revenue in December 2022? The answers are hidden in the database. You just need to figure out how to get them out using SQL.

Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the Database tab.

Have fun!

Table of contents

Course progress 0%

Exercises completed 0/14

  1. Challenge

    0/14

    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

★★★★★ ★★★★★ (1 ratings)

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%