Articles Cookbook
4 Mar 2026
LearnSQL.com Team

The Best SQL Projects to Start Your Portfolio this Spring (With Dataset Ideas)

Want to turn your SQL skills into something you can actually show recruiters this spring? In this article, you’ll find practical SQL portfolio project ideas with real dataset suggestions, so you can move beyond exercises and build work that proves your skills – especially after finishing structured courses like those on LearnSQL.com. Spring is a natural reset point. In ancient Rome, spring marked the beginning of the year. The earliest Roman calendar started in March.
Read more
1 Mar 2026
Jakub Romanowski

Course of the Month: Window Functions in PostgreSQL

Are you looking for the best way to master SQL window functions? Throughout March 2026, you can access the interactive course Window Functions in PostgreSQL for free. Boost your skills at no cost. Hurry, time is running out! Need a free PostgreSQL course on window functions? You've come to the right place! If you are reading this article, you probably know PostgreSQL is one of the most popular databases in the world.
Read more
25 Feb 2026
LearnSQL.com Team

Your 90-Day Plan to Learn the SQL Skills Hiring Managers Want in 2026

Want to get job-ready SQL skills in three months? This 90-day plan shows you exactly what to learn, when to practice, and how to build projects that hiring managers care about. Follow the steps, stay consistent, and you’ll be ready for real SQL interview tasks in 2026. If you look at SQL job listings today, you’ll notice something interesting. The tools change, cloud platforms evolve, dashboards look different, but the core SQL skills employers expect stay surprisingly consistent.
Read more
18 Feb 2026
Scott Davis

The SQL Metrics Interviewers Really Care About (From Real Interviews)

After a few SQL interviews, it’s easy to assume every company tests something different. After 11 of them, that assumption stopped holding up. Despite differences in companies and formats, the same metric questions kept coming back. This article summarizes what I saw most often and what those patterns say about how SQL interviews really work. Between November 2023 and April 2025, I took part in 11 data analyst interviews that included SQL technical screens.
Read more
11 Feb 2026
LearnSQL.com Team

The Perfect Match: SQL Joins Explained

Not every invitation leads to a perfect match — and the same is true in SQL. This article explains SQL JOINs using a party guest list example, helping you understand how different JOIN types decide which records appear in the result. February is the month of love. Dating apps talk about matches, invitations go out for Valentine’s events, and everyone hopes things line up the right way. In SQL, we deal with matching all the time — just in a more practical way.
Read more
4 Feb 2026
LearnSQL.com Team

Building a Custom 'Recommendation Engine' in 10 Lines of SQL

Recommendation engines don’t always start with AI or machine learning. In many cases, a few well-written SQL queries are enough to uncover products that customers frequently buy together. In this article, you’ll build a simple recommendation engine in about 10 lines of SQL using self-joins and aggregation. When you hear “recommendation engine,” you probably think of machine learning, Python notebooks, and complex AI models. That association has become so common that we often forget how many recommendations in real systems are built on much simpler foundations.
Read more
1 Feb 2026
Jakub Romanowski

Free Course of the Month: Customer Behavior in MySQL

Have you ever wondered how businesses really get to know their customers? It’s all about analyzing behavior and, if you’re working with MySQL, there’s an awesome free course on LearnSQL.com that shows you how to do just that. Let me tell you all about it! If you’ve got the basics of MySQL down and want to dig into customer behavior analysis, you’re in luck! LearnSQL.com has a free course this month just for you—Customer Behavior Analysis in MySQL.
Read more
28 Jan 2026
Agnieszka Kozubek-Krycuń

How to Read a Database Schema and Know What to Query

SQL queries are rarely the problem. The real challenge is opening a new database and knowing where the data you need actually lives. This article shows how to read a database schema so you can quickly understand what to query and where to start. My husband claims that the hardest part of using SQL in practice isn’t writing queries. For him, the real challenge is opening a database he’s never seen before and figuring out where things are.
Read more
21 Jan 2026
Scott Davis

7 SQL Metric Patterns from Real-Life Interviews

After going through multiple SQL interviews for data analyst roles, I noticed the same metric questions appearing repeatedly. This article breaks them down into seven patterns and shows how to recognize them quickly in interviews. Throughout the period between November 2023 and April 2025, I interviewed for multiple data analyst roles and started noticing a clear pattern in SQL interview questions. While the datasets and business contexts changed, the types of metrics interviewers asked about were often the same.
Read more
13 Jan 2026
LearnSQL.com Team

Window Functions Starter Pack for 2026: Learn One Advanced Skill per Week in January

Window functions are one of the most practical SQL skills you can learn if you already know the basics and want to analyze data more effectively. They help you compare rows, build rankings, and track changes over time without complex subqueries. In this starter pack, you’ll learn one window function skill per week in January and turn an advanced topic into a usable, everyday SQL tool. Window functions are one of those SQL topics that often get labeled as “advanced” and then quietly postponed.
Read more