Back to articles list Articles Cookbook
3 minutes read

New Monthly SQL Practice for January 2024!

In our January 2024 SQL Practice, you’ll meet Julie. She is the owner of an online store where she sells handmade crochet items. She has hired you to help her with data analysis to grow her business. What are the best-selling products? Which products bring the most revenue? Can you create reports to help her with sales trends? You will find all the answers in the data. You just need to figure out how to get them out of the database using SQL.

This SQL Practice is at an advanced level and is aimed at those who have finished our Window Functions course or otherwise have equivalent knowledge on the topic. If you are not yet comfortable working with window functions, check out our interactive window functions course and then come back here for more practice.

Our interactive SQL course is a great way to test your skills and put what you've learned so far into practice. The exercises are fun, so you do not get bored while learning. And thanks to the interactive online console, you write real SQL queries and see their results. You do not need to install or set anything up. A web browser and your willingness to practice SQL are enough.

Maybe this is the first time you’ve come across our Monthly SQL Practices. LearnSQL.com offers one SQL Practice each month: basic levels on even-numbered months and advanced levels on odd-numbered months. Each SQL Practice takes about an hour (or less!) and contains 5–10 exercises to help you hone your skills.

Each Monthly SQL Practice features a different business or hobby. We’ve had practices featuring family trees, a language school, a book exchange, a job agency, rental cars, stars and astronomy, auto repair, baking, pizza, movies, U.S. cities, and more.

Our exercises are based on real business scenarios. There are no abstract theories here, just everyday business problems. You can copy most of the SQL queries you write in these exercises and use them in your own projects. This is what they call a hands-on SQL course!

Who is this course for? Everyone, especially beginners who need to practice SQL. We believe this is the only way you truly learn something. Knowledge is helpful only when you use it in practice.

If you know SQL window functions, check your knowledge with the January SQL Practice!

Hungry for more SQL exercises? Check out our SQL Practice track featuring over 800 interactive SQL exercises. You’ll have brushed up your SQL coding skills before you know it!

Have fun and start practicing SQL now with our January 2024 SQL Practice!