Week 1 

Friday Jan 22

Class Intro – How the Web Works, broad discussion of course goals

Read Chapter One – Complete Review Quiz on Bridges

Week 2

Tuesday Jan 26

Review Survey Data, Take a look at WordPress, create content view resulting data base content. Complete Quiz by end of Day.

Homework: Begin reading Chapter 4

Friday Jan 29

Review Reading from Chapter One. Introduce Database concepts, flat files vs. relational databases.

Homework Build Flights Database.

Finish Chapter 4

Week 3

Tuesday Feb 2 

Begin reading Chapter 7

Friday Feb 5

Start work on Chapter 7 Exercises

Week 4

Tuesday Feb 9 

Friday Feb 12

Complete Chapter 7 Quiz

Week 5

Tuesday Feb 16 

Complete Chapter 7 Exercise question 1-9 due in class.

Friday Feb 19

Study for DB Exam on Queries

Week 6

Feb Feb 23 

Database Exam :  Queries.

Intro to SQL. Begin writing SQL exercise do Ch 8 Quiz

Friday Feb 26

SQL Queries continued.. work on SQL quiz

Week 7

Tuesday March 1 

Complete chapter 8 Quiz. – Due Thursday 11:49 pm

Friday March 4

SQL Exam (postponed) 

Spring break

Week 8

Tuesday March 15

Intro to HTML and begin web form project

sketch out project ideas

Friday March 18

Basic HTML elements H1, h2, div, p, li, ul, etc..

Week 9

Tuesday  March 22 

Study and prep for HTML exam

Friday March 25

Week 10

Tuesday March 28 

 HTML exam

Friday April 1st

Introduce PHP

begin reading chapter 11

Week 11

Tuesday April 5 

Build mySQL DB

Friday April 8

Write code to connect DB

Week 12

Tuesday  April 12  

Adding SQL to PHP

Build DB for project on web sever, show evidence of creation

Friday April 15

Code INSERT and SELECT examples.

Week 13

Tuesday April 19 

Prep for PHP exam, work on HTML portion of project

Friday May 21

PHP exam

Finish HTML portion of project.

Week 14

Tuesday April 26

Metatags and SEO

Friday 19

Google Analytics

Week 15

Tuesday May 3rd

Submit projects