SQL BASICS
Learn SQL by actually querying data. Type a query, hit run, and see real results just like a database console.
🗄️ SQL Playground
Next you’ll learn SELECT, WHERE, ORDER BY, GROUP BY, JOINs, and aggregations.
Master SQL, step by step.
Learn how databases really work, from tables and data types to joins, relationships, and a hands-on mini project.
What Is SQL & How Databases Work
SQL explained in plain English. Tables, rows, columns and how phpMyAdmin fits into the picture.
Creating Databases & Tables
Build your first database and table and learn data types so your schema makes sense.
Inserting Data & Auto Increment
Insert data using queries and the UI. Understand default values and how auto increment works.
Selecting Data with SELECT & WHERE
Fetch everything or only what you need then filter cleanly using WHERE.
Filtering Data with Operators
Use =, >, <, BETWEEN, IN, and LIKE to target exactly the data you want.
Sorting & Limiting Results
Make results readable with ORDER BY and control output size using LIMIT.
Updating Existing Data
Update records safely and understand why a missing WHERE can destroy your table.
Aggregate Functions & Statistics
Use COUNT, AVG, SUM and more to extract meaning from data, not just rows.
Primary Keys, Foreign Keys & Relations
Connect tables the right way. Learn keys, relationships, and how data stays consistent.
Mini Project: Real-World SQL
Put it all together in a real mini project — queries, filtering, aggregations, and relationships.