Query real data with SQL: SELECT, filtering, sorting, joins, grouping, and the tables behind every app.
Every app you have ever used is a thin layer of interface over a database, and the language of databases is SQL. It has outlived five decades of replacements for one reason: it is a nearly perfect way to ask questions about data. A working query reads close to plain English, the answer comes back as a table you can look at, and you find out immediately whether you asked the right question.
This course runs a real SQL engine in your browser. Your queries execute against real tables holding real rows, so the results are genuine and so are the mistakes. You start by reading one table of six people and finish by designing a database from an empty editor. Nothing is installed, nothing is simulated, and every exercise checks the rows your query returned rather than the words you typed.
You build four things along the way: a crew report that answers a specific question, a mission board that joins two tables into one answer, a set of updates that changes data on purpose and proves what changed, and the capstone database you design, fill, and query yourself. No programming experience is assumed anywhere. SQL is not a programming language, and this is the one course in the program that begins at absolute zero.
45 Lessons • 53 Practices • 18 Quizzes • 4 Projects · ~10h Total
Not just theory. You finish this course with real work to show.
This is the same in-browser editor every lesson uses. Edit the code, hit Run.
Run code in the browser and see the result immediately. Every lesson works this way.
Stuck? Puff explains the error and nudges you forward, without giving the answer away.
Streaks, diamonds, and certificates. Your progress saves automatically, forever.
Every completed course issues a certificate with a public verification link.
Every certificate has a public verification link employers can check.
One certificate per course. Finish a program and earn its program certificate too.
LinkedIn-ready, with a PDF you can download and attach.
You have never written a line of code. SQL is its own language, and this course starts at the first query.
Every API you build eventually answers to a database. This is the half that stores the data.
Stop asking somebody else for a number you could pull yourself in one query.
SQL Basics is free to start, no credit card needed. Some later sections are part of Pro, and finishing every section, including the certificate, needs a Pro plan.
No. SQL is a query language, not a programming language: there are no loops, no functions to write, and no setup. The first item is a single line, and everything after it builds on that line. This is the one course in the Full-Stack Development program that assumes nothing at all.
No. A real SQL engine runs inside your browser tab, and every exercise loads its own small set of tables before your query runs. Your queries execute for real, and the checks read the rows that came back.
How this course connects to the bigger picture, and what to explore next.
Free to start, no credit card required. Write real code from the first lesson and keep your progress forever.
Start Learning FreeThe engine here is SQLite, and the core you learn (SELECT, WHERE, ORDER BY, JOIN, GROUP BY, INSERT, UPDATE, DELETE, CREATE TABLE) is the same language in PostgreSQL, MySQL, and SQL Server. Where SQLite differs from the others in a way that would catch you out, the course says so at the point it matters.
For reading and reporting, yes. You finish able to answer real questions from real tables, which is most of what SQL is used for day to day. Performance tuning, transactions, and database administration are separate subjects and are not covered.
Four things: a crew report, a mission board that joins two tables, a set of data changes you verify yourself, and a capstone database you design from an empty editor, fill with rows, and then query.
Yes. Finish every item in SQL Basics and Devpuff issues a course certificate with a public link anyone can verify.
Design and build a REST API: resources, verbs, status codes, validation, paging, and real errors.