Articles Cookbook
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
1 Aug 2023
Jakub Romanowski

Course of the Month: Window Functions Practice Set

Do you want to enhance your SQL skills and learn how to prepare complex SQL reports? Maybe you've learned SQL window functions but need a refresher. This month, our unique SQL course Window Functions Practice Set is completely free! You're probably wondering ‘What's the catch?’. Why do we give something for free to our users? Well... we want to support people like you who are constantly striving to be better.
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
11 Jul 2023
Maria Durkin

How to Master SQL

You've heard SQL is a must-have skill for furthering your career. You want to learn it. In this article, we look at why it is so beneficial to master SQL and how you can reach that level of mastery. Master SQL, and unlock the power of relational databases, the most used databases for managing structured data. But what makes SQL so important? SQL, or Structured Query Language, is a must-have skill for anybody navigating today's data-driven world.
Read more
6 Jul 2023
Jill Thornhill

Google BigQuery SQL Syntax: A Comprehensive Guide

What is Google BigQuery? What can it do for your organization? Is BigQuery SQL a valuable skill? Where can you learn it, and where can you get some practice? Very few organizations today are not computerized. Many processes now make use of the IoT (Internet of Things), where all kinds of devices are networked and continually feed real time data into computer systems. The result is a vast amount of data available for decision-making.
Read more