SQL Introduction

SQL stands for Structured Query Language. It is the standard language used to create, read, update, and manage data stored in relational databases. If an application has ever shown you a list of products, remembered your login, processed an order, or generated a report, there is a very good chance SQL was working behind the scenes to make that happen.

Unlike general-purpose programming languages such as Python or JavaScript, SQL was designed for one job: talking to databases. It lets you describe the data you want, and the database figures out how to fetch, combine, or change it efficiently.

What can you actually do with SQL?

SQL is really a small family of languages bundled together, each responsible for a different kind of job:

Query data — ask questions like "which customers placed an order last month?"
Insert, update, and delete data — add new rows, change existing values, remove records
Define schemas — create and modify the tables, columns, and constraints that structure your data
Control access — grant or revoke permissions so the right people (and applications) can read or write specific data
Manage transactions — group multiple changes together so they either all succeed or all fail

A quick taste

Here is a simple example. Imagine a table called employees that stores staff records. To find every employee working in the Engineering department, sorted by salary from highest to lowest, you could write:

A simple SELECT query

SQL

SELECT first_name, last_name, salary
FROM employees
WHERE department = 'Engineering'
ORDER BY salary DESC;

Read that almost like English: “select the first name, last name, and salary from the employees table, where the department is Engineering, ordered by salary descending.” That readability is one of SQL’s biggest strengths — you will see this pattern of SELECT ... FROM ... WHERE ... ORDER BY constantly throughout this tutorial.

Why learn SQL?

SQL has been in continuous, widespread use since the late 1970s, and it shows no signs of slowing down. A few reasons it remains one of the most valuable and durable skills in tech:

It's everywhere data lives — relational databases power banking systems, e-commerce platforms, healthcare records, analytics pipelines, and most backend applications
It's role-agnostic — backend engineers, data analysts, data scientists, DevOps engineers, and product managers all lean on SQL day to day
It's stable — the core syntax you learn today will still work in ten years; SQL evolves by addition, rarely by breaking changes
It transfers across tools — the same fundamental skills apply whether you're using PostgreSQL, MySQL, SQL Server, or a cloud data warehouse

What you'll learn in this series

This tutorial starts from first principles — what a database even is — and builds up through querying, joining, aggregating, designing schemas, and writing efficient, correct SQL. No prior database experience is assumed.

Tip

You don’t need to install anything to start learning. Later in this series we’ll cover lightweight ways to practice, including options that run entirely in your browser.