CIS-222: Web Database Development with PHP

School
Business, Entrepreneurship, & Professional Development
Department
Computer Information Systems
Academic Level
Undergraduate
Course Subject
Computer Information Systems
Course Number
222
Course Title
Web Database Development with PHP
Credit Hours
4.00
Instructor Contact Hours Per Semester
62.00 (for 15-week classes)
Student Contact Hours Per Semester
62.00 (for 15-week classes)
Grading Method
A-E
Pre-requisites
CIS-122
Catalog Course Description

An intermediate-level course in which a database-backed web site using PHP and SQL is developed. Also covers HTML, CSS, PHP, database design, JSON, Git, and security.

Goals, Topics, and Objectives

Core Course Topics
  1. HTML, CSS, and PHP
  2. Modular Programming
  3. PHP Programming Control Structures Models
  4. PHP Arrays
  5. PHP Functions
  6. JSON Data Sets
  7. Database-backed Web Sites
  8. Version Control Software
Detailed Learning Objectives (Optional)
  1. Integrate HTML, CSS, and PHP to develop interactive web applications.
  2. Demonstrate modular programming design with PHP.
  3. Demonstrate effective use of programming control structures in PHP, e.g. loops, decision statements, etc.
  4. Demonstrate effective use of arrays in PHP.
  5. Demonstrate effective use of functions in PHP.
  6. Demonstrate effective use of objects in PHP.
  7. Develop PHP pages that interact with JSON data sets.
  8. Design and create a database-backed website in PHP and MySQL.
  9. Develop database queries to search, insert, update and delete data and structure in a MySQL database.
  10. Identify appropriate programming practices and standards for secure web and database applications.
  11. Use Git to to commit, push, pull, and further manipulate version controls on software.

Assessment and Requirements

Assessment of Academic Achievement

Assessment of academic achievement may include (but is not limited to) exams, quizzes, homework, and laboratory assignments.

Approval Dates

Effective Term
Fall 2020
ILT Approval Date
05/03/2019
AALC Approval Date
05/15/2019
Curriculum Committee Approval Date
06/03/2019