Learn SQL

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

Get Started

learn-sql

Articles

introduction

What is SQL

Learn SQL in PushMetrics'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 PushMetrics

To follow along the SQL tutorial and practice exercises, you need a PushMetrics workspace and your o

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 PushMetrics for free.
Or schedule a demo and discuss your use case.

Book a Demo