Essential Keyboard Shortcuts for Windows & Mac (2025 Guide)

 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

1. Create a table for products with columns: id, name, price, category, stock.
2. Insert 5 sample products.
3. Write a query to find all products priced above 50 in the “Electronics” category.
4. Calculate the average price per category.
5. 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 ...

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:

1. Learn the basics (SELECT, WHERE, ORDER BY)
2. Practice writing queries every day
3. Learn JOINs and aggregate functions
4. Solve real problems with sample databases
5. 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