This schedule provides an overview of the lessons and assignments throughout the semester although this schedule is subject to change. Readings are not listed in this overview; please view the lesson notes for the reading assignment.

Unless otherwise noted, readings and assignments are to be completed prior to class.

  Date Lesson Assignment(s)
    Course Overview  
1 8 Jan Introduction  
2 10 Jan ER Modeling I  
3 14 Jan ER Modeling II  
4 16 Jan ER Modeling III Introductions
5 18 Jan File Storage and Retrieval  
6 23 Jan Database Systems  
7 25 Jan Relational Data Model  
8 29 Jan Normal Forms I PEX: Microsoft Access
9 31 Jan Normal Forms II  
10 4 Feb PostgreSQL and pgAdmin Project: Proposal
11 6 Feb Graded Review I  
12 8 Feb SQL Data Definition  
13 12 Feb Relational Algebra I  
14 14 Feb Relational Algebra II  
15 19 Feb SQL SELECT Project: ER Diagram
16 21 Feb SQL Aggregates  
17 26 Feb SQL JOIN  
18 28 Feb SQL Subqueries Project: Schema Design
19 4 Mar SQL Set Operators  
20 6 Mar Database Connectivity PEX: SQL
21 11 Mar XML  
22 13 Mar HTML and CSS  
23 15 Mar JavaScript  
24 19 Mar AJAX  
25 21 Mar SQL Assessment  
    Spring Break  
26 1 Apr Introduction to PHP  
27 3 Apr PHP Database Programming  
28 5 Apr Sessions  
29 9 Apr REST and JSON  
30 11 Apr SQL Injection and XSS PEX: Web Development
31 15 Apr Indexing and B+ trees  
32 17 Apr ACID Properties  
33 19 Apr Transactions and Concurrency  
34 23 Apr Distributed DBs Project: Website
35 25 Apr Performance and Optimization  
36 29 Apr Big Data and NoSQL  
37 1 May Privacy Protection  
38 3 May Graded Review II  
39 7 May Project Work Day  
40 9 May Project Demos Project: Web Application

In the event of changes to the schedule (e.g., the Academy modifying M- and T-days), the lesson number takes priority. More specifically, an assignment’s due date is tied to the date of the lesson rather than the date listed on this schedule if for any reason they are not consistent.