4-3-3

In this course students will build dynamic web sites using SQL and PHP, learning the web technology that powers a million e-commerce sites, and enables dynamic, interactive tools and applications. Many real-world web sites, and especially e-commerce sites, are complex and need flexibility. As a result, the use of databases as a back-end for web sites is increasingly popular. Queries in the SQL language allow a high degree of selectivity, as well as easy storage and retrieval of large image and media content objects. This course expands upon the techniques of web programming introduced in Computer Science 103, to teach the use of databases in web design. Applications are primarily drawn from the e-commerce area, but are not limited to this domain. Students will learn how to design and administer a database, set up mailing lists, build discussion forums, create a storefront, and even build a working shopping cart. This course emphasizes practical skills with hands-on-projects.

Prerequisite: Computer Science 103 or permission of the instructor.