30 Apr 2023 LearnSQL.com Team New Monthly SQL Practice for May 2023! Ready for our new SQL challenge? This time, we have prepared some slightly more difficult SQL tasks. Here’s the May 2023 SQL Practice course! You’ll be helping Sophie, who is running an online document editing app. She would like to gather some data that will help her to expand the business. She hired you as an SQL specialist to help her out. Can you find the average number of documents created by each user? Read more 31 Mar 2023 LearnSQL.com Team New Monthly SQL Practice for April 2023! In our April 2023 SQL Practice, you’ll meet Emma, a host of game development tournaments called game jams. She needs your help in creating a reliable database structure and queries for the platform. Can you use your SQL skills to help her? It shouldn’t be too hard if you have finished our SQL Basics course or otherwise understand core SQL concepts. Our interactive SQL course is a great way to test your skills and see if you can put what you've learned so far into practice. Read more 28 Feb 2023 LearnSQL.com Team New Monthly SQL Practice for March 2023! Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the March SQL Practice course! This time, you will help Shelly who runs a coffee shop. Shelly would like to gather some data to expand the business and has hired you as an SQL specialist. Can you help her find the most popular menu items? Can you calculate the total revenue in December 2022? Read more 31 Jan 2023 LearnSQL.com Team New Monthly SQL Practice for February 2023! Are you a SQL beginner that needs some interactive exercises to practice writing queries? Take the challenge and choose our February 2023 SQL Practice course. This is the next step towards becoming a pro. In our February SQL Practice, you’ll meet Hazel, the manager of a local gym. She needs your help to gather statistics on the gym members and the memberships they have purchased. Can you use your SQL skills to help her find the data? Read more 1 Jan 2023 LearnSQL.com Team New Monthly SQL Practice for January 2023! Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here's the January SQL Practice course! This SQL Practice is at an advanced level and is aimed at those who have finished our SQL Basics and Window Functions course or otherwise have the equivalent knowledge. If you do not feel comfortable working with SQL window functions yet, make sure to check out these courses first and then come back here for more practice. Read more 1 Dec 2022 LearnSQL.com Team New Monthly SQL Practice for December 2022! In our December 2022 SQL Practice, you will meet Lucas. He is a young entrepreneur and video game enthusiast. Lucas needs your help in creating queries and analyzing data for his gaming social hub, a place for people to buy and discuss games. Can you use your SQL skills to help him? It shouldn’t be too hard if you have finished our SQL Basics course and/or understand core SQL concepts. Read more 31 Oct 2022 LearnSQL.com Team New Monthly SQL Practice for November 2022! You’re an SQL specialist helping Daisy, who is running a jewelry store. Daisy would like to gather some data that will help her expand the business. Can you find the number of purchases made by each customer? How much do the customers usually spend on a single purchase? The answers are hidden in the database – you just need to figure out how to get them out! This SQL Practice is at an advanced level and focuses on advanced GROUP BY queries. Read more 17 Oct 2022 LearnSQL.com Team Halloween Promo 2022 Halloween is just around the corner and with it come monsters and ghosts. Join the fun and get a special, monstrous promo code. Are you scared, do you feel chills? This Halloween, we have prepared some fun for you. Have you ever wondered what kind of monster you would be? Answer a few questions and find out! Here's our SQL Monster Quiz - perhaps this will also give you a hint for a Halloween disguise! Read more 30 Sep 2022 LearnSQL.com Team New Monthly SQL Practice for October 2022! In our October 2022 SQL Practice, you’ll meet Elisabeth, the manager of a music club. She needs you to help her gather the right statistics about the events organized in the club. Can you use your SQL skills to help her find the data? It shouldn’t be too hard if you have finished our SQL Basics course or understand core SQL concepts such as SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and aggregate functions. Read more 1 Sep 2022 LearnSQL.com Team New Monthly SQL Practice for September 2022! This time, you will help Kate who runs an electronics store. Kate would like to gather some data to help her expand her business. She has hired you as an SQL specialist to help her out. Can you find out the average number of purchases made by each customer? Can you calculate the prices for customers with loyalty cards? The answers are in the database. You just need to figure out how to get them out using SQL functions. Read more 1 Aug 2022 LearnSQL.com Team New Monthly SQL Practice for August 2022! In our August 2022 SQL Practice, you’ll meet Anna, who manages a small private airline. She needs you to help her gather and analyze statistics on the company’s performance. Can you use your SQL skills to help her find the needed data? It shouldn’t be too hard if you have finished our SQL Basics courses or understand core SQL concepts. Our interactive SQL course is a great way to test your skills and see if you can put what you've learned so far into practice. Read more 1 Jul 2022 LearnSQL.com Team New Monthly SQL Practice for July 2022! Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s July’s SQL Practice course! This time, you will help Ruby. She is the creator of a language tandem app, that is, a chat application in which learners can find native speakers for practicing languages. Ruby would like to gather data to help expand her business, and she has hired you as an SQL specialist to help her out. Read more 1 Jun 2022 LearnSQL.com Team New Monthly SQL Practice for June 2022! Are you a SQL beginner that needs some interactive exercises to practice writing queries? Take up the challenge in our June SQL Practice course! In our June 2022 SQL Practice, you’ll meet Damiano – a young entrepreneur who wants to kick-start his car rental business. He needs you to help him gather the right data and statistics on his company’s performance. Can you use your SQL skills to help him find the data? Read more 2 May 2022 LearnSQL.com Team New Monthly SQL Practice for May 2022! Ready for our new SQL challenge? This time, we have prepared some slightly more difficult SQL tasks. Here’s the May’s SQL Practice course! This time, you will be helping Tiffany, the owner of an online course website. She’d like to analyze her business data – it’s the perfect opportunity to use your SQL skills. Can you find the average number of students enrolled in a course? Calculate the average number of total hours spent by all students on a course? Read more 1 Apr 2022 LearnSQL.com Team New Monthly SQL Practice for April 2022! Are you a SQL beginner that needs some interactive exercises to practice writing queries? Take up the challenge and choose our April SQL Practice course! In our April 2022 SQL Practice, you’ll meet Olivia, the owner of a hairdressing salon. She needs you to help her gather statistics on the services offered by her salon, the salon customers, their appointments, etc. Can you use your SQL skills to help her find the data? Read more 1 Mar 2022 LearnSQL.com Team New Monthly SQL Practice for March 2022! If you are a more advanced SQL user who is comfortable using CASE WHEN, GROUP BY, aggregate functions, and common table expressions (CTEs), you can check your knowledge with the March SQL Practice. On LearnSQL.com, you‘ll find a new challenge to solve every month. Maybe this is the first time you’ve come across our Monthly SQL Practices. LearnSQL.com offers one SQL Practice each month: at the basic level on even-numbered months and at the advanced level on odd-numbered months. Read more 1 Feb 2022 LearnSQL.com Team New Monthly SQL Practice for February 2022! Are you a SQL beginner that needs some interactive exercises to practice writing queries? Take the challenge and choose our February’s SQL Practice course. This is the next step towards becoming a pro. In our February 2022 SQL Practice, you’ll meet Keith – a rally (racing) fan who’s making a website dedicated to his favorite sport. He needs you to help him gather the right statistics on rally events, crews, results, etc. Read more 1 Jan 2022 LearnSQL.com Team New Monthly SQL Practice for January 2022! Ready for our new SQL challenge? This time, we have prepared some slightly more difficult SQL tasks. Here’s January’s SQL Practice course! This time you will be helping Monica, the owner of an online store. She’d like to analyze her business data and earn more. It’s the perfect opportunity to use your SQL window functions skills. Can you find out how many customers she has in each country? Can you create reports to help her see sales trends? Read more 1 Dec 2021 LearnSQL.com Team New Monthly SQL Practice for December 2021! If you are a more advanced SQL user who is comfortable writing complex JOINs, you can check your knowledge with December's SQL Practice. Every month on LearnSQL.com, you'll find a new challenge to solve. 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 to complete and contains 5–10 exercises to help you hone your skills. Read more 1 Nov 2021 LearnSQL.com Team New Monthly SQL Practice for November 2021! If you are a more advanced SQL user who is comfortable writing complex GROUP BY statements, you can check your knowledge with November’s SQL Practice. Every month on LearnSQL.com, you‘ll find a new challenge to solve. Maybe this is the first time you’ve come across our Monthly SQL Practices. LearnSQL.com offers one free 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! Read more 25 Oct 2021 LearnSQL.com Team Monster Hunt – Halloween Promo We need your help! Our office has been haunted by a bunch of terrifying monsters. Only you can beat them. The worst of the monsters controls them all. Are you scared, do you feel chills? This Halloween, we wanted to give you an unusual gift - a promo code that would give you an additional $20 discount on our All Forever Plan. This means that, along with other promotions, you could now pay only $169 to access all of our SQL courses! Read more 1 Oct 2021 LearnSQL.com Team New Monthly SQL Practice for October 2021! Do you have fundamental SQL knowledge? Do you know how to write basic SQL queries and join more than one table? If the answer is yes, you have a chance to test your knowledge by solving business problems with a new SQL Practice, available every month on LearnSQL.com. The October SQL Practice is at the basic level. You will check your SQL skills with data about a furniture store. Currently, the store operates only in Cleveland, Ohio in the U. Read more 1 Sep 2021 LearnSQL.com Team New Monthly SQL Practice for September 2021! Do you know more advanced SQL than basic skills? Do you know how to write basic SQL queries, know functions that use different data types, work with text using special SQL functions, or convert data types without any problem? If your answer to these questions is yes, you have a chance to test your knowledge in solving business problems in the new SQL Practices, available every month on LearnSQL.com. Read more 1 Aug 2021 LearnSQL.com Team New Monthly SQL Practice for August 2021! Do you have basic skills in SQL? Do you know how to write SQL queries? If the answer is yes, you can test your knowledge by solving business problems with our SQL Practice, available every month on LearnSQL.com. The August SQL Practice is at the basic level. You will check your SQL skills with data about a travel agency. The company organizes trips through different cities in the state of Illinois in the US, connecting its clients to many attractions. Read more 1 Jul 2021 Jakub Romanowski Free Course of the Month – Recursive Queries in MS SQL Server Do you want to become a SQL expert? To do this, you need to learn SQL CTEs or Common Table Expressions. They can make your queries clearer and more readable. And during July 2021, you can learn CTEs for free using our interactive Recursive Queries in MS SQL Server course! How can you get this free SQL course? Create a free LearnSQL.com account or log in if you already have one. Read more 1 Jul 2021 LearnSQL.com Team New Monthly SQL Practice for July 2021! If you are a more advanced SQL user who is comfortable writing complex JOINs, you can check your knowledge with July’s SQL Practice. Every month on LearnSQL.com, you‘ll find a new challenge to solve. Maybe this is the first time you’ve come across our Monthly SQL Practices. LearnSQL.com offers one free 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! Read more 1 Jun 2021 LearnSQL.com Team New Monthly SQL Practice for June 2021! If you have fundamental SQL skills and know how to write queries, check out our new SQL Practice, available every month on LearnSQL.com. The June SQL Practice is for people who’ve mastered the basics of SQL. You’ll practice your SQL knowledge helping Jennifer with her dog sitting business – a service that brings together dog owners with people who can care for the pets when the owners are away. Read more 1 May 2021 LearnSQL.com Team New Monthly SQL Practice for May 2021! Are you ready to use your SQL skills to write fundamental SQL queries that solve real-world problems? Do it with our new SQL Practice course on LearnSQL.com. The May SQL Practice is at an advanced level. Our main character this month, Luke, needs your help. You will test your SQL skills by using family tree data created by his brother. If this is the first time you've come across our monthly SQL Practices, here is some more information about them. Read more 1 Apr 2021 LearnSQL.com Team New Monthly SQL Practice for April 2021! Are you ready to use SQL skills to write queries that resolve business problems? Give it a try in the new Monthly SQL Practice on LearnSQL.com. The April SQL Practice is for people with a basic level of SQL proficiency. You will test your SQL skills based on data about an apartment rental agency in Chicago, USA. If this is the first time you’ve come across our Monthly SQL Practices, you should know that LearnSQL. Read more 1 Mar 2021 LearnSQL.com Team New Monthly SQL Practice for March 2021! Are you ready to use your SQL skills to create reports and help resolve business problems? You can do this with our new SQL Practice on LearnSQL.com! The March SQL Practice is at an advanced level. You will test your SQL skills by creating reports with data about language courses in the U.S. If this is the first time you’ve come across our Monthly SQL Practices, LearnSQL.com offers one free SQL Practice each month (at the basic level in the even months and at the advanced level in the odd months). Read more 1 Feb 2021 LearnSQL.com Team New Monthly Challenge for February 2021! Are you ready to solve business problems using SQL in 2021 with a new Challenge on LearnSQL.com? The February Challenge is at a basic level. You will test your SQL skills with data about a rental car company in the U.S. If it is the first time you’ve come across our Monthly Challenges, LearnSQL.com offers one free SQL Challenge each month: at the basic level in the even months and at the advanced level in the odd months. Read more 14 Jan 2021 Agnieszka Kozubek-Krycuń Monthly SQL Challenges in 2021 Did you know that LearnSQL.com provides a monthly SQL Challenge? Every month, we publish a new set of SQL practice exercises. Find out what to expect from our SQL challenges in 2021. Here at LearnSQL.com, we believe that the best way to learn SQL is through practice. After all, writing SQL is a practical skill. That’s why all our SQL courses (and there are over 30 of them!) are interactive: You learn SQL by writing SQL code. Read more 1 Jan 2021 LearnSQL.com Team New Monthly Challenge for January 2021! This month’s LearnSQL.com Monthly Challenge is now available! In January, you can test your SQL skills in window functions by solving problems for Jeremy, the manager of the clothing retailer, Edward. Is this the first time you’ve come across our Monthly Challenge? LearnSQL.com delivers one SQL Challenge each month to our users. Starting in January 2021, we have monthly challenges separately for beginners and for advanced users. Each challenge contains 5 to 10 SQL exercises, prepared for those who want to practice their skills. Read more 1 Dec 2020 LearnSQL.com Team New Monthly Challenge for December 2020! This month’s LearnSQL.com Monthly Challenge is now available! In December, you can test SQL skills by resolving problems for a group of co-workers who want to start a book exchange. Is this the first time you’ve met our Monthly Challenge? LearnSQL.com delivers one SQL Challenge each month to our users. Each challenge contains from 5 to 10 SQL exercises that were prepared for those who want to practice their skills. Read more 1 Nov 2020 LearnSQL.com Team New Monthly SQL Challenge for November 2020! Are you ready for a new Monthly Challenge on LearnSQL.com? In November, we invite you to test your SQL skills as you learn about popular regional dishes in the USA. Is this the first time you’ve come across our Monthly Challenges? LearnSQL.com offers one free SQL Challenge each month. Each one contains from 5 to 10 SQL exercises that will help you practice your SQL skills. It takes about an hour (or less! Read more 1 Oct 2020 LearnSQL.com Team New Monthly SQL Challenge for October 2020! The new Monthly Challenge on LearnSQL.com is ready! In October, we invite you to try your SQL skills by learning about job positions and recruitment agencies. Is this the first time you’ve come across our Monthly Challenge? LearnSQL.com delivers a new SQL challenge every month. Each challenge contains 5 to 10 SQL exercises designed for people who want to practice their SQL skills. It takes less than an hour to solve these tasks. Read more 1 Sep 2020 LearnSQL.com Team New Monthly Challenge for September 2020! The new LearnSQL.com Monthly Challenge is ready! In September, we invite you to test your SQL skills to discover things about American movies, directors, and actors. Is this the first time you’ve come across our Monthly Challenge? LearnSQL.com delivers one Challenge per month, each a set of 5 to 10 SQL exercises prepared for those who want to practice their SQL skills. You won’t need more than an hour to solve these tasks. Read more 1 Aug 2020 LearnSQL.com Team New Monthly Challenge for August 2020! A new month always brings new challenges. The August Monthly Challenge on LearnSQL.com is ready! This month, we invite you to support Mike in his first year of boarding school while testing your SQL knowledge. The SQL Challenge is a set of several exercises to help you practice your SQL skills. Each challenge is centered around a specific theme—food, stars, planets, travels, work, school, etc. The exercises within a challenge are interrelated, but you can do them in whatever order you want. Read more 1 Jul 2020 LearnSQL.com Team New SQL Monthly Challenge for July 2020! The new LearnSQL.com Monthly Challenge is ready! In July, we invite you to sharpen your SQL skills with some questions about US states. If you’ve never come across our Monthly Challenge, it’s a set of 5 to 10 SQL exercises prepared for people who want to practice their SQL skills. Each challenge is designed around a specific theme. In this challenge, you’ll use SQL to learn facts about some US states. Read more 10 Jun 2020 Dorota Wdzięczna Monthly SQL Challenges SQL learners sometimes need challenges. Do you want to test your problem-solving skills or your knowledge of SQL? Then take our monthly SQL Challenges! We prepare them on LearnSQL.com every month. Each Challenge relates to a different interesting topic and will help you keep your SQL game sharp. In this article, you'll discover what our LearnSQL.com Monthly Challenges are and where to find them. We’ll also look at the Challenges collected in our Monthly SQL Challenge Mini Track. Read more 1 Jun 2020 LearnSQL.com Team New SQL Monthly Challenge for June 2020! The new LearnSQL.com Monthly Challenge is ready! In June, we invite you to use your SQL skills to analyze insurance agency activities. Is this the first time you’ve ever come across our Monthly Challenge? Then you should know that it’s a set of 5 to 10 SQL exercises prepared for people who want to practice what they’ve learned. Each challenge is designed around a specific theme. In this seventh challenge, the exercises are built around a fictional insurance agency, but in the other challenges we’ve explored the subjects of pizza, the stars, a car workshop, and bakery management. Read more 1 May 2020 LearnSQL.com Team New SQL Monthly Challenge for May 2020! The new LearnSQL.com Monthly Challenge is ready! In May, we invite you to use your SQL knowledge to help a bakery manager buy a new oven. Is this the first time you’ve ever come across our Monthly Challenge? Then you should know that it’s a set of 5 to 10 SQL exercises prepared for people who want to practice their SQL skills. Each challenge is designed around a specific theme. Read more 22 Apr 2020 LearnSQL.com Team New SQL Monthly Challenge for April 2020! The new Monthly Challenge on LearnSQL.com is ready! In April, we invite you to test your SQL knowledge with data from another area of business: automobile repair. What is an SQL Challenge? It is a set of 5 to 10 SQL exercises, prepared for people who want to sharpen their SQL skills. Each challenge is centered around a specific theme. Do you like pizza? One of the challenges focuses on this miracle of Italian cuisine. Read more