SQL Tutorial for Beginners: The Complete Step-by-Step Guide (2026)

Learn SQL from scratch with practical examples, essential commands, and best practices. This beginner-friendly SQL tutorial covers everything you need to start querying databases confidently.

Learn SQL from Scratch: Step-by-Step SQL Tutorial for Beginners

What is SQL?

SQL (Structured Query Language) is the standard language for managing and querying data in relational databases. It lets you retrieve, insert, update, and delete data efficiently.

SQL is used by data analysts, software developers, data scientists, and business intelligence professionals. Almost every modern application that stores structured data relies on SQL databases like MySQL, PostgreSQL, SQL Server, or SQLite.

Why Learn SQL in 2026?

High demand in data analysis, backend development, and business intelligence roles
Works across major database systems with only minor syntax differences
Essential skill for working with data warehouses, BI tools, and AI/data pipelines
Relatively easy to learn compared to full programming languages

Prerequisites

You only need basic computer skills. No prior programming experience is required.

Setting Up Your Environment

Popular free options for beginners:

MySQL + MySQL Workbench
PostgreSQL + pgAdmin
SQLite (great for practice, no server needed)
Online playgrounds: DB Fiddle, SQLite Online, or W3Schools SQL Tryit Editor

Core SQL Categories

SQL commands fall into these main groups:

Category	Purpose	Common Commands
DDL (Data Definition Language)	Define structure	CREATE, ALTER, DROP
DML (Data Manipulation Language)	Modify data	INSERT, UPDATE, DELETE
DQL (Data Query Language)	Retrieve data	SELECT
DCL (Data Control Language)	Control access	GRANT, REVOKE
TCL (Transaction Control Language)	Manage transactions	COMMIT, ROLLBACK

1. Creating a Database and Table (DDL)

SQL

CREATE DATABASE company_db;
USE company_db;

CREATE TABLE employees (
    id INT PRIMARY KEY AUTO_INCREMENT,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(100) UNIQUE,
    salary DECIMAL(10,2),
    department VARCHAR(50),
    hire_date DATE
);

2. Inserting Data (DML)

SQL

INSERT INTO employees (first_name, last_name, email, salary, department, hire_date)
VALUES 
('John', 'Doe', 'john.doe@example.com', 75000.00, 'Engineering', '2023-01-15'),
('Jane', 'Smith', 'jane.smith@example.com', 82000.00, 'Marketing', '2022-06-20'),
('Mike', 'Johnson', 'mike.j@example.com', 68000.00, 'Sales', '2024-03-10');

3. Retrieving Data with SELECT (Most Important Command)

Basic SELECT

SQL

SELECT * FROM employees;

Select specific columns

SQL

SELECT first_name, last_name, salary FROM employees;

Filter with WHERE

SQL

SELECT * FROM employees 
WHERE department = 'Engineering' AND salary > 70000;

Sort results

SQL

SELECT * FROM employees 
ORDER BY salary DESC;

Limit results

SQL

SELECT * FROM employees 
ORDER BY hire_date DESC 
LIMIT 5;

4. Updating and Deleting Data

SQL

-- Update
UPDATE employees 
SET salary = 80000 
WHERE id = 1;

-- Delete
DELETE FROM employees 
WHERE id = 3;

Always use WHERE carefully — missing it can affect all rows.

5. Filtering and Pattern Matching

SQL

-- Exact match
SELECT * FROM employees WHERE department = 'Sales';

-- Pattern matching
SELECT * FROM employees WHERE first_name LIKE 'J%';   -- Starts with J
SELECT * FROM employees WHERE email LIKE '%@example.com';

-- Multiple values
SELECT * FROM employees WHERE department IN ('Engineering', 'Marketing');

-- Range
SELECT * FROM employees WHERE salary BETWEEN 60000 AND 80000;

-- Null checks
SELECT * FROM employees WHERE email IS NULL;

6. Aggregate Functions and GROUP BY

SQL

