Articles Cookbook
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
31 Mar 2022
Ignacio L. Bisso

How to Use the ROUND() Function in SQL

Need to round numeric results in SQL? The ROUND() function is here to do the job. Modern relational databases offer many built-in functions that extend the capabilities of SQL. In this article, we will use practical examples to explain how the ROUND() function works. (Spoiler alert: If you guessed that it rounds a number to a certain decimal place, you’re right! Read on to find out more.) SQL Standard Functions Each SQL database (PostgreSQL, MySQL, Oracle, SQL Server among others) has a set of built-in functions.
Read more
24 Mar 2022
Tihomir Babic

How to Write Multiple CTEs in SQL

In this article, I will show you how to leverage the power of multiple CTEs (Common Table Expressions) by combining two or more in a single SQL query. I’ll explain how this technique can simplify complex queries, improve readability, and enhance efficiency when working with large datasets. Common table expressions, or CTEs, can be a powerful SQL tool. When you write two (or even more) CTEs together, this power multiplies.
Read more
22 Mar 2022
Tihomir Babic

The SQL Substring Function in 5 Examples

Working with text data in SQL? We explain how to get values from any point in a string. When you think of working with data in SQL, your first thought is probably a database full of numbers and your SQL code doing very fancy calculations. But text is data, too! It’s very common to find text data in databases. Not only do you have to extract it, but often you also have to manipulate it.
Read more
15 Mar 2022
András Novoszáth

SQL and Cloud Databases Are the Perfect Match!

Do you want to do analytics in the cloud? Are you considering learning SQL and wondering whether you can use it with cloud-based databases? Do you want to know how cloud databases and SQL work together? We answer your questions in this article. Read on! You may be an analyst who has heard about cloud databases and SQL and want to learn more. Maybe you are already familiar with them and want to know if the two technologies fit together.
Read more