Advanced Course
Monthly SQL Practice – March 2021
Curious what juicy queries we've got for you this time? Be sure to check this month's challenge!
5.00
92 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 1 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 our March SQL Practice! New tasks are waiting for you. If you've finished our Creating Basic SQL Reports course and have fundamental SQL knowledge, this is a good way to practice your database skills. Are you ready to start the SQL adventure in this month's SQL Practice?
What kind of reports does Dona need to grow her language school?
Language skills are very important these days. Some emigrants might not know the language of the country to which they moved. They need to learn the new language from someone who speaks their native language.
Dona's school is a great place to learn a language because she employs teachers with skills in many different languages. For example, you can find a teacher who teaches Spanish to people who speak Polish.
Dona would like to grow her business, but she doesn't know SQL. She has asked you for help. If you've finished our Creating Basic SQL Reports course, you know everything you need to complete this SQL Practice.
You will collect information about courses, students in these courses, cities where they are located, and prices per hour from Dona's database. With this information, you will create reports summarizing the number of students enrolled in these courses, the total revenue of these courses, and the categories of these courses. This information will help Dona's company grow.
Try our SQL Practice to see how you can use SQL to help a language school. (Hint: In each exercise, you can see a sample of the data. Look in the right-hand menu, under the “Database” tab.)
Let's help Dona grow her business!
Table of contents
Course progress 0%
Exercises completed 0/15
-
Challenge
0/15Practice 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