SELECT 
    department,
    COUNT(*) AS employee_count,
    AVG(salary) AS avg_salary,
    MAX(salary) AS max_salary,
    MIN(salary) AS min_salary
FROM employees
GROUP BY department
HAVING AVG(salary) > 70000;

Common aggregates: COUNT(), SUM(), AVG(), MAX(), MIN().

7. Joins – Combining Tables

Assume we also have a departments table:

SQL

CREATE TABLE departments (
    dept_id INT PRIMARY KEY,
    dept_name VARCHAR(50),
    location VARCHAR(50)
);

INNER JOIN (only matching rows)

SQL

SELECT e.first_name, e.last_name, d.dept_name, d.location
FROM employees e
INNER JOIN departments d ON e.department = d.dept_name;

LEFT JOIN (all from left table + matching from right)

SQL

SELECT e.first_name, d.dept_name
FROM employees e
LEFT JOIN departments d ON e.department = d.dept_name;

Other joins: RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, SELF JOIN.

8. Useful Advanced Beginner Topics

Aliases

SQL

SELECT first_name AS name, salary AS annual_pay FROM employees;

DISTINCT

SQL

SELECT DISTINCT department FROM employees;

ORDER BY with multiple columns

SQL

SELECT * FROM employees 
ORDER BY department ASC, salary DESC;

Subqueries (simple example)

SQL

SELECT first_name, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);

Best Practices for Writing Good SQL

Use meaningful table and column names
Always specify column names instead of SELECT * in production
Use proper indentation and consistent casing (many prefer uppercase keywords)
Add comments with -- for single lines
Use primary keys and indexes for performance
Avoid selecting unnecessary columns
Test queries with LIMIT first on large tables
Prefer parameterized queries in applications to prevent SQL injection

Common Mistakes Beginners Make

Forgetting the WHERE clause on UPDATE/DELETE
Confusing = with LIKE
Not understanding NULL (use IS NULL / IS NOT NULL)
Mixing up JOIN types
Ignoring performance (large result sets without LIMIT/indexes)

Practice Exercises

Create a table for products with columns: id, name, price, category, stock.
Insert 5 sample products.
Write a query to find all products priced above 50 in the “Electronics” category.
Calculate the average price per category.
Update the stock of a specific product.

Next Steps After This SQL Tutorial

Learn window functions (ROW_NUMBER(), RANK(), LAG(), LEAD())
Master Common Table Expressions (CTEs)
Practice with real datasets (Kaggle, public databases)
Study database design and normalization
Explore your specific database’s advanced features (JSON support, full-text search, etc.)
Practice interview-style SQL questions

Quick SQL Cheat Sheet

Task	Command Example
Select all	SELECT * FROM table;
Filter	WHERE column = value
Sort	ORDER BY column DESC
Group	GROUP BY column
Count	COUNT(*)
Join	INNER JOIN table2 ON ...
Insert	INSERT INTO table VALUES (...)
Update	UPDATE table SET col = val WHERE ...
Delete	DELETE FROM table WHERE ...

SQL Tutorial for Beginners — Flashcards

🟢 Basics

Q: What does SQL stand for?
A: Structured Query Language.
Q: What is SQL used for?
A: Managing and querying data stored in relational databases.
Q: What is a database?
A: An organized collection of data.
Q: What is a table?
A: A structure containing data arranged in rows and columns.
Q: What is a row?
A: A single record in a table.
Q: What is a column?
A: A field/attribute that describes one type of data.

🔵 SELECT

Q: How do you retrieve all columns from a table?
A: SELECT * FROM table_name;
Q: How do you retrieve specific columns?
A: SELECT name, age FROM students;
Q: What does SELECT do?
A: Retrieves data from a database.
Q: What does FROM specify?
A: The table from which data is retrieved.

🟡 Filtering

Q: What does WHERE do?
A: Filters rows based on a condition.
Q: Example of WHERE?
A: SELECT * FROM students WHERE age > 18;
Q: What operator means "equal to"?
A: =
Q: What operators mean "not equal to"?
A: <> or != (depending on the database).
Q: What does AND do?
A: Requires multiple conditions to be true.
Q: What does OR do?
A: Requires at least one condition to be true.

