Articles Cookbook
1 Sep 2025
LearnSQL.com Team

New Monthly SQL Practice for September 2025!

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 Sep 2025
LearnSQL.com Team

Course of the Month: SQL Practice Set in PostgreSQL

Do you know the basics of PostgreSQL but still need some practice? Look no further! Here is a great interactive course, SQL Practice Set in PostgreSQL. Throughout the month of September, you have access to it for FREE! We at LearnSQL.com believe that to learn a new skill, you need basic theoretical knowledge and, above all, a lot of practice. It's the same with writing PostgreSQL queries – you need a lot of PostgreSQL practice.
Read more
27 Aug 2025
Agnieszka Kozubek-Krycuń

How to Write Clean and Shareable SQL Reports

Want to write SQL reports that everyone can understand? Discover the key practices for creating clean, shareable reports that boost collaboration and drive smarter decisions. Writing clean, readable SQL reports is essential, especially in team environments where SQL is the shared language for analysis and decision-making. Clear SQL reports make it easier for everyone—from analysts to non-technical stakeholders—to follow logic, trust results, and make informed decisions. On the other hand, messy reports lead to confusion, errors, and wasted time, slowing down progress and affecting decision-making.
Read more
20 Aug 2025
LearnSQL.com Team

Mini-Tutorial: Analyze Real Weather Data in SQL and Find the Best Time to Travel

and Find the Best Time to Travel Looking for the perfect time to take a vacation? With just a few SQL queries and real weather data from Szeged, Hungary, you can figure out which months are hot, rainy, or great for a walk in the sun. This mini-tutorial is a fun, practical way to sharpen your SQL skills—and maybe plan your next trip while you're at it. Looking for sunshine and low rain?
Read more
13 Aug 2025
LearnSQL.com Team

Your August SQL Plan: 15 Minutes a Day for 2 Weeks to Get Started

Want to learn SQL but feel like you don’t have the time? This August, commit just 15 minutes a day and build real skills without the overwhelm. With this simple 2-week plan and the right tools, you’ll go from zero to writing queries before the month ends. August is a great time to reset, recharge — and maybe even learn something new. But what if you could pick up an in-demand skill without overloading your calendar?
Read more
6 Aug 2025
Agnieszka Kozubek-Krycuń

How SQL Data Analysis Can Help You Understand Seasonality in Your Business

Your business data holds hidden seasonal patterns — sales peaks, slowdowns, and shifts that repeat every year. With just a few SQL queries, you can uncover these trends and turn them into smarter decisions. Here's how. Every business experiences ups and downs — more sales in December, fewer customers in August, a spike in support tickets after a product update. These patterns are known as seasonality, and they can have a major impact on planning, staffing, marketing, and inventory.
Read more
1 Aug 2025
Jakub Romanowski

Course of the Month: Window Functions Practice Set

Do you want to enhance your SQL skills and learn how to prepare complex SQL reports? Maybe you've learned SQL window functions but need a refresher. This month, our unique SQL course Window Functions Practice Set is completely free! You're probably wondering ‘What's the catch?’. Why do we give something for free to our users? Well... we want to support people like you who are constantly striving to be better.
Read more
1 Aug 2025
LearnSQL.com Team

New Monthly SQL Practice for August 2025!

In our August 2025 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
30 Jul 2025
Agnieszka Kozubek-Krycuń

Learn SQL with Real GA4 Data: A Practical Guide for Beginners

Curious how real e-commerce data looks in SQL? In this article, you'll analyze Google Analytics 4 (GA4) events from the Google Merchandise Store using BigQuery — and learn practical SQL skills along the way. Want to improve your SQL skills with real e-commerce data? In this article, you’ll explore Google Analytics 4 (GA4) data using SQL in BigQuery — Google’s cloud-based data warehouse. GA4 is Google’s web analytics platform used by millions of websites and apps to track how users interact with their content.
Read more
21 Jul 2025
Agnieszka Kozubek-Krycuń

5 Fun SQL Projects You Can Do in a Weekend (For Free!)

Want to turn your weekend into a fun learning sprint and make your resume shine? With just a few hours (and zero cost), you can build impressive SQL projects that show off your skills to future employers. Here are five ideas to get you started — no database design or fancy tools required! Fun SQL projects? Yes, really! SQL isn’t just about dry reports or endless tables — it can actually be a fun, creative way to explore your favorite topics, analyze real-world data, and even learn more about yourself.
Read more