SQL Notes for Professionals

An open source guide for beginners. You learn to create tables, insert and update data, filter with WHERE, sort and group results, join tables, and back up a MySQL database.

Bobby Iliev

A vendor-neutral course on standard SQL. It starts with the relational model and moves through CREATE TABLE, data types, SELECT, joins, grouping, NULL handling, transactions, and views.

Wikibooks

More than 280 pages of T-SQL tips. Topics include data types, common table expressions, window functions, JSON and XML handling, indexes, stored procedures, triggers, and backup and restore.

GoalKicker

A hands-on reference for SQL in Oracle. It covers joins, hierarchical queries, string and date functions, sequences, partitioning, indexes, and the basics of PL/SQL.

GoalKicker