Advanced Course
Monthly SQL Practice – March 2024
Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!
5.00
261 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 2 h
Coding challenges 16
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
Table of contents
Course progress 0%
Exercises completed 0/16
-
Challenge
0/16Practice 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 the March 2024 SQL Practice! New tasks are waiting for you. If you have finished our course Creating Basic SQL Reports or otherwise have equivalent knowledge, this is a good way to test your database skills. You should be comfortable using CASE WHEN, GROUP BY, and aggregate functions. Are you ready to solve the problems in this month’s SQL practice?
Help Lilia manage her genetic testing clinic!
In this SQL Practice, you will help Lilia. She owns a genetic testing clinic with various tests available for its patients. Lilia has hired you, an SQL specialist, to generate detailed reports on the performance of her clinic in February 2024. Which tests are the most popular? What do patients choose most often by age?
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 right-hand menu, under the tab.
Have fun!