SQL Programming

A lightweight execution-visualization book.

Tables and Select

Aggregates

Joins

Data Changes

Subqueries and CTEs

Constraints and Indexes

Window Functions

Views and Derived Tables

Transactions and Isolation Concepts

Text and Date Queries

Nulls and Three-Valued Logic

Schema Design Basics

Normalization by Example

Reporting Queries

Analytical Query Patterns

Recursive CTEs

Query Tuning Patterns

Practical SQLite Workflows

Advanced Joins and Sets

Time-Series Queries

Data Cleaning Patterns

Import and Export Concepts

Recursive Patterns in Practice

Performance Diagnostics

Application Query Patterns

Reporting Windows

Schema Evolution

Audit and History Tables

Search and Ranking

Analytical CTE Pipelines

Data Quality Checks

Pragmatic SQLite Administration

Capstone Workflows

Review and Practice

Application Workflow Reports

Operational Reliability Reports

Operational Remediation Reports