Basic Course
Monthly SQL Practice – July 2021
Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!
5.00
69 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 2 h
Coding challenges 17
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 our next SQL Practice! New tasks are waiting for you. If you've finished our SQL Basics and SQL JOINs courses or know how to use SQL JOINs, this is a good way to test your database skills. Are you ready to resolve the business problems in this month's SQL practice?
How Should John and Tom Manage Their Sportswear Store?
In this SQL Practice, meet John and Tom – friends who decided to launch their own sports apparel store. They've employed you, an SQL specialist, to answer some business questions. What are the most popular items? What colors should they stock? How should they organize clothing types?
The answers are hidden in their database and it's up to you to get them out. Practice your SQL skills and help these fictional friends figure out their business!
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/17
-
Challenge
0/17Practice SQL with our coding challenges! Each month, there's a new set of exercises to solve with real-time feedback.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
