ENTD371 - Database Driven Web Applications Using PHP & MySQL
View Academic Calendar
This course focuses on the roles and functions of relational databases in the management of information; it will be taught from a mixture of analytical and practical methods. This course is a study and application of database architecture, logical schema, the full lifecycle database application development process, and the principles of relational database design in the context of the MySQL Relational Database Management System (RDBMS). Students will examine the rudiments of referential integrity and normalization and use the ANSI standard Structured Query Language (SQL) to design, develop and deploy databases. They will use PHP to interact with the database, to extract data, deploy it on the web, and examine the syntax and constructs of the language, cookies, system functions, user-defined functions, sessions, and database connectivity. The student will also explore the PHP Framework, PHP syntax, cookies, sessions, database connectivity, database-driven web interfaces, and interactions with ODBC compliant relational databases. Students must have access to MySQL 4.1 (or greater) database software. This software is not provided by the course material grant and must be purchased/provided by the student.
Prerequisites
N/A
Corequisites
N/A
Schedule of Classes
| 09/26/11 - 02/26/12 |
03/05/12 - 04/29/12 |
Winter 2012 Session D - 8 Week session |
| 10/31/11 - 03/25/12 |
04/02/12 - 05/27/12 |
Spring 2012 Session B - 8 Week session |
| 11/28/11 - 04/29/12 |
05/07/12 - 07/01/12 |
Spring 2012 Session I - 8 Week session |
| 12/26/11 - 05/27/12 |
06/04/12 - 07/29/12 |
Spring 2012 Session D - 8 Week session |
| 01/30/12 - 06/24/12 |
07/02/12 - 08/26/12 |
Summer 2012 Session B - 8 Week session |
Course Materials
| Book Title: |
Students must have access to required software. APUS does not supply this software.
|
| ISBN: |
Software Note
|
| Publication Info: |
N/A
|
| Author: |
N/A
|
| Unit Cost: |
N/A
|
| |
| Book Title: |
PHP and MySQL for Dynamic Web Sites, 4th ed.
|
| ISBN: |
0321784073
|
| Publication Info: |
Peachpit Press
|
| Author: |
Larry Ullman
|
| Unit Cost: |
$34.50
|
| |
