This hands-on course follows on from COMP 1920 or COMP 3015 – Introduction to PHP and focuses on using MySQL and phpMyAdmin as the relational database management system (RDBMS) with PHP as the web scripting language. Students with a prior knowledge of PHP will learn to design and manage MySQL databases, as well as perform requisite database related operations using SQL queries and PHP MySQL API. Fundamental concepts, such as transactional operations and SQL-related programmability are covered as well as using MySQL as the data layer for PHP-based Content Management Systems (CMS). This course offers an introduction to the use of MySQL for custom WordPress applications and plugins. Labs and exercises allow to effectively use the MySQL in PHP applications and to select appropriate approach to resolve practical data usage. Upon successful completion students will be able to use PHP with MySQL to develop data driven web applications to industry standards, and solve practical data usage problems. Upon successful completion students will be able to use PHP with MySQL to develop data driven web applications to industry standards. Note: COMP 4662 is a prerequisite for COMP 4669 Advanced Web Applications with PHP.
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 4662 - MySQL for Data Driven Websites?
If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.