Fun with Learning Technology

Learn Courses Questions Tracks Tools News Explore Practice

Fun with Learning Technology

A new problem, explained clearly, every day.

Learn

Lessons
Topics
News
Tools
Courses
Career tracks
Everything

Site

About
Contact
Support
Privacy
Terms

Get the daily one

One email per new problem. No spam.

Request a tutorial

Requests shape what gets made next.

© 2026 Fun with Learning TechnologyRSS

SQL — Free Course — Fun with Learning Technology

Home›Courses›SQL

🗄️

SQL

SQL for data querying, analysis, and database design

32 topics7 sections32 lessons ready

01

Basics

6

SQL Overview — Databases and Tables
SELECT, FROM, WHERE — Core Querying
Filtering — AND, OR, NOT, IN, BETWEEN, LIKE
Sorting with ORDER BY
Limiting Results — LIMIT and OFFSET
NULL Values and IS NULL

02

Aggregation

4

Aggregation Functions — COUNT, SUM, AVG, MIN, MAX
GROUP BY and HAVING
DISTINCT — Removing Duplicates
CASE WHEN — Conditional Logic

03

Joins

4

INNER JOIN
LEFT, RIGHT, and FULL OUTER JOIN
CROSS JOIN and SELF JOIN
Joining Multiple Tables

04

Advanced Queries

5

Subqueries — Scalar, Row, Table
CTEs — Common Table Expressions (WITH)
Window Functions — ROW_NUMBER, RANK, DENSE_RANK
LAG, LEAD, FIRST_VALUE, LAST_VALUE
PARTITION BY with Window Functions

05

DDL and DML

4

CREATE TABLE and Data Types
INSERT, UPDATE, DELETE
ALTER TABLE and DROP
Constraints — PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL

06

Database Design

5

Normalization — 1NF, 2NF, 3NF
Indexes and Query Performance
Views and Materialized Views
Stored Procedures and Functions
Transactions and ACID Properties

07

Interview Prep

4

SQL Interview Questions — Basics
SQL Interview Questions — Advanced
SQL Coding Challenges — Top-N, Gaps, Deduplication
NoSQL vs SQL — Key Differences

Start learning SQL

Free to read. Sign in to save progress, take quizzes and keep notes.

Open the course