Chapter 1 of ?
Syllabus Overview •
Sanjay
Written by Sanjay

SQL Tutorial for Beginners — Course Syllabus

Comprehensive beginner-friendly SQL tutorial series. Master relational databases from core SELECT queries, filtering, and data modification to multi-table joins, window functions, and real-world database analysis.

Course Syllabus (82 Chapters)

1

SQL Home, Syllabus & Study Plan

Start →
2

SQL Intro & RDBMS Architecture

Start →
3

SQL Editor & Sample Database Setup

Start →
4

SQL Syntax, Semicolons & Comments

Start →
5

SQL SELECT Statement

Start →
6

SQL SELECT DISTINCT

Start →
7

SQL WHERE Clause

Start →
8

SQL ORDER BY (ASC / DESC)

Start →
9

SQL AND, OR & NOT Operators

Start →
10

SQL Comparison & Arithmetic Operators

Start →
11

SQL String Functions

Start →
12

SQL Numeric Functions

Start →
13

SQL SELECT TOP, LIMIT & FETCH

Start →
14

SQL LIKE & Pattern Wildcards

Start →
15

SQL IN & BETWEEN Operators

Start →
16

SQL Aliases (AS) for Columns & Tables

Start →
17

SQL NULL Values (IS NULL / IS NOT NULL)

Start →
18

SQL INSERT INTO Statement

Start →
19

SQL UPDATE Statement

Start →
20

SQL DELETE vs TRUNCATE vs DROP

Start →
21

SQL MERGE & UPSERT

Start →
22

SQL Aggregate Functions & COUNT()

Start →
23

SQL MIN() & MAX()

Start →
24

SQL SUM() & AVG()

Start →
25

SQL GROUP BY Statement

Start →
26

SQL HAVING Clause

Start →
27

SQL Joins & INNER JOIN

Start →
28

SQL LEFT JOIN

Start →
29

SQL RIGHT JOIN

Start →
30

SQL FULL OUTER JOIN

Start →
31

SQL SELF JOIN & CROSS JOIN

Start →
32

SQL UNION & UNION ALL

Start →
33

SQL Subqueries

Start →
34

SQL EXISTS, ANY & ALL

Start →
35

SQL CASE Statement

Start →
36

SQL NULL Functions (COALESCE, IFNULL, NVL)

Start →
37

SQL CAST & CONVERT

Start →
38

SQL SELECT INTO & INSERT INTO SELECT

Start →
39

SQL CTEs (Common Table Expressions) & Recursion

Start →
40

SQL Window Functions I (ROW_NUMBER, RANK, DENSE_RANK)

Start →
41

SQL Window Functions II (LAG, LEAD, Running Totals)

Start →
42

SQL Pivot & Conditional Aggregation

Start →
43

SQL JSON Functions & Array Querying

Start →
44

SQL CREATE & DROP DATABASE

Start →
45

SQL Database Backups & Restore

Start →
46

SQL Data Types Deep Dive

Start →
47

SQL CREATE TABLE & DROP TABLE

Start →
48

SQL ALTER TABLE

Start →
49

SQL Constraints & NOT NULL

Start →
50

SQL UNIQUE & PRIMARY KEY

Start →
51

SQL FOREIGN KEY & Referential Integrity

Start →
52

SQL CHECK & DEFAULT Constraints

Start →
53

SQL CREATE INDEX (Performance Optimization)

Start →
54

SQL Query Optimization & EXPLAIN Plans

Start →
55

SQL AUTO INCREMENT & Sequences

Start →
56

SQL Database Design & Normalization (1NF, 2NF, 3NF)

Start →
57

SQL Dates & Time-Series Operations

Start →
58

SQL Views & Materialized Views

Start →
59

SQL Stored Procedures & Parameters

Start →
60

SQL User-Defined Functions (UDFs)

Start →
61

SQL Triggers (Audit Logs & Validation)

Start →
62

SQL Transactions (ACID, COMMIT, ROLLBACK)

Start →
63

SQL Users, GRANT & REVOKE Permissions

Start →
64

SQL Injection Attacks & Prevention

Start →
65

SQL Parameters & Prepared Statements

Start →
66

SQL Database Hosting & Cloud Deployment

Start →
67

SQL Keywords Alphabetical Reference

Start →
68

MySQL Built-In Functions Reference

Start →
69

SQL Server (T-SQL) Functions Reference

Start →
70

MS Access Functions Reference

Start →
71

PostgreSQL Functions & Operators Reference

Start →
72

SQL Quick Reference & Cheat Sheet

Start →
73

Data Cleaning with SQL

Start →
74

Time-Series Analysis & MoM Growth

Start →
75

Cohort & Customer Retention Analysis

Start →
76

Funnel Conversion & Drop-Off Analysis

Start →
77

RFM Customer Segmentation with NTILE

Start →
78

SQL with Python (Pandas & SQLAlchemy)

Start →
79

SQL with BI Tools (Power BI & Tableau)

Start →
80

Project 1: E-commerce Sales Performance

Start →
81

Project 2: HR Workforce & Attrition Analytics

Start →
82

100+ SQL Interview Questions & Solutions

Start →
Sanjay
Tutorial Author
Sanjay · Full-Stack Developer & AI Enthusiast
Pursuing MCA at Manipal University Jaipur. Founder of AICodeLab.
Next Up
—

Learner Reviews

Write a Review
Share your experience to help other learners.
Your Rating *
★ ★ ★ ★ ★