Articles Cookbook
13 Dec 2024
Ekre Ceannmor

SQL Quiz

Want to quickly check your SQL skills? Take this short quiz and get immediate results, together with advice on your future learning path! Want to quickly check your SQL skills? Our SQL Quiz is tailored just for you! It's a great way to verify your current knowledge and identify areas for improvement. If you want a more thorough test for your skills – including advanced topics like reports, window functions and much more – check out our free SQL Skill Assessment.
Read more
11 Dec 2024
Jakub Romanowski

Netflix Wrapped With SQL: Let’s Dive Into Your Streaming Year

In this article, we’re turning your Netflix viewing history into your very own Netflix Wrapped, using SQL. Ever wondered what show you binged the hardest or which day you couldn’t resist pressing play? I’ll show you how to pull all those fun insights. Let’s dig in! Hey! The year’s almost over, so why not take a fun look back at your Netflix habits? Remember all those weekends you said you’d "
Read more
10 Dec 2024
Alexandre Bruffa

Why Learn SQL as a Software Developer

As a software developer, you may have been in situations in which you had to work with SQL. You may wonder if having a superficial knowledge of SQL is enough for the role or if you should really delve into it. Short answer: you should! I will explain why software developers should learn SQL in this article. I have been a software developer for 15 years, and I’ve noticed a progressive change in the role.
Read more
10 Dec 2024
Jakub Romanowski

Make Your Own Spotify Wrapped With SQL (Because Why Not?)

Everybody’s showing off their Spotify Wrapped on social media, but what if you could make your own and see everything Spotify leaves out? With a bit of SQL, you can dig into your listening habits, see your true top tracks, and even find out how much time you spent looping that guilty pleasure song. It’s easy, fun, and a great way to flex your SQL skills. In this article I will show you how.
Read more
4 Dec 2024
Maria Durkin

SQL Exercises for Northwind Database

When it comes to learning SQL, many beginners struggle to gain practical experience that can eventually translate to real-world scenarios. We'll tackle this challenge by presenting Northwind database SQL exercises with solutions and explanations. In this article, we’ll cover 16 Northwind exercises taken from our SQL practice course Basic SQL Practice: A Store. As you might have guessed, the course uses Microsoft’s classic Northwind database. It’s a small trading company database that’s designed to give SQL learners some practical experience.
Read more
4 Dec 2024
Jakub Romanowski

Top U.S. Cities for SQL Developers to Earn the Most in 2025

If you’re an SQL developer looking to build your career in the US in 2025 this guide has you covered. We’ll cover the top cities to make the most of your SQL salary. New to the field, switching careers or looking to move up? Knowing where to focus can make a big difference to your salary and career progression. Understanding how location affects your SQL salary is key to making smart career decisions.
Read more
3 Dec 2024
Jill Thornhill

SQL CAST() Function: An Overview

The SQL CAST() function converts one data type to another. This article discusses what the function is for, and when and how you’d use it. In relational databases, every column has a defined data type that controls what kind of data is stored in the column and how that data can be used. For example, a product description is likely to be stored as a string of text, and you couldn’t use it for arithmetic (e.
Read more
3 Dec 2024
Jakub Romanowski

Top Advanced SQL Courses to Take in 2025

Are you looking to improve your SQL skills and master advanced SQL? This can be an incredible way to take your data work to the next level. Whether you’re in data analysis, data science, marketing, or finance, knowing how to write complex SQL queries can make a real difference. Advanced SQL can help you uncover meaningful insights, streamline processes, and truly stand out in your role. So, I’ve put together a list of the best advanced SQL courses you can take in 2025.
Read more
2 Dec 2024
Jakub Romanowski

Course of the Month: SQL Practice – A Store

Updated on: December 2, 2024 This December, seize the opportunity to learn and practice SQL for free with our Basic SQL Practice: A Store course. Designed for an interactive and hands-on learning experience, this course starts with SQL basics and guides you through crafting queries that underpin business intelligence. Ready to get a grip on the fundamentals of SQL and dive into practical database management? Our December Course of the Month, Basic SQL Practice: A Store, is your perfect match!
Read more
30 Nov 2024
LearnSQL.com Team

New Monthly SQL Practice for December 2024!

Ready for a new basic SQL challenge? This time, you will help Paige Turner, a local book club organizer, analyze her meeting data. Get ready to dive into the world of SQL queries as you help Paige enhance the reading experience for the members of her club! Welcome to the December SQL Practice course! In our December 2024 SQL Practice, you will meet Paige Turner, the organizer of a local book club.
Read more