Advanced Course
Monthly SQL Practice – January 2023
Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!
5.00
316 learners enrolled
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
- Apply window functions in real-life scenarios
- Combine multiple tables effectively using JOIN operations
- Tackle industry-specific SQL challenges for practical experience
Last reviews
Description
Welcome to January 2023 SQL Practice! New tasks are waiting for you. If you’ve finished our SQL Basics and Window Functions 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 Charlotte manage her hotel?
In this story, you've just been hired as an SQL specialist to help Charlotte who owns and runs a hotel. Charlotte would like to gather data to help her expand the business. Can you create a ranking of room types by price? Can you calculate the running sum of the total revenue for each booking? The answers are hidden in the database; you just need to figure out how to get them out of the database using SQL.
Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the
tab.Have fun!
Table of contents
Course progress 0%
Exercises completed 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