Course Content and Outcome Guide for CAS 225 Effective Winter 2016
- Course Number:
- CAS 225
- Course Title:
- PHP and MySQL for Designers
- Credit Hours:
- Lecture Hours:
- Lecture/Lab Hours:
- Lab Hours:
- Special Fee:
Course DescriptionDevelops skills for finding, utilizing and modifying PHP and MySQL resources on the Internet. Explores ways to personalize web sites for visitors with a variety of dynamic server-based techniques such as processing forms, displaying text or images from a database, implementing a shopping cart or a discussion board, tracking visitors, and password-protecting a web site. Includes how to install PHP and MySQL. Prerequisites: CAS 213 or instructor permission. Audit available.
Addendum to Course Description
This class is an elective for the CAS Web Site Development Certificate and the CAS Web Site Development and Design AAS Degree.
Intended Outcomes for the course
Upon successful completion students should be able to:
1. Find, utilize and modify PHP and MySQL resources on the Internet.
2. Upload, test, and deploy web pages containing PHP and MySQL.
Outcome Assessment Strategies
- Project(s) incorporating concepts learned in the class
- May include objective tests or scored assignments
Course Content (Themes, Concepts, Issues and Skills)
Server-side programming concepts
Introduction to Apache, PHP and MySQL
Introduction to arrays
Form processing and validation
Error handling and debugging
Cookies and sessions
Handling file uploads
Database security issues
Introduction to MySQL and basic database concepts
Introduction to SQL retrieval queries
Introduction to object-oriented, 3-tier architecture