Back to the course guide
SQL LEARNING GUIDE

What SQL Is, and Where to Start

SQL is the language you use to ask a database for exactly the data you want.

Total up sales, count the customers who match a condition, pull two tables together into one view. Work you would otherwise do by hand in a spreadsheet becomes a single query.

Reading about it does not stick. Every screen on this page is driven by a real database, so you see the result first and then type the same thing yourself.

A real psql prompt. The query and the table coming back are both real
// WHY LEARN

What learning SQL gets you

01

Get the numbers yourself

Instead of asking someone for "last month by customer" and waiting, you write the query and have it in minutes.

02

Read the shape of data

Once tables, rows, columns, and keys click, you can read an unfamiliar system from its structure.

03

Join what is scattered

Orders here, customers there. Match them on a key and pull them out as one table.

orderscustomer_idtotal12,98031,200customersidname1sato3kim
Rows with the same key pair up. That is a JOIN
// TRY A LESSON

Try a real lesson, right here

From chapter 1 of SQL Introduction
// ROUTE

What order to learn in

One course for now. Ten lessons, from connecting to a database through rewriting rows.

Almost no prerequisites

You can start SQL without knowing the terminal. This course does use a real psql prompt, so if a command line is new to you, this one makes it easier. Terminal Introduction

After this

Creating tables, indexes, and subqueries belong to the next course. It is in preparation.