SELECT retrieves rows from tables with FROM and filters with WHERE. Combine tables with JOIN. Aggregate with GROUP BY and sort with ORDER BY. Change data with INSERT, UPDATE, and DELETE. Define structures with CREATE TABLE and constraints like PRIMARY KEY, FOREIGN KEY, and handling NULL. SQL statements end with a semicolon and are case-insensitive for keywords.