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
Jakub Romanowski

Free 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
1 Aug 2023
Ignacio L. Bisso

What Is a CTE in T-SQL? An In-Depth 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
28 Jul 2023
LearnSQL.com Team

New Monthly SQL Practice for August 2023!

Are you an SQL beginner needing some interactive exercises to practice writing queries? Take the challenge and choose our August SQL Practice course. This is your next step towards becoming a pro. In our August 2023 SQL Practice, you meet Abigail, the manager of a local healthcare clinic. She needs you to help her gather the right statistics on the patients and the medical procedures they need. Use your SQL skills to help her find the data!
Read more
26 Jul 2023
Jakub Romanowski

The Best Way to Learn SQL: A Comprehensive 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

How to Use GROUP BY and ORDER BY in the Same Query: A Detailed 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