Articles Cookbook
19 Dec 2024
Ekre Ceannmor

Amazon SQL Interview Questions

Are you preparing for an interview at Amazon? Take a look at these interview questions and check your professional SQL knowledge! Interview preparation for big companies such as Amazon can be overwhelming, but you can always practice beforehand and strengthen your SQL skills! In this article, we will go over Amazon SQL interview questions and help you prepare for your next big interview. Looking to master all of SQL and ace any task?
Read more
17 Dec 2024
Jakub Romanowski

Rookie SQL Mistakes That Can Cost You Time

As a junior data analyst, learning SQL can be both rewarding and challenging. It allows you to understand data and extract valuable insights, but common SQL mistakes often become frustrating barriers. In this guide, I’ve compiled the most frequent rookie SQL mistakes and how to avoid them, to help you save time and improve your skills more effectively. Initially, learning SQL was often frustrating due to minor errors that took hours to debug.
Read more
16 Dec 2024
LearnSQL.com Team

SQL Courses in UK

If you’re looking to learn SQL, we’ve put together a list of beginner-friendly courses available in the UK, both online and offline. These courses will help you get started with the basics of data management and analysis, even if you’re completely new to SQL. SQL is one of the most in-demand skills for anyone working with data. Whether you want to analyze business metrics, manage databases, or improve your job prospects, learning SQL is a smart choice.
Read more
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