PHP and MySQL Basics

---

Overview
This course will give you an overview of the process of 1) designing a database, 2) building a MySQL database, 3) understanding and creating SQL queries, 4) connecting your database to your web pages with PHP.

Prerequisite
This is an advanced level course, you must be very computer literate - you have a great handle on file management. You must be comfortable with Dreamweaver. This course does not have time reserved for Dreamweaver basics.

Materials for this Course will be provided in class.

Recommended Text: PHP 5 / MySQL Programming for the Absolute Beginner by Andy Harris. Published by Thomson Course Technology; ISBN 13: 978-1-59200-494-2. This book will take you beyond the scope of this course.

Note: the following schedule roughly corresponds to our class sessions. However, based on class discussion and questions, this schedule should be considered flexible.

Lesson	Class Description
1	Introduction to the Process Worksheets
2	Plan your Database from the Human Side
3	Plan your Database from the Computer Side
4	Build your Database on the Web Server
5	Introduction to the SQL Query Language
6	Harder SQL Queries
7	Introduction to PHP and Programming Flow
8	Setting up a Web Page Form and Using PHP and MySQL Together
9	Web Pages Pages with INSERT Queries
10	Web Pages Pages with SELECT Queries