Advanced Course
Monthly SQL Practice – November 2023
Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!
5.00
285 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 2 h
Coding challenges 15
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
Description
Welcome to November 2023 SQL Practice! New tasks are waiting for you. If you’ve finished our SQL Basics, Creating Basic Reports, and GROUP BY Extensions 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?
Help Emily manage her bike rental shop!
In this story, you've just been hired as an SQL specialist. You will help Emily, the owner of a local bike rental shop. She would like to gather data to grow her business and has hired you to help her out. Can you calculate how many bikes the shop owns by category? Can you get the rental revenue for each month? The answers are hidden in the database. You just need to find them using SQL functions!
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/15
-
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