A Gentle Introduction to SQL Using SQLite

"Structured Query Language"
A declarative language used to query and manage data in a relational database management system.
Relational Model
Data joined between relations
(table rows linked by shared data)
Declarative Language
(Pay no attention to that man!)
Keyword Driven
(a few verbs, a few modifiers)
Main Verbs for
Working with Data

SELECT
INSERT
UPDATE
DELETE
Main Verbs for Managing
Database Structure

CREATE (TABLE)
DROP (TABLE)
ALTER (TABLE)
https://github.com/tthibo/
Troy Thibodeaux
Associated Press
tthibodeaux@ap.org
@tthibo
Modifying Keywords
(examples)

FROM
WHERE
GROUP BY
ORDER BY