SQLite: Crash Course
Data types, insert commands, altering tables, advanced queries and sub-queries, joins, functions, views, group-by and having clauses, transactions, triggers, conditions, creating new constraints, using foreign-key constraints, and more.