SQL Fundamentals

SELECT, INSERT, UPDATE, DELETE, joins, aggregations, and subqueries.

SQL is the language of relational databases. This chapter covers the core DML statements — SELECT with filtering, sorting, and projection; INSERT, UPDATE, and DELETE — then builds to inner and outer joins, GROUP BY aggregations, and correlated subqueries.