This hands-on course follows on from COMP 3015 – Introduction to PHP. Students focus 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.
COMP 3015 Introduction to PHP or equivalent knowledge.