In this SQL Tutorial, you'll learn SQL (Structured Query Language) step by step, starting from the basics and working up through searching, filtering, sorting, inserting, updating, and deleting data in a database, all the way to building tables.
Why should you learn SQL?
Without data, a website, mobile app, POS system, booking system, dashboard, or reporting system is basically an empty box. SQL is the language that opens, searches, edits, and manages that box of data in a proper, organized way.
What you'll learn on this page
• What a database and a table actually are
• SELECT, WHERE, ORDER BY and how to pull data with them
• INSERT, UPDATE, DELETE and how to change data
• How to use aggregate functions to produce summary reports
• JOIN and how to link two tables together
• CREATE TABLE, constraints, and how to structure a database
Study tips
Work through the lesson menu on the left, step by step. Copy the code and try running it in an SQL playground. Don't just look at the output — pay attention to which column the query selects, which rows it filters, and what actually matters, and SQL will start clicking a lot faster.