Query and manage relational databases with SQL: SELECT, filters, sorting, aggregates, JOINs, INSERT/UPDATE/DELETE, table design, subqueries, indexes and security. Your queries run on real SQLite in the browser.
Complete every lesson to get your certificate.
Module 1
Querying data
What a database is and how to ask it for exactly the information you need.
Unit 1 · First queries
Unit 2 · Summarizing and combining
Module 2
Modifying and designing databases
Insert, update and delete data; create tables with rules; subqueries, indexes and security.
Unit 1 · Changing data
Unit 2 · Beyond the basics