Articles Cookbook
24 May 2022
Ignacio L. Bisso

How to Use the COALESCE() Function in SQL

SQL users are often faced with NULL values in their queries and need to process them properly. The COALESCE() function helps handle NULL values. Read this article to learn how to use COALESCE() in your queries. SQL tables store data in records, and records are composed of fields. There can be situations where we don’t know the value for a specific field. For example, when we don’t know the marital status of a person, SQL allows us to assign a NULL for this field.
Read more
19 May 2022
András Novoszáth

The Recent Rise of DBT and the Analytics Engineer

If you’re interested in data engineering or data analytics, you should know about DBT. And you should also learn about the role of an analytics engineer. We cover both in this article. The rise of Cloud data providers has led to new challenges and possibilities. If you are thinking about entering the data analytics space, it is important to be aware of them; it can help you decide what roles to aim for and what skills to learn.
Read more
17 May 2022
Tihomir Babic

Top 9 SQL GROUP BY Interview Questions

Preparing for an SQL job interview? This guide will walk you through nine basic, intermediate, and advanced GROUP BY questions that you may have to answer. There are common GROUP BY questions that pop up in a lot of SQL job interviews; in this article, we’ll explain how to answer them. If you are a data analyst or another data professional preparing for an interview, this article aims to help you out.
Read more
12 May 2022
Tihomir Babic

What Are Window Functions in SQL?

In this article, we discuss what window functions are and how they help you do your job as a data analyst or specialist. No, window functions have nothing to do with the operating system. The window here refers to a set of rows over which the function aggregates data. To learn how window functions work, what functions there are, and how to apply them to real-world problems, it’s best to take the Window Functions course.
Read more
10 May 2022
Kateryna Koidan

The Complete Guide to the SQL WHERE Clause

Learn how to use the SQL WHERE clause to filter rows. In this comprehensive article, we cover comparison operators and the BETWEEN, IN, LIKE, AND, OR, and NOT operators. Filtering output rows is one of the first things you need to learn when starting your SQL journey. In this guide, we’ll see how to use the SQL WHERE clause to filter rows in different scenarios. We’ll cover basic and some more advanced use cases.
Read more
5 May 2022
Himanshu Kathuria

Why Should Every Data Analyst Know SQL?

Want to become a data analyst? Then you’ll want to get cozy with SQL. In this article, I’m going to break down why mastering SQL is not just helpful but essential. We’ll look at how it can beef up your analysis skills and open doors to some really exciting job prospects. So, let’s see why SQL is a must-have tool for anyone aiming to be a top-notch data analyst.
Read more
28 Apr 2022
Kateryna Koidan

How to Update Only the First 10 Rows in SQL

Real-world databases require continuous updating. Often, you need to update specific records; you may even want to update only the first row, or the first 10, 100, or 1000 rows. Let’s explore how to update rows for a specified quantity from the top in SQL. What Is the SQL UPDATE? In SQL, an UPDATE statement modifies existing records of a table. You may choose to update entire columns or update rows filtered with a WHERE statement.
Read more
26 Apr 2022
Kamila Ostrowska

Top 5 MySQL Query Tools (Updated for 2024)

Are you on the hunt for a MySQL query tool that will make your database management a breeze? Let's dive into five of the best tools out there that promise to boost your productivity and make handling databases feel less like a chore. These tools come packed with features aimed at slashing the time you need to spend managing your data. Whether you're a developer, a database administrator, or just someone eager to get more out of your data management efforts, these MySQL query tools could be just what you need.
Read more
21 Apr 2022
Himanshu Kathuria

The SQL Syntax Is Simple: True or False?

Are you contemplating learning SQL but are concerned about how difficult it may be, especially if you have no prior coding experience? If so, you are not alone. In this article, I show you how simple the syntax of SQL is and that it is worth your time to learn it. You just need to know how to approach it properly. Many people carry the notion that learning SQL is much like learning other programming languages.
Read more
19 Apr 2022
Dmitri Vaitkun

What Are the Different SQL JOIN Types?

You just can’t understate the importance of the JOIN when learning SQL. Not only is it one of the most fundamental operations in relational databases, but it is also very versatile with many different types. Although SQL JOIN may be intimidating at first, it becomes a very handy instrument in your arsenal once you understand it. Let’s explore all the SQL JOIN types! We can safely say the JOIN operation is one of the most powerful features of SQL.
Read more