Articles Cookbook
6 Dec 2022
Jill Thornhill

The Future of SQL

Is it worthwhile to learn SQL? Or will a language that’s over 40 years old soon be outdated? Have relational databases been eclipsed by the advent of other database solutions like NoSQL? In this article, we answer these questions. Thinking about upgrading your IT skills but unsure where to start? With so many options, it’s easy to feel overwhelmed. If you want to invest your time wisely, choose something that’s not just relevant today but will stay in demand for years to come.
Read more
29 Nov 2022
Ignacio L. Bisso

How to Choose Data Types for SQL Table Columns

Databases store data values of various kinds. For example, you may store the name of a product as a text string, the price of a product as a number, or the date a product is sold as a date value. These values – the product name, the price, and the sale date – are stored as different data types. In this article, we explain several SQL data types with real examples.
Read more
24 Nov 2022
Kamila Ostrowska

The Most Popular Databases in 2024

If you work with data – or if you want to start – you need a database that will answer your needs. Not sure what to choose? Don’t worry! In this article, you’ll find a list of today’s most popular and efficient databases, with a quick summary of what each one does. Businesses run on data. But to get the most from that data, it needs to be stored in a structured way – usually in a database.
Read more
22 Nov 2022
Martyna Sławińska

How to Export Data from MySQL into a CSV File

A database is a primary platform for working with data and storing data. But often, you must take your data out of the database. Read on to find out how to export data from MySQL database into a CSV file. In this article, we’ll demonstrate how to export data into a CSV file. We’ll start by introducing what a CSV file is and why we use it. Then, we’ll export data from a MySQL database into a CSV file.
Read more
18 Nov 2022
Alexandre Bruffa

I’m a Software Developer. How Do I Learn SQL?

What do you need to know about relational databases and SQL as a software developer? In this article, we’ll explain the topics you need to know and how you can acquire this knowledge. If you are a software developer, you may have noticed that SQL skills are often required in some development roles. Although you are not a database manager or a data scientist, you will need solid SQL foundations to continue your developer journey.
Read more
17 Nov 2022
Luke Hande

What Is an SQL Database?

SQL databases have been used for decades and have grown in popularity, becoming one of the most common data management tools. They provide the user with an efficient way to store the data and an intuitive way to access or modify it. In this article, we’ll start by explaining what a database is and showing some examples. We’ll move on to how databases can be used to efficiently work with large amounts of structured data.
Read more
10 Nov 2022
Tihomir Babic

How to Use GROUP BY in SQL

In this article, we’ll give you a step-by-step guide on using GROUP BY in SQL. Uncover the nuances of the GROUP BY clause and learn different ways of using it. GROUP BY is one of the most-used clauses in SQL. It moves you from simply selecting data from the database to grouping rows with the same column values into one group. When used with SQL’s aggregate functions, you can use GROUP BY to compute metrics like counting the number of instances or finding the total, average, minimum, or maximum value.
Read more
8 Nov 2022
Tihomir Babic

How to Use the PARTITION BY Clause in SQL

We’ll be dealing with the window functions today. Specifically, we’ll focus on the PARTITION BY clause and explain what it does. PARTITION BY is one of the clauses used in window functions. In SQL, window functions are used for organizing data into groups and calculating statistics for them. It sounds awfully familiar, doesn’t it? Even though they sound similar, window functions and GROUP BY are not the same; window functions are more like GROUP BY on steroids.
Read more
3 Nov 2022
Jakub Romanowski

Track of the Season: SQL from A to Z in SQL Server

Maybe your company uses MS SQL Server and you’d like to join the data analysis team. Or maybe you want to add a new skill to your CV. Either way, our SQL Track of the Season: SQL from A to Z in MS SQL Server, will help. In this article, I’ll answer common questions about this awesome set of online MS SQL Server courses. If you’re reading this blog post, you probably already know that you should start learning SQL and working with databases.
Read more
27 Oct 2022
Ignacio L. Bisso

What Are the Basic SQL Queries?

You can access the data in a database using some basic SQL queries. In this article, we review the fundamentals SQL queries every beginner should know. Databases are everywhere, and they contain different kinds of data. Almost all of them support SQL, a language that lets you read and manipulate the data inside a database. In this article, I’ll show you the basic SQL queries that you can use to perform many common everyday data tasks.
Read more