In the following list:

• “PiA” refers to the PostGIS in Action, 2e by Obe & Hsu
• “SDS” refers to Spatial Database Systems by Yeung & Hall
• “PG” refers to the PostgreSQL 9.3.13 Documentation
• “Boundless” refers to the Introduction to PostGIS Workshop

Week 1 (Aug 31) – Introduction and Basic Queries

• Reading:
  • SDS 1
  • PG 7.3: Select Lists
• Exercise 1: SQL SELECT Statements

Week 2 (Sept 7) – Table Joins and Entity-Relationship Diagrams

• Reading:
  • SDS 2
  • PiA Appendix C.2 (p. 495)
  • PG 7.2: Table Expressions
• Exercise 2: SQL Joins

Week 3 (Sept 14) – Data Modification Language (DML) and Keys

• Reading:
  • PiA Appendix C.3 (p. 511)
  • PG 6: Data Manipulation
• Exercise 3: Basic ERD with Vertabelo

Week 4 (Sept 21) – Normalization and Data Definition Language (DDL)

• Reading:
  • SDS 3
  • PG 5.1: Table Basics; 5.2 Default Values; 5.3 Constraints
  • http://www.1keydata.com/database-normalization/ – Follow links to 1st, 2nd, and 3rd Normal Form
• Exercise 4: Database Normalization

Week 5 (Sept 28) – Spatial Data Types

• Reading:
  • SDS 4
  • PiA 2
• Exercise 5: Boundless 1-10
  • This exercise will not be turned in or evaluated.

Week 6 (Oct 5) – Spatial Relationships

• Reading: PiA 9.1-9.2
• Exercise 6: Boundless 11-14

Week 7 (Oct 12) – Spatial Reference Systems

• Reading: PiA 3
• Exercise 7: Boundless 16-18

Week 8 (Oct 19) – Data Loading

• PiA 2

Week 9 (Oct 26) – More Spatial Relationships

• Reading: PiA 9.3-9.4, 10
• Exercise 8: Boundless 19-22, 24

Week 10 (Nov 2) – Proximity Analysis

• Reading: PiA 10
• Exercise 9: Boundless 27

Week 11 (Nov 9) – Indexing and Query Optimizations

• Reading: PiA 14-15
• Exercise 10: 15, 25

Week 12 (Nov 16) – Advanced Design Considerations

• Versioning, Spatiotemporal Data, Hierarchical Data, Key-Value Stores
• Boundless 28
• GeoGig?

TEMPLE FALL BREAK NOV 21-25 – NO CLASS

Week 13 (Nov 30) – PostGIS Procedural Languages or TBD

• Reading: PiA 16
• Exercise: TBD

Week 14 (Dec 7) – STUDENT PRESENTATIONS