Building Queries to Model Data
Goals
- Write queries on tables.
- Transpose and append data.
- Update, insert, and delete data.
Write Queries on Data
- Data Manipulation Language (DML)
- Querying Data
- SELECT
- joins
- Types of Joins
- The Impact of Each Join
- WHERE Clause
- Grouping and Aggregating Data
- WHERE
- GROUP BY