Articles Cookbook
19 Jun 2025
Agnieszka Kozubek-Krycuń

SQL Game Night: Play Guess the Output!

Think you know SQL? Put your skills to the test with a fun and fast-paced game where you guess the output of real SQL queries — no pressure, just play! Tired of traditional SQL tutorials? Start with the interactive SQL Basicscourse  to build a solid foundation — then put your skills to the test with SQL Game Night: Play Guess the Output! 🎯 It’s a fast, fun challenge that asks just one question:
Read more
17 Jun 2025
Jakub Romanowski

What Makes Learning SQL Difficult for Beginners?

In this article, I will explore why SQL is hard to learn for many beginners and what you can do to make it easier. From confusing JOINs to unclear error messages, we’ll go over the most common struggles and how to overcome them using practical examples and beginner-friendly tips. So, you sat down to learn SQL. It looked straightforward at first. A few SELECT statements, maybe a WHERE clause or two.
Read more
12 Jun 2025
Agnieszka Kozubek-Krycuń

How to Group by Week in PostgreSQL

Need to analyze data by week in PostgreSQL? Here's how to group your records using built-in date functions for clear, time-based insights. Grouping data by week is a common requirement in reporting. It’s often used in business reporting to track metrics like weekly revenue, user signups, or website traffic. Grouping by week helps smooth out daily fluctuations and gives you a clearer view of trends over time. It's especially helpful when comparing performance across consistent time intervals, like "
Read more
10 Jun 2025
Jakub Romanowski

How to Write SQL Queries Anyone Can Understand

Writing SQL that works is one thing. Writing SQL that someone else can read and say, "Oh, I get it!" is a whole different level. And honestly? It's one of the most useful things you can learn if you work with data. Whether you're building reports, analyzing customer behavior, or answering a quick question from your boss, you’ll probably use SQL. And if that SQL is messy or confusing, you'll slow everyone down – including yourself.
Read more
5 Jun 2025
Agnieszka Kozubek-Krycuń

SQL Queries You'll Actually Use in Real Life

Learn the essential SQL queries that data analysts, marketers, and product teams rely on every day – with simple, relatable examples. When you're just starting with SQL, it's easy to get overwhelmed by syntax and theory. But here’s the truth: most professionals – whether they’re data analysts, marketers, or product managers – use a small set of SQL queries over and over to get real work done. You don’t need to learn everything at once.
Read more
3 Jun 2025
Jakub Romanowski

5 Things you can Build With SQL (Even if You’ve Never Coded Before)

If you're completely new to coding and wondering what SQL is even good for, you're in the right place. This article will walk you through five easy and useful things you can build with SQL, even if you've never written a line of code before. Whether you're curious about data, switching careers, or just want to build something practical, this beginner guide to SQL will help you take your first step.
Read more
2 Jun 2025
Jakub Romanowski

Free Course of the Month: 2024 Monthly SQL Practice Sets – Advanced

Ready to take your SQL skills to the next level? This June, you can access our most hands-on advanced course – 2024 Advanced SQL Practice Challenges – completely free. Whether you're preparing for a job interview, handling complex data at work, or just want to challenge yourself with real SQL tasks, this course offers exactly what you need. It's packed with high-level exercises based on realistic business problems that will sharpen your thinking and test your skills.
Read more
1 Jun 2025
LearnSQL.com Team

New Monthly SQL Practice for June 2025!

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 2025 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
29 May 2025
Jakub Romanowski

Supercharge Your Notion Workflow With SQL

If you're using Notion to stay organized but feel like it's missing something when it comes to data analysis, you're not alone. In this article, I’ll show you how to supercharge your Notion workflow with SQL so you can go beyond tracking tasks – and start making smarter, data-driven decisions. I’ve always liked using Notion to keep things organized – whether it’s tracking projects at work, planning content, or just storing personal notes.
Read more
27 May 2025
Agnieszka Kozubek-Krycuń

How to Build a Data Dashboard (Even if You Just Started Learning SQL)

Dive into building your own data dashboard with this beginner-friendly guide—even if you're just starting with SQL. Using BigQuery, public datasets, and Looker Studio, you'll learn how to easily create an impressive dashboard. If you're a data analyst—or aiming to become one—learning SQL is essential. SQL, or Structured Query Language, is the language used to pull and analyze data from databases, helping you turn raw numbers into real insights. But if you’re just starting out, coming up with project ideas can be the hardest part.
Read more