1. SQL

A general overview of PostgreSQL-flavored SQL.

Note

DATA 101 uses Postgres, but nearly all of the SQL should follow the SQL Standard. However, when trying to write a specific query, we recommend consulting the documentation for the specific database system you are using.

Throughout these notes we will be linking to the current Postgres documentation. We encourage you to check the docs which are well-written and comprehensive.

• 1.1. SQL Review
• 1.2. String Manipulation
• 1.3. Truncating Relations
• 1.4. Creating Tables and Views from Data
• 1.5. Common Table Expressions (CTE)
• 1.6. Subqueries
• 1.7. DML—Data Manipulation Langauge
• 1.8. DDL–Data Definition Language
• 1.9. Keys & Constraints