Advanced Course
Monthly SQL Practice – March 2022
Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!
4.65
14,222 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 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
Description
Welcome to March 2022 SQL Practice! New tasks are waiting for you. If you’ve finished our Creating Basic SQL Reports course or know how to use CASE WHEN, GROUP BY, aggregate functions, and common table expressions (CTEs) in SQL, 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 Megan manage a local theater?
In this story, you've just been hired as an SQL specialist. Are you ready to use your database skills to help answer the business questions for Megan, the manager of a local theater? Can you find out which plays are the most popular? Can you calculate how many plays were staged each month?
The answers are hidden in the database, and it’s up to you to get them out. Practice your SQL skills and help her manage her business!
Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the tab.
Have fun!