🟠 Sorting & Limiting

Q: What does ORDER BY do?
A: Sorts query results.
Q: How do you sort from highest to lowest?
A: Use DESC.
Q: How do you sort from lowest to highest?
A: Use ASC (the default).
Q: What does LIMIT do?
A: Restricts the number of rows returned in databases that support it.

🔴 Aggregation

Q: What does COUNT() do?
A: Counts rows or non-NULL values, depending on how it is used.
Q: What does SUM() do?
A: Adds numeric values.
Q: What does AVG() do?
A: Calculates an average.
Q: What does MAX() do?
A: Returns the largest value.
Q: What does MIN() do?
A: Returns the smallest value.
Q: What does GROUP BY do?
A: Groups rows so aggregate functions can be applied to each group.

🟣 JOINs

Q: What is a JOIN?
A: A way to combine related data from multiple tables.
Q: What does INNER JOIN return?
A: Rows with matching values in both tables.
Q: What does LEFT JOIN return?
A: All rows from the left table plus matching rows from the right table.
Q: What is a primary key?
A: A column or set of columns that uniquely identifies each row.
Q: What is a foreign key?
A: A column that references a key in another table.

🧠 Practice Card

Q: What does this query return?

SELECT name, salary
FROM employees
WHERE salary > 50000
ORDER BY salary DESC;

A: Employee names and salaries above 50,000, sorted from highest salary to lowest.

Conclusion

This SQL tutorial gives you a solid foundation to start working with databases. The key to mastering SQL is consistent practice — write queries daily, experiment with sample data, and gradually tackle more complex problems.

Start with the examples above, set up a free database, and practice the exercises. Once you’re comfortable with SELECT, WHERE, JOIN, and GROUP BY, you’ll already be more productive than most beginners.

Ready to go deeper? Practice on real projects or explore advanced topics like window functions and query optimization.

SQL tutorial, SQL for beginners, learn SQL, SQL commands, SQL SELECT, SQL JOIN, SQL basics, SQL query examples, Structured Query Language, database tutorial.

Best Free Data Science Courses for Beginners in 2026

FAQ

How can I learn SQL by myself?

Yes, you can easily learn SQL by yourself. Start with free resources like this tutorial, practice daily on platforms such as Mode Analytics, LeetCode, HackerRank, or DB Fiddle, and work on small real-world projects. Consistency matters more than paid courses.

How can I learn SQL?

Follow these simple steps:

Learn the basics (SELECT, WHERE, ORDER BY)
Practice writing queries every day
Learn JOINs and aggregate functions
Solve real problems with sample databases
Move to intermediate topics like subqueries and window functions

How long does it take to learn SQL?

Basic SQL: 1–2 weeks (with 1–2 hours daily practice)
Intermediate level: 1–2 months
Job-ready: 2–3 months of consistent practice

Most beginners can write useful queries within 7–14 days.

Can I learn SQL in 7 days?

Yes, you can learn the fundamentals of SQL in 7 days if you practice daily. In one week you can master SELECT, filtering, sorting, basic JOINs, and aggregate functions. However, becoming comfortable with complex queries takes more practice.

Is SQL more difficult than Python?

No. SQL is generally easier than Python for beginners. SQL has a simpler syntax and focuses only on data querying, while Python is a full programming language with more concepts (variables, loops, functions, OOP, etc.). Many people learn SQL first and then move to Python.

Which is harder, SQL or Excel?

SQL is slightly harder than Excel at the beginning, but it becomes more powerful once you learn it. Excel is visual and easier to start with, while SQL requires writing code. However, SQL is much better for large datasets and is a more valuable skill in data-related jobs.

#SQL #SQLTutorial #LearnSQL #SQLForBeginners #Database #DataAnalytics #SQLQueries #Coding #Programming #DataScience

Top News

SQL Tutorial for Beginners: Complete Guide with Examples (2026)