Articles Cookbook
10 Jan 2023
Alexandre Bruffa

Database Jobs to Choose in 2025

In this article, we will explore some of the top database jobs to choose from in 2025. Are you skilled at writing SQL queries, managing databases, or analyzing data? Maybe you enjoy solving data puzzles or creating systems that make businesses run smoother. If so, these top database professions for 2025 could be your chance to land high-paying jobs that match your skills and interests. Let's discover which roles could be your next big opportunity!
Read more
5 Jan 2023
Nicole Darnley

UNION and UNION ALL in SQL Explained

In this article, we’ll explore the SQL clauses UNION and UNION ALL. Learn what they do and when to use each one. I had been an analyst for probably four years before I knew about the SQL clause UNION ALL. I used UNION on a regular basis, but had never heard of its counterpart. Then one day when I heard a coworker talking about it. I thought to myself, “What is he talking about?
Read more
3 Jan 2023
Kamila Ostrowska

SQL Books for Beginners

How can you learn SQL more efficiently? Besides a good online course, find an interesting book to enrich your knowledge. Here are the best SQL books for beginners. SQL, or Structured Query Language, is a very powerful tool to work with many types of data. Understanding the SQL language is crucial for managing, analyzing, and manipulating data effectively. If you are interested in learning SQL you probably know how useful it is, and how widely it is needed.
Read more
29 Dec 2022
Ignacio L. Bisso

How to Practice SQL Subqueries

Have you ever wondered what separates beginners from advanced SQL users? It includes things like, for example, subqueries. In this article, I explain their importance and why you need to practice SQL subqueries to become an expert. What Is an SQL Subquery? SQL is an easy-to-learn language. However, there are certain complex features and techniques of the language that require practice. One of these features is the subquery, which adds great expressive power to the language and your projects.
Read more
27 Dec 2022
Alexandre Bruffa

Learn Advanced SQL with LearnSQL.com

In this article, we will propose a learning path that will cover advanced SQL topics. If you already know the basics of SQL, you probably have figured out that most online and offline SQL tutorials and courses usually cover the basic and intermediate concepts: SELECT, FROM, WHERE, ORDER BY, GROUP BY, and joining tables. Even university database courses typically don’t cover more advanced  SQL topics. While this is enough SQL for most everyday tasks, there are some relatively new features that have been added to SQL in the last 20 years: window functions, recursive queries, and GROUP BY extensions (ROLLUP, CUBE, GROUPING SET).
Read more
22 Dec 2022
Marko Calasan

What Are DDL, DML, DQL, and DCL in SQL?

We explore the separation of SQL into its four principal sublanguages and explain the meaning behind each of them. When you’re learning SQL – perhaps through LearnSQL.com’s very own comprehensive SQL Basics course – you may have come across the terms DDL, DML, DQL, and DCL. And maybe you’ve gotten confused by all the acronyms. In this article, we will explain what these terms stand for and how they correspond to sublanguages that neatly divide the SQL language into four parts that function together.
Read more
20 Dec 2022
Nicole Darnley

How to Use WHERE with GROUP BY in SQL

In this article, we’ll discuss how to combine the WHERE and GROUP BY clauses in SQL. If you’re writing SQL on a daily basis, you will quickly realize how often both WHERE and GROUP BY clauses are used. WHERE is an essential part of most queries. It allows you to filter large datasets to only the pieces you are interested in. GROUP BY is one of the most powerful tools an analyst has when aggregating data.
Read more
15 Dec 2022
Maria Durkin

Want to Get a Data Engineering Job? Learn SQL!

So, you want to be a data engineer, but you don't know how to get there. In this article, we’ll help you understand the skills you'll need for different types of data engineering jobs. You’ll also find some data confirming that data engineer jobs are a good career choice. The demand for data experts has grown rapidly, and companies are actively looking for specialists who can work with databases and turn raw data into valuable insights.
Read more
13 Dec 2022
Tihomir Babic

5 Practical Examples of SQL’s WITH Clause

These five practical use cases will make you want to use the SQL WITH clause daily. The WITH clause can help you write readable SQL queries  and break complex calculations into logical steps. It was added to SQL to simplify complicated long queries. In this article, we’ll show you 5 practical examples of the WITH clause and explain how using it makes SQL queries more readable. The WITH clause is also called a Common Table Expression (CTE).
Read more
8 Dec 2022
Martyna Sławińska

How to Export Data From Microsoft SQL Server to a CSV File

When working with data and databases, it is common to export data for further processing or transport to another database. Follow this article to learn how to export data from Microsoft SQL Server to a CSV file. In this article, we first recall what a CSV file is and why you would want to export data in this format from an MS SQL Server database. Then, we cut to the chase and export data to a CSV file using both SQL Server Management Studio (SSMS) and SQL Command Line (SQLCMD).
Read more