PostgreSQL, MySQL & ANSI SQL Standards

SQL Tutorial

Learn Relational Databases, Step by Step.

Welcome to the CodeNivo SQL tutorial series. Whether you are building web apps, preparing for data engineering interviews, or analyzing company datasets, this course takes you from basic SELECT queries to advanced window functions, indexing, normalization, and database optimization.

Total Lessons60 Topics

Curriculum15 Chapters

PrerequisitesNone (Zero)

Access100% Free

Start Lesson 1: What Is SQL? Databases and Real-World Uses

Course Curriculum

60 Structured Lessons

Introduction to SQL

4 lessons

01What Is SQL? Databases and Real-World Uses

02SQL vs MySQL vs PostgreSQL

03Relational Databases, Tables, Rows, and Columns

04Installing SQL and Setting Up Your Environment

Database Fundamentals

4 lessons

05Creating Your First Database

06Understanding Tables and Data Types

07Creating Tables with CREATE TABLE

08Understanding Primary Keys and Foreign Keys

Querying Data with SELECT

4 lessons

09Retrieving Data with SELECT

10Selecting Specific Columns

11Filtering Data with WHERE

12Removing Duplicate Results with DISTINCT

Filtering Data

4 lessons

13Comparison Operators in SQL

14Logical Operators: AND, OR, and NOT

15Pattern Matching with LIKE

16Sorting Results with ORDER BY

Sorting and Limiting Results

4 lessons

17Limiting Results with LIMIT and OFFSET

18Working with NULL Values

19Using IS NULL and IS NOT NULL

20SQL Comments and Query Formatting

Scalar and Aggregate Functions

4 lessons

21Aggregate Functions: COUNT, SUM, AVG, MIN, and MAX

22String Functions

23Numeric Functions

24Date and Time Functions

Grouping Data

4 lessons

25Grouping Rows with GROUP BY

26Filtering Groups with HAVING

27Understanding WHERE vs HAVING

28Combining Aggregates and Grouping

Joining Tables

4 lessons

29Understanding SQL Joins

31LEFT JOIN and RIGHT JOIN

32FULL OUTER JOIN and CROSS JOIN

Subqueries and Set Operations

4 lessons

33Introduction to Subqueries

34Single-Row and Multiple-Row Subqueries

35UNION and UNION ALL

36INTERSECT and EXCEPT

Modifying Data

4 lessons

37Inserting Records with INSERT

38Updating Records with UPDATE

39Deleting Records with DELETE

40Understanding INSERT, UPDATE, and DELETE Safely

Database Design

4 lessons

41Database Relationships: One-to-One, One-to-Many, and Many-to-Many

42Database Normalization

43First, Second, and Third Normal Forms

44Constraints: NOT NULL, UNIQUE, CHECK, and DEFAULT

Advanced SQL Queries

4 lessons

45Common Table Expressions (CTEs)

46Recursive CTEs

47Window Functions

48Ranking with ROW_NUMBER, RANK, and DENSE_RANK

Transactions and Indexes

4 lessons

49Understanding Database Transactions

50COMMIT and ROLLBACK

51ACID Properties

52Indexes and Query Performance

Views, Procedures, and Security

4 lessons

53Creating and Using Views

54Stored Procedures and Functions

55Database Users, Roles, and Permissions

56SQL Injection and Parameterized Queries

Projects and Interview Preparation

4 lessons

57Building a Student Management Database

58Building an E-commerce Database

59Solving Common SQL Interview Problems

60SQL Best Practices and Final Project