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. Quizzes are indicated by an asterisk (*) beside the title of the lesson.

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

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