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.

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