Course Organization: Welcome
Course Organization: Syllabus
Course Organization: Schedule
Course Organization: Readings
Course Organization: Assignments
Course Organization: Final Project
Course Organization: Course Website

Web Intro: Networking Overview
Web Intro: Web Server
Web Intro: HTML, PHP, MySQL
Web Intro: Integration
Web Intro: Final Project / Samples

Database Overview
Relational Databases
MySQL: Installing MySQL
MySQL: Command line
MySQL: GUI Tools
MySQL: Introduction
MySQL: SELECT Statement
MySQL: WHERE Clause
MySQL: AND & OR
MySQL: IN
MySQL: ORDER BY Clause

MySQL: CREATE DB, Table, and Index
MySQL: TRUNCATE Database, Table
MySQL: DROP Index, Table and Database
MySQL: ALTER Table
MySQL: INSERT INTO Statement
MySQL: UPDATE/SET Statement
MySQL: DELETE Statement
MySQL: Joining and Keys (Inner Join)
MySQL: LEFT JOIN/ON (Outer Join)
MySQL: GROUP BY & HAVING
MySQL: FUNCTIONS

Database Design Process
MySQL Installation
MySQL Workbench
MySQL Administration
MySQL Migration

Web Server Overview
HTML Editor, FTP Client
HTML: Introduction
HTML: Elements
HTML: 4.0 Specs
HTML: Head
HTML: Meta
HTML: Document Type Definition
HTML: Basic Tags
HTML: Formatting
HTML: Entities
HTML: Links (URLs)
HTML: Fonts
HTML: Colors
HTML: Background

HTML: Images
HTML: Lists
HTML: Tables
HTML: Blocks Elements

HTML: Styles (CSS)
HTML: Scripts (JS) / AJAX
HTML: Forms (Get/Post)

XML: Introduction
XML: XSL, XSLT, XSL-FO
XML: XPath, XQuery
XML: XLink/XPointer
XML: DTD, Schema (XSD)
XML: XML DOM
XML: XForms
XML: SOAP, WSDL, RDF, RSS, WAP

PHP: Intro
PHP: Syntax
PHP: ECHO
PHP: Comment
PHP: Variables: String, Number, Array

PHP: String Manipulations
- Formatting
- Join & Split
- Comparison
- Match & Replace

PHP: Array Manipulations
- Sorting
- Reordering
- Count
- Miscellaneous

PHP: Conditions
PHP: Loops
PHP: Functions

PHP: Cookies / Sessions
PHP: SSI
PHP: Forms
PHP: MySQL Integration

Final Project Discussion – Problem Solving

Final Project – Presentation