Articles Cookbook
15 Aug 2023
Jill Thornhill

Data-Driven Career Choices: Database Student

Choosing a career is one of the most important decisions you'll ever make. A data-driven career is one of the best ways to secure your future; today's trend is to store and make use of more and more data in every field. In this article, I'll look at some of the choices available. We're living in an era where the quality and quantity of data is expanding exponentially. In almost any career you choose, you'll need to leverage data to make effective decisions.
Read more
10 Aug 2023
Martyna Sławińska

Advanced SQL Practice: 10 Exercises with Solutions

As SQL proficiency continues to be in high demand for data professionals and developers alike, the importance of hands-on practice cannot be emphasized enough. Read on to delve into the world of advanced SQL and engage in practical exercises to enhance your skills. This article provides you with a collection of ten challenging SQL practice exercises specifically for those seeking to enhance their advanced SQL skills. The exercises cover a selection of SQL concepts and will help you refresh your advanced SQL knowledge.
Read more
8 Aug 2023
Dominika Florczykowska

What Does GROUP BY 1 and GROUP BY 1, 2, 3 Mean in SQL?

Have you ever come across the unfamiliar GROUP BY 1 syntax in SQL queries and wondered what it's all about? Well, you're not alone! In this article, we'll dive into this syntax, explain its purpose, and make it easier to understand. Whether you are a regular SQL user or you’re just beginning to learn this language, you have probably worked with GROUP BY before. The GROUP BY clause in SQL is used to group rows from a table based on one or more columns.
Read more
3 Aug 2023
Jakub Romanowski

Best SQL Books for Data Analysis

In the world of data analysis, SQL is a powerful tool. It's a language that helps professionals find, organize, and analyze the data stored in databases. If you're looking to learn this important skill, you've come to the right place. This article will guide you through the best SQL books for data analysis, whether you're just starting out or already have some experience. SQL (Structured Query Language) is a standard language used for working with databases.
Read more
1 Aug 2023
Ignacio L. Bisso

CTE in T-SQL: A Beginner’s Guide with 7 Examples

A common table expression (CTE) is a powerful T-SQL feature that simplifies query creation in SQL Server. CTEs work as virtual tables (with records and columns) that are created on the fly during the execution of a query. They are consumed by the query and destroyed after the query executes. In some cases – like when the query expects data in a specific format and the source tables have the data in another format – a CTE can act as a bridge to transform the data in the source tables to the format expected by the query.
Read more
26 Jul 2023
Jakub Romanowski

The Best Way to Learn SQL: A Complete Guide for Beginners

If you've ever wondered about the best way to learn SQL, you're in the right place. Whether you're a complete beginner or an experienced professional looking to upskill, this comprehensive guide will show you the way. In today's data-driven world, you can think of data as a treasure chest full of gold. And SQL (Structured Query Language) is your personal key to unlocking it. SQL is a potent tool that allows you to communicate with databases, enabling you to extract, shape, and make sense of data.
Read more
25 Jul 2023
Tihomir Babic

Using GROUP BY and ORDER BY Together: A Guide

Untangling how to use two basic SQL clauses – GROUP BY and ORDER BY – in one query. GROUP BY and ORDER BY are basic SQL clauses. As such, they are taught relatively early in the learning process. And they usually don’t present a big hurdle to beginners. However, using GROUP BY and ORDER BY together can be confusing. By the end of this article, your confusion on this subject will go away.
Read more
20 Jul 2023
Tihomir Babic

A Complete Guide to Working With Substrings in SQL

In this article, we’ll discuss how to work with substrings in SQL. It involves learning several approaches, so we’ll show you their ins and outs. To work with substrings in SQL, we first need to know what a string is. In programming, a string is any kind of textual data (a title, a description, a name). A string consists of any number and type of characters. In a SQL database, strings are typically stored as CHAR or VARCHAR data types.
Read more
18 Jul 2023
Maria Durkin

SQL for Data Analysis: What Should I Learn?

You may already be aware of SQL's importance in data analytics. But what features of SQL are important to data analysis and where can you learn them? In this article, we will answer your questions. Before we talk about using SQL for data analysis, it helps to know what we’re talking about. So, let’s define these two things. Structured Query Language (SQL) is a programming language that is used to manage data in relational databases.
Read more
13 Jul 2023
Alexandre Bruffa

How SQL Skills Can Boost Your Resume

You may wonder: does having SQL skills matter? In what areas could I use my SQL skills? In this article, I will explain how having SQL skills can boost your resume and add momentum to your professional career. We are living in the Big Data era. Every time we go online, we provide the websites we visit with a lot of information. If we voluntarily give our data by creating an account, filling out a form, or making a purchase, we give them even more information.
Read more