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  
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 Relational Algebra I  
13 Relational Algebra II  
14 SQL Data Definition  
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  
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 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 Project Work Day  
39 Graded Review II  
40 Project Demonstrations Web Application