dmq-class-pub

Data Modeling and Querying (CS140)

Tentative Schedule

1. Introduction
2. Single relation operations
3. Modeling single relations
4. DDL
5. Grouping and aggregating
6. Modeling 1-M relations
7. Simple joins
8. Modeling M-M relations
9. Advanced joins
10. Nested queries
11. Final exam

References

Basic operations

• PostgreSQL command line cheatsheet
• reframe 1.0.0 : Python Package Index
• SQL LIKE Operator
• SQL SELECT DISTINCT Statement
• SQL LIKE Clause
• SQL Distinct Keyword

Data modeling

• Logical data structures
• ER Diagram Tutorial | Lucidchart
• PostgreSQL - CREATE Table
• PostgreSQL - INSERT Query
• PostgreSQL: Documentation: 9.4: CREATE TABLE

Grouping and aggregation

1-M relationships

Joining two tables

• SQL join a table to itself - w3resource

M-M Relationships

Joining multiple tables