Databases SQL

UPDATE SELECT INSERT DELETE

Combines rows from multiple tables Creates a table Updates records Deletes rows

Index Unique key Foreign key Primary key

Sorts results Joins tables Groups rows with same values Filters rows

GROUP BY HAVING ORDER BY WHERE