Advanced Course
Monthly SQL Practice – July 2023
Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!
5.00
229 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 2 h
Coding challenges 15
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
Table of contents
Course progress 0%
Exercises completed 0/15
-
Challenge
0/15Practice 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
Description
Welcome to July 2023 SQL Practice! New tasks are waiting for you. If you’ve finished our SQL Basics and SQL JOINs courses or otherwise have equivalent knowledge, this is a good way to test your database skills. Are you ready to solve the problems in this month’s SQL practice?
Can you help Isabella manage her online platform?
In this story, you've just been hired as an SQL specialist. You will help Isabella, the founder of an online home swap platform. On this platform, homeowners can find a place to stay for vacation by swapping homes with other homeowners.
Isabella would like to gather data to help her expand the business. She has hired you as an SQL specialist to help her out. Which locations are the most desired by the platform users? How many homeowners have listings in more than one country? The answers are hidden in the database – you just need to find them using SQL JOINs!
Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the tab.
Have fun!