Learn SQL - Query.me

Learn SQL

Learn the most valuable skill for data analysis with our free, interactive SQL course in Query.me.

Get Started

learn-sql

Articles

introduction

What is SQL

Learn SQL in Query.me's interactive Notebook. Make use of the demo database to learn SQL on a live connection and realistic data. Chapter 01 - What is SQL, SQL vs Spreadsheet, Relational Databases, Basic Datatypes.

Chapter 1

SQL in Query.me

To follow along the SQL tutorial and practice exercises, you need a Query.me workspace and your own

Chapter 2

Basic query syntax

Let's dig into the basics of the SQL query syntax by querying a table called invoices. Each row in

Chapter 3

Basic query syntax, part 2

Sorting dataLet's now introduce another SQL feature: sorting. As the name implies, it enables us to

Chapter 4

Grouping data

Grouping data enables us to create an overview of some relevant dimensions of the underlying data, w

Chapter 5

Joining data

Up until now we have been querying a single table containing all the data related to our invoices:

Chapter 6

Subqueries & CTEs

Subqueries are, as the name suggests, queries nested within other queries and they can have several

Chapter 7

Unions

Unions enable us to collect related data from multiple tables. Let’s explain its use case and synta

Chapter 8

Window functions

Window functions add another tool to our data analysis tool belt, enabling us to perform aggregatio

Start sending data-driven messages today

Sign up and start using Query.me for free.
Or schedule a demo and discuss your use case.

Try it for free Book a Demo