Welcome. SimplifyDatabase explains SQL and databases in plain English, with real examples from real systems. There’s no single right order for everyone, so pick the description that sounds most like you and follow that path.
I’m completely new to databases
Start at the top and work down. Each article builds on the one before it, and you don’t need any technical background.
Prefer a full plan? The Learn SQL Roadmap takes you through 9 stages in order, from your first query to performance tuning, with a tutorial for every step.
Want real data to practise on? Download ShopDB, our free sample database for MySQL and SQL Server. Prefer a book? Simplify SQL for Absolute Beginners puts these lessons in order, with exercises and answers, and Chapters 1–3 are free.
- What is a Database? Explained Simply (Complete Beginner’s Guide)
- Types of Databases Explained for Beginners (With Real-Life Examples)
- SQL for Complete Beginners: Your First Queries Explained Simply
- SQL WHERE, ORDER BY & LIMIT Explained Simply (With Examples)
- SQL JOINs Explained Simply: Connecting Tables for Beginners
- SQL GROUP BY & Aggregate Functions Explained Simply
- SQL vs Excel: What’s the Difference? (And Which One Should You Learn?) (useful if you live in spreadsheets)
I know the basics and want to get better
You can write a SELECT and a JOIN. These are the topics that separate everyday SQL from really good SQL.
- SQL INSERT, UPDATE and DELETE Explained Simply
- The SQL CASE Expression Explained Simply (With Examples)
- NULL in SQL Explained Simply: IS NULL, COALESCE and Common Traps
- SQL Subqueries vs. CTEs Explained Simply (With Examples)
- SQL Window Functions Explained Simply (ROW_NUMBER, RANK, LAG and More)
- SQL Views Explained Simply: What They Are and Why to Use Them
I want to analyse data with SQL
For analysts, report writers and anyone who answers business questions from a database. Work through these in order.
Want the full plan? The SQL for Data Analysis roadmap lays out every step in order, from cleaning data to cohort and funnel analysis, with a tutorial for each one.
- Data Cleaning in SQL: A Step-by-Step Guide
- Basic Statistics in SQL: Average, Median, Percentiles and Standard Deviation
- SQL Window Functions Explained Simply
- Running Totals in SQL: Cumulative Sums and Running Balances
- Top N per Group: Get the Latest Record for Each Group
- SQL Date Functions Explained Simply
- SQL for Data Analysis: A Step-by-Step Roadmap (what to learn next)
I work with SQL Server
Practical guides for people using Microsoft SQL Server and SQL Server Management Studio day to day.
- Microsoft SQL Server Explained for Beginners
- SQL Stored Procedures Explained Simply (SQL Server, MySQL and PostgreSQL)
- SQL Transactions and ACID Explained Simply (With a Bank Example)
- SQL Indexes Explained Simply: What They Are and When to Use Them
- SQL Triggers Explained Simply (With a Price History Example)
- Database Backup and Restore Explained Simply (SQL Server, MySQL and PostgreSQL)
I’m a Delphi developer
Delphi and SQL Server together are still running a lot of business software. These articles include Delphi (FireDAC and ADO) examples.
- What Is Delphi? Install Delphi Community Edition and Build Your First App
- Delphi Basics: Variables, Data Types, If, Case and Loops
- Why Delphi Is Still a Great Choice for ERP and Business Apps
- How to Fix Query Timeouts in Delphi + SQL Server Apps
- SQL Injection: Parameterised Queries (incl. Delphi FireDAC)
- SQL Transactions and ACID Explained Simply (With a Bank Example)
- SQL Stored Procedures Explained Simply (SQL Server, MySQL and PostgreSQL)
I’m a Laravel developer
Laravel makes database work easy, until a page gets slow or a query does something you didn’t expect. These guides show the SQL behind Eloquent and how to keep it fast on MySQL and SQL Server.
New to SQL itself? Start with How to Learn SQL: A Step-by-Step Roadmap and SQL Injection Explained Simply.
My queries are slow
Start with indexes, because they fix most slow queries, then work through the rest.
Using SQL Server? Follow the SQL Server Performance Troubleshooting guide: one checklist from “it’s slow” to the real cause, with a deeper article for every step.
- SQL Indexes Explained Simply: What They Are and When to Use Them
- How to Fix Query Timeouts in Delphi + SQL Server Apps
- SQL Data Types Explained Simply: Choosing the Right Type for Each Column
- SQL Subqueries vs. CTEs Explained Simply (With Examples)
- How to Read a SQL Server Execution Plan (Beginner’s Guide)
- SQL Server Parameter Sniffing: Fast in SSMS but Slow in the App
- SQL Server Blocking: How to Find the Blocking Session
I’m designing a database
Get the structure right before you write a single query. It saves months of clean-up later.
- Primary Keys vs. Foreign Keys Explained for Beginners
- Database Normalization Explained Simply: 1NF, 2NF and 3NF With Examples
- SQL Data Types Explained Simply: Choosing the Right Type for Each Column
- SQL Constraints Explained Simply: NOT NULL, UNIQUE, CHECK and DEFAULT
- SQL Transactions and ACID Explained Simply (With a Bank Example)
I’m choosing a database
Not sure whether you need MySQL, PostgreSQL, SQL Server or something else? Read these in order.
I’m curious about big data
What changes when data gets too big, too fast or too varied for one ordinary database.
- What is Big Data? Explained Simply for Beginners
- Big Data vs. Data Science vs. Data Analytics: What’s the Difference?
- Understanding Data Lakes vs. Data Warehouses vs. Data Lakehouses
- OLTP vs OLAP Explained Simply
- Star Schema vs Snowflake Schema: Fact and Dimension Tables
- ETL vs ELT Explained Simply
- A Beginner’s Guide to the Data Science Lifecycle
Free SQL Book (PDF + EPUB)
Simplify SQL for Absolute Beginners takes the beginner lessons on this site, puts them in order and builds every example on one practice database, with exercises and answers. The first three chapters are free.
Free SQL Cheat Sheet (PDF)
All the beginner essentials on one printable page: SELECT, WHERE, ORDER BY, GROUP BY, HAVING, JOINs, INSERT, UPDATE, DELETE and the common data types.
Want new tutorials by email? Get one short email when a new article goes live, about once a week. No spam, and you can unsubscribe any time.
We only use your email to send SimplifyDatabase updates. See our Privacy Policy.
How to Get the Most Out of This Site
- Type the examples yourself. Reading SQL is not the same as writing it. Install a free database (SQL Server Express, MySQL or PostgreSQL) and run every query.
- One article at a time. Finish a topic and practise it before moving on.
- Want a book alongside? See the best SQL and database books, grouped by level.
- Stuck or found a mistake? Get in touch. Reader questions often become new articles.
Prefer to browse? Every article is listed on the All Articles page.