Schedule in Detail

Dates below are for Fall 2023 semester.

In the following list:

• “PiA” refers to the PostGIS in Action, 3e by Obe & Hsu.
• “RDDI” refers to Relational Database Design and Implementation, 4e by Harrington.
• “PG” refers to the PostgreSQL Documentation. Note that this links to the documentation for the currently released version of PostgreSQL; if the documentation changes in a way that breaks the link, please notify the professor so that it can be updated.

• “Workshop” refers to the Introduction to PostGIS Workshop. The files for this workshop are also available as a download in Canvas. Note that the PostGIS Workshop is listed under “Reading” because the exercises include answers, and are not turned in for a grade; you should do the exercises and check your own answers.

• Week 1 (8/28 - 9/1)
  • Reading
    • RDDI 1, 4, 10, 16
    • Database Terminology
    • PG 7.3: Select Lists
    • Data Modeling: Conceptual vs Logical vs Physical Data Model
  • Thurs
    • Meeting: Introduction and Basic Queries
• Week 2 (9/4-9/8)
  • Reading
    • RDDI 7 (only “First Normal Form”), 18 (only “Performing Arithmetic”, “String Manipulation”, “Date and Time Manipulation”)
    • PiA 2, 3, 4, 6
    • Workshop 9-10, 16-19
  • Thurs
    • Meeting: SQL Functions and Spatial Data
  • Fri
    • Due Date: DataCamp - Intermediate SQL Queries, Chapters 1 & 2
• Week 3 (9/11 - 9/15)
  • Reading
    • RDDI 7 (only “Second Normal Form”), 19
  • Thurs
    • Meeting: Aggregate Queries
    • Due Date: Milestone 1 (evaluated in class)
• Week 4 (9/18 - 9/22)
  • Reading
    • RDDI 7 (only “Third Normal Form”), 17
    • PG 7.2: Table Expressions
    • Workshop 13-14
  • Thurs
    • Meeting: Table Joins
  • Fri
    • Due Date: DataCamp - Intermediate SQL Queries, Chapters 3 & 4
• Week 5 (9/25 - 9/29)
  • Reading
    • RDDI 5, 20
    • PG 6, all sections: Data Manipulation
  • Thurs
    • Meeting: Data Modification Language (DML) and Keys
    • Due Date: Database Design Assignment 0 (discussed in class)
  • Fri
    • Due Date: DataCamp - Joining Data in PostgreSQL
• Week 6 (10/2 - 10/6)
  • Reading
    • RDDI 7 (review), 11
    • PG 5.1-4: Data Definition only sections on “Table Basics”, “Default Values”, “Generated Columns”, and “Constraints”
    • PiA 14
  • Thurs
    • Meeting: Data Definition Language (DDL) and Database Normalization
    • Due Date: Database Design Assignment 1
• Week 7 (10/9 - 10/13)
  • Reading
    • PiA 8
    • Workshop 11-12, 22
  • Thurs
    • Meeting: Spatial Relationships
    • Database Design Assignment 1 discussed in class
    • Due Date: Database Design Assignment 2
• Week 8 (10/16 - 10/20)
  • Reading
    • PiA 9
    • Workshop 29
  • Thurs
    • Meeting: Proximity Analysis
    • Database Design Assignment 2 discussed in class
• Week 9 (10/23 - 10/27)
  • Reading
    • RDDI 8
    • PiA 14, 15
    • Workshop 15, 27, 33
  • Thurs
    • Meeting: Storage Strategies and Performance Tuning
    • Due Date: Milestone 2 (evaluated in class)
    • Due Date: Database Design Assignment 3
• Week 10 (10/31 - 11/3)
  • Thurs
    • Meeting: Student-Led Tutorials
    • Database Design Assignment 3 discussed in class
• Week 11 (11/6 - 11/10)
  • Thurs
    • Meeting: Student-Led Tutorials
    • Due Date: Milestone 3 (evaluated in class)
• Week 12 (11/13 - 11/17)
  • Thurs
    • Meeting: Student-Led Tutorials
    • Due Date: Milestone 4 (evaluated in class)
• FALL BREAK (11/20 - 11/24)
• Week 13 (11/27 - 12/1)
  • Thurs
    • Meeting: Student-Led Tutorials
• Week 14 (12/4 - 12/8)
  • Thurs
    • Meeting: Student-Led Tutorials
• Finals Period
  • Scheduled Examination Time (12/14)
    • Due Date: Milestone 5 (Final Report)