| Date |
Topics |
Assigned Readings and Participation Activities |
Lecture Slides |
Homework |
| 1/21 |
Course Overview and Introduction to Databases |
Chapter 15.1-15.5 |
- Logistics Slides
- Database Terminology
- Lecture (start from 8:40)
|
--- |
| 1/26 |
The Relational Model |
Chapter 16.1-16.5 |
|
--- |
| 1/28, 2/2 |
SQL: Data Manipulation |
- 1/28: Chapter 15.5, Chapter 18.1-18.4, 18.8-18.9
- 2/2: Chapter 16.6, 18.6, 18.11
- w3schools SQL Tutorial. Read all the SQL Basic, play with the SQL demo, and read the following
topics in the advanced section:
- SQL Order By
- SQL and & or
- SQL In
- SQL Between
- SQL Join
- SQL Create
- My SQL Notes
- Getting Started with Your MySql Database
|
|
|
| 2/4 |
SQL: Data Definition |
Chapter 16.7, 18.5-18.7, 18.10 |
1) DDL Slides
2) Subquery Slides
3) Lecture 2/4 (starting at 1:45)
4) Lecture 2/9 (start at 1:30)
|
--- |
| 2/9 |
Relational Algebra and Calculus |
Handout on Canvas (Only read about the relational algebra and tuple relational
calculus. Ignore the domain relational calculus and other languages) |
1) Slides
2) Lecture 2/9 (lecture starts at 1:30 and relational algebra start at 29:30)
3) Lecture 2/11 (lecture starts at 13:00)
|
- hw2 (Due Sat. 2/13 at 6am)
- hw2 supplementary materials-The DreamHome.sql file will create the relations for the Dream Home property man
agement firm and can be used with question 8.
|
| 2/16, 2/18 |
Entity-Relationship Modeling |
- Chapter 17.1-17.8
- Investment Firm Design Case
1) Slides
2) Lecture 2/16 (start at 3:15)
3) Lecture 2/18 (start at 2:30)
4) Investment Firm Solution
|
hw3 (Due Wed. 2/24 at 6am) |
|
| 2/23, 2/25 |
Normalization |
- Chapter 17.9-17.10 and canvas handout
- Hotel Case Study
- Hotel Case Study Answers
|
1) Slides
2) Lecture 2/23 (start at 2:00)
3) Lecture 2/25 (start at 0:25)
|
hw4 (Due Wed. 3/3 at 6am) |
| 3/2, 3/4 |
Physical Database Design |
- 3/2: Ch. 19.1-19.5. 19.7, physical design, and B+-tree handout on Canvas. For B+-tree handout go to Modules
and then Course Materials.
- 3/4: Extendible Hashing handouts on Canvas. Go to Modules and then
Course Materials.
- B+-Tree Visualization
|
Lecture 3/2 (start at 2:30)
Lecture 3/4 (start at 0:25)
Lecture 3/9 (start at 36:30)
|
1) hw5 (Due Wed 3/10 at 6am)
2) Database Project for CS565 Students (Due Wed. 3/31 at 6am)
|
| 3/9, 3/11 |
NoSQL and MongoDB |
- 3/9: Ch 7.8, 24.1-24.5
- 3/11: 24.7
- General NoSQL notes
- My Mongo DB notes
- Kathleen Durant's Mongo DB slides (look at slides 16-42)
|
- Lecture 3/9 (start at 1:30)
- Lecture 3/11 start at 41:00)
|
hw6 (Due Wed. 3/17 at 6am--No late submissins accepted) |
| 3/16 |
Introduction to Web Programming and Scripting Languages |
- Chapters 1 and 2.1-2.5
- Lecture (start at 56:45)
|
- Pre-class: All participation activities in Chapter 1 and 2.1-2.5
- In-class: All challenge activities in 2.4-2.5
|
1) Web project description
2) Video showing web interface interactions
3) Video describing ABET data collection and database relations
4) Web Project 1--Database design (Due Fri. 3/26 at 6am)
|
| 3/18 |
Midterm Exam |
| 3/23 |
HTML and Forms |
Chapter 2.6-2.8 and Chapter 3
Lecture 3/23 |
- Pre-class: All participation activities in Chapter 2.6-2.8 and Chapter 3
- In-class: All challenge activities in 2.6-2.7 and Chapter 3
|
--- |
| 3/25 |
Basic CSS |
Ch. 4
Lecture 3/25 |
- Pre-class: All participation activities in Chapter 4
- In-class: All challenge activities in Chapter 4
|
--- |
| 3/30 |
Advanced CSS and PhP Introduction |
Ch 5 and 12.1-12.2
Lecture 3/30 |
|
Web Project 2 -- user interface (Due Wed. Apr. 7 at 6am) |
| 4/1 |
PHP Basics |
- Ch. 12.3-12.10
- Supplementary Reading: PHP Tutorial-Read the
PHP Basics section through PHP functions
- Supplementary Reading: Introduction to PHP
- Supplementary Reading: Getting Started in PHP
- Brad's Cliff Notes Version of PHP
- Supplementary Reading: Geoff Mazeroff's Cliff Notes Version of PHP
|
- Pre-class: All participation activities in Chapter 12.3-12.10
- In/After class: Canvas quiz--4-1: PHP Basics
- Lecture 4/1
|
wordcount
prose.txt |
|
| 4/6 |
Handling Forms and Session Management in PHP |
- Ch 12.11, 13.4
- Supplementary Reading: Handling Forms
- Supplementary Reading: PHP Tutorial
- Read the PHP Basics section from PHP Forms to the end
- PHP Cookies
- PHP Sessions
|
- Pre-class: All participation activities in Chapter 12.11, 13.4
- In/After class: Canvas quiz--4-6: PHP Form Handling
- Lecture 4/6
|
--- |
| 4/8 |
PHP interface to mySQL and Regular Expressions |
- Ch. 13.1, 13.3, 13.6-13.8
- Supplementary Reading: PHP SQL-Read
the PHP MySQL Database section
- Supplementary Reading: my PHP SQL notes
|
- Pre-class: All participation activities in Chapter 13.1, 13.3, 13.6-13.8
- In/After class: Canvas quiz-3-31: PHP SQL and Regular Expressions
- Lecture 4/8
|
Web Project 3 -- server side (Due Fri. Apr. 16 at 6am)
Web Project 1 & 2 Explanation |
| 4/13 |
Introduction to JavaScript |
Ch. 6--Basic Javascript
|
- Pre-class: All participation activities in Ch. 6
- After-class: All challenge activities in Ch. 6
- Lecture 4/13
|
--- |
| 4/15 |
Javascript classes, regular expressions and Javascript in the Browser--HTML DOM, Javascript DOM |
- Javascript regular expressions and classes: Ch. 8.1-8.3
- The Document Object Model: Ch. 7.1-7.3, 7.6
- Supplementary Reading: Javascript DOM
|
- Pre-class: All participation activities in Ch. 8.1-8.3, 7.1-7.3, 7.6
- After-class: All challenge activities in Ch. 8.1-8.3, 7.1-7.3, 7.6
- Lecture
|
Web Project 4--Tying Together the Client and Server Sides (Due Thurs. 4/29 at 6am) and its grading guide.
|
| 4/20 |
Javascript: Interaction with the Browser and the Server--Forms, Events, and AJAX |
|
- Pre-class: All participation activities in Ch. 7.4-7.5, 7.7, 7.9, 8.7
- After-class: All challenge activities in Ch. 7.4-7.5, 7.7, 7.9, 8.7
|
--- |
| 4/22 |
JQuery |
|
- Pre-class: All participation activities in 9.1-9.
- After-class: All challenge activities in 9.1-9.6
|
td>---
| 4/27 |
Node.js and Express |
- Ch 11.1-11.9
- Supplementary Reading (highly recommended because the book is
a bit terse): w3schools.com--go to node.js
|
|
--- |
