SQL Programming Lessons
Choose your path and start learning SQL programming step by step.
basics
Introduction to SQL
Learn the basics of SQL and how to interact with databases using queries
Selecting Data
Master the SELECT statement and learn how to retrieve specific data from your database
Filtering and Sorting
Learn how to filter data with WHERE clauses and sort results with ORDER BY
Inserting and Updating Data
Learn how to add new data with INSERT and modify existing data with UPDATE and DELETE
Joins and Relationships
Learn how to combine data from multiple tables using JOIN statements and understand table relationships
String Functions
Master SQL string functions to clean, transform, and extract text data from your database
Null Handling
Understand how NULL works in SQL and use COALESCE, NULLIF, and IS NULL to write queries that handle missing data correctly
Data Types And Casting
Understand SQL data types, implicit and explicit type conversion, and how to safely cast values between types to avoid errors and data loss
intermediate
Aggregation and Grouping
Learn to summarize data with aggregate functions like COUNT, SUM, AVG, and GROUP BY
Subqueries
Learn to write queries within queries using scalar subqueries, correlated subqueries, EXISTS, and IN
Indexes and Performance
Learn how to create indexes, analyze query plans, and optimize database performance
Views and CTEs
Learn to organize complex queries with views, Common Table Expressions, and recursive CTEs
Transactions
Learn how to use transactions to ensure data consistency with BEGIN, COMMIT, ROLLBACK, and SAVEPOINT
Date and Time Functions
Master SQL date and time functions to query, format, and calculate temporal data — from extracting date parts to computing intervals and filtering by time ranges
Set Operations
Combine and compare result sets using UNION, INTERSECT, and EXCEPT to answer questions that span multiple queries
Constraints And Keys
Learn how to enforce data integrity in SQL databases using primary keys, foreign keys, unique constraints, check constraints, and not-null rules
advanced
Triggers and Automation
Learn about triggers, automated actions, and the concepts behind stored procedures in SQLite
Window Functions
Learn to perform advanced calculations with ROW_NUMBER, RANK, PARTITION BY, LAG, LEAD, and running totals
Database Design
Learn database normalization, entity-relationship modeling, primary and foreign keys, and constraints
Migrations
Learn to evolve your database schema safely with ALTER TABLE, data migrations, and backward compatibility
Capstone Project
Design and query a complete e-commerce database combining products, orders, customers, and analytics
Recursive Queries
Learn how to write recursive SQL queries using Common Table Expressions to traverse hierarchical data, generate sequences, and solve problems that require self-referencing logic
JSON in SQL
Learn how to store, query, and manipulate JSON data directly in SQL using JSON functions, path expressions, and table-valued functions to handle semi-structured data without leaving your database
Triggers and Events
Learn how to automate database logic with SQL triggers — special procedures that fire automatically when data changes — to enforce business rules, maintain audit trails, and keep derived data consistent without relying on application code
Query Optimization
Learn how to write faster, more efficient SQL queries by understanding execution plans, index usage, and common performance pitfalls — so your database does less work to return the same results