Articles Cookbook
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
28 Nov 2024
Ekre Ceannmor

SQL Queries for Google Sheets

Power up your data analysis skills by utilizing SQL queries for Google Sheets! This comprehensive guide will demonstrate how to use the QUERY function to combine the power of SQL with the accessibility of Google Sheets! Looking to make data analysis in Google Sheets faster and more powerful? The QUERY function lets you filter, sort, and analyze data just like you would in SQL – without leaving your spreadsheet! In this article, we will break down everything you need to get started using SQL queries for Google sheets.
Read more
26 Nov 2024
Ekre Ceannmor

How to Start Coding SQL in VS Code

Looking to enhance your SQL development? Our guide covers everything you need to get started with SQL in Visual Studio Code, the world's most popular IDE. Discover setup tips, extensions, database connections, and more to streamline your SQL coding experience. Visual Studio Code (VS Code) is currently the world’s most popular integrated development environment (IDE). It supports a variety of programming languages, and its massive community creates a lot of different extensions that help streamline your work or unlock even more potential within the IDE.
Read more
21 Nov 2024
Jakub Romanowski

SQL Skills Beyond Data Analysis: Why Non-Data Professionals Should Learn SQL

SQL isn’t just for techies—it’s a skill anyone can learn and use, no matter what their job is. It can help you handle data with ease, make better decisions, and save time on tasks. Read on and I’ll show you how learning SQL can benefit your career, and how to get started. You might think SQL is only for data geeks, but it’s a skill that can benefit anyone, even if your job doesn’t involve data every day.
Read more
20 Nov 2024
Tihomir Babic

SQL Interview Questions for Software Testers

SQL is a crucial skill for software testers. Otherwise, how would they get the data to test? Interviewers for these jobs may ask you several SQL software testing questions. So, if you’re preparing for a job interview, you’ll need to know how to answer these ten common SQL questions.  Why do software testing interview questions include SQL? Well, software testers commonly use Structured Query Language in their daily tasks.
Read more