Advanced Course

Monthly SQL Practice – November 2024

Check out this month's advanced challenge and help Nolan Roots manage his landscaping business!

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

95 learners enrolled

Lifetime access

limited to this course only

$39

Want a better deal?

Get unlimited lifetime access to all 74 present and future courses

Save $450

Unlimited lifetime access

to all 74 present and future courses

$149 $599

75% OFF

Free trial Yes

Certificate of completion Yes

Time to complete 3 h

Coding challenges 17

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 this month’s SQL Practice! New tasks are waiting for you. This is a good resource if you have finished our SQL Basics and Creating Basic SQL Reports courses or simply want to test your database skills. Are you ready to solve the business problems in this SQL practice?

In this SQL practice course, you will help Nolan, the owner of a landscaping business. He has hired you, an SQL specialist, to gain important insights into his business. You will identify the most lucrative services, use CASE WHEN with GROUP BY to create advanced reports about his clients, calculate revenues for specific periods, and so much more!

Picture of a gardener working

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/17

  1. Challenge

    0/17

    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%