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 Introduction  
2 ER Modeling I  
3 ER Modeling II Introductions
4 ER Modeling III *  
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  
21 XML  
22 HTML, CSS, and JavaScript  
23 Space Camp and Supra Coders SQL
24 SQL Assessment  
25 AJAX *  
26 Introduction to PHP  
27 PHP Database Programming  
28 Sessions  
29 REST and JSON Web Development
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 Graded Review II  
39 Project Work Day  
40 Project Demonstrations Web Application