3: SQL Techniques
Intermediate PostgreSQL techniques.
Videos
- Tools and Techniques
- Altering Table Schema
- Dates
- DISTINCT / GROUP BY
- Sub-Queries
- Concurrency
- Stored Procedures
- Reading and Parsing Files
- Demonstration: Creating and Loading a Database
- Demonstration: SELECT DISTINCT
- Demonstration: GROUP BY
- Demonstration: Sub Query
- Demonstration: Transactions
- Demonstration: Stored Procedures
- Demonstration: Loading and Normalizing CSV Data
References
- Discussions:
- SQL Techniques (Login Required)
- SQL Techniques (Login Required)
- Quiz: SQL Techniques (Login Required)
- Autograder: Musical Tracks Many-to-One (Login Required)
- Autograder: Unesco Heritage Sites Many-to-One (Login Required)
- Autograder: Musical Track Database plus Artists (Login Required)