Articles Cookbook
12 Jun 2020
Jakub Romanowski

Top SQL Social Media Groups & Channels to Follow

We get news, advice, and funny videos from Facebook, Twitter, and YouTube. Why not use social media to help you learn SQL? You wake up and the first thing you do is check for Facebook notifications. Do you take a photo of your breakfast and share it with friends on Instagram? Maybe you argue with someone on Twitter about which James Bond was the best? Or maybe you are recording a short TikTok video of you singing Lady Gaga?
Read more
11 Jun 2020
Kamil Bladoszewski

What’s an SQL Inline Query?

Have you ever heard the term “inline query”? How are they different from subqueries and derived tables? Have you looked this up in numerous places and still don’t know the answer? Let’s embark on a journey and find out together! The first time I heard the term “inline query”, I was a little bit surprised. It doesn’t sound like one of SQL’s nuances and I thought I knew all the basic concepts.
Read more
10 Jun 2020
Dorota Wdzięczna

New Course Series: Monthly SQL Challenges

SQL learners sometimes need challenges. Do you want to test your problem-solving skills or your knowledge of SQL? Then take our monthly SQL Challenges! We prepare them on LearnSQL.com every month. Each Challenge relates to a different interesting topic and will help you keep your SQL game sharp. In this article, you'll discover what our LearnSQL.com Monthly Challenges are and where to find them. We’ll also look at the Challenges collected in our Monthly SQL Challenge Mini Track.
Read more
9 Jun 2020
Kateryna Koidan

Practical Examples of When to Use Non-Equi JOINs in SQL

If you think that two tables in SQL can be joined only using the common field, you will be excited to learn that there are other ways of joining. Non-equi JOINs use different kinds of comparison operators in the JOIN condition. In this article, I’ll guide you through non-equi JOIN examples to show the common use cases for this type of JOIN. Equi JOIN vs. Non-Equi JOIN How do you usually join two tables in SQL?
Read more
4 Jun 2020
Pierre Timms

How to Convince Your Boss You Need SQL Training

Learning SQL is a great goal. Now, if you could only convince your boss that it’s good for the company as well as for you ... You’re aware of the benefits of adding SQL to your skill set. You believe that the rewards gained from you learning SQL will also benefit your employer – it’s not just another way for you to develop your professional profile. But how do you articulate this to your boss?
Read more
3 Jun 2020
Rebecca McKeown

Top 5 Programming Languages to Learn Alongside SQL

If you already know or are about to learn SQL, you’re well on your way to being a sought-after database administrator, database engineer, or just a general database whizz kid! SQL is a modern, widely-used language that finds application in almost every industry. There is no shortage of jobs with SQL. But what if you want to branch out and learn another language to complement your SQL knowledge and skills?
Read more
2 Jun 2020
Zahin Rahman

How to Learn SQL JOINs

JOINs are one of the most fundamental and commonly used SQL commands for manipulating and querying real-world data sets. They are also one of the more challenging SQL topics to master! In this article, you’ll learn an effective strategy to learn the different types of SQL JOINs. When data is stored in a single table, we can easily retrieve rows and get all the information we need. But when businesses scale, so does their data.
Read more
29 May 2020
Kateryna Koidan

What Are the Different Types of SQL Subqueries?

Subqueries can be used in many business cases. What subquery types does SQL offer? And how can you use them efficiently? In this article, I’ll guide you through different subquery types and the typical situations when they are useful. What Is an SQL Subquery? A subquery, or nested query, is a query placed within another SQL query. There are many different scenarios where you may want to include a query in the WHERE, FROM, or SELECT clauses of your main query.
Read more
28 May 2020
Dorota Wdzięczna

Subquery vs. JOIN

One of the challenges in writing SQL queries is choosing whether to use a subquery or a JOIN. There are many situations in which a JOIN is the better solution, and there are others where a subquery is better. Let’s consider this topic in detail. Subqueries are used in complex SQL queries. Usually, there is a main outer query and one or more subqueries nested within the outer query.
Read more
27 May 2020
Tihomir Babic

5 Advanced SQL Constructions Every Data Analyst Should Learn

Does your job involve data analysis? Here are five examples of how advanced SQL can help you in your daily work. I’m a data analyst and I have to say – data analysts can be quite strange. Other people are usually afraid of immense amounts of data; we enjoy it. The deeper we get into data, the happier we are. An important tool for getting into data (and thus being a happier data analyst) is SQL.
Read more