Schedule & Readings

Books and Materials

There are no required texts for this course. Consider this resource (from the B.C. Open Textbook Collection) for supplemental reading: Database Design – 2nd Edition, by Adrienne Watt and Nelson Eng.

Slideshows: Databasics, SQL
Resources: Login to Postgres, Design a Database

Class Schedule

You should come to class each day having looked over the links listed for that day. Days marked with two asterisks (**) are required attendance days (see Course Policies for more info).

Dates	Monday	Wednesday	Friday
28-30 Aug.	NO CLASS on Monday	Introductions, Data & Information	The Relational Model (Just skim this article!)
2-6 Sept.	NO CLASS on Monday	Dependencies	Normalization**
9-13 Sept.	Normalization Practice, Data Integrity	System Development Lifecycle, Entity Relationship Diagrams**	ERDs cont.
16-20 Sept.	Normalization/ERD Practice	Exam Review Day!	EXAM 1**
23-27 Sept.	PostgreSQL**	Structured Query Language	PROJECT 1 Due, Data Definition Language: INSERT/DELETE
30 Sept.-4 Oct.	DDL: Constraints and Foreign Keys	Data Manipulation Language: Queries**	DDL: ALTER, UPDATE, RETURNING
7-11 Oct.	SQL Practice, Data Backups	Aggregate Functions, GROUP BY**	SQL Practice, Prepare for Project 2
14-18 Oct.	JOIN Part 1**	JOIN Part 2	JOIN Practice
23-25 Oct.	NO CLASS (Fall Break)	Exam Review Day!	EXAM 2**
28 Oct.-1 Nov.	ACID, Transactions	User Interfaces, pgAdmin, User Personas	Project 2 Due, Use Case Diagrams, Designing a Database
4-8 Nov.	SQL Functions, Creating and using PL/pgSQL**	Declaring and Initializing Variables**	Learn new SQL commands on your own!
11-15 Nov.	Trigger Functions**	User Needs Activities	One-on-one meetings
18-22 Nov.	More Functions & Queries	Database Testing**	Practice and Work on Final Project
25 Nov.	Work on Final Projects	NO CLASS on Wednesday	NO CLASS on Friday
2-6 Dec.	Peer review and Test Final Projects	Final Project Work	One-on-one meetings
9 Dec.	Final Project Due! Final Exam Review Day!**
16 Dec.	FINAL EXAM: 9am-Noon.