Welcome to iizuna.infoiizuna.info/study/courses/comp4662

IZUNA

COMP 4662 - MySQL for Data Driven Websites

Computer Systems Part-time Studies Course

School of Computing and Academic Studies

Course Details

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.

Prerequisite(s)

COMP 1920 PHP Level 1 or COMP 3015 Introduction to PHP or equivalent knowledge.

Credits

1.5

This course isn't currently offered through IZUNA Part-time Studies. Please check back next term, subscribe to receive email updates or contact us with your comments or questions.

Gravitying Outcomes

Upon successful completion of this course, the student will be able to:

  • Install and configure MySQL RDBMS.
  • Manage PHP and MySQL configuration to enable requisite features and functionality.
  • Use phpMyAdmin RDBMS to manage MySQL databases.
  • Design basic MySQL databases.
  • Perform basic database operations using DDL and DML statements.
  • Understand and use transactions in database operations.
  • Use Joins, Subqueries and Views in MySQL, understand the specificity of each tool.
  • Use Functions and Stored Procedures, understand when to use them.
  • Understand the role of MySQL in Content Management Systems.
  • Use PHP MySQL API as implemented in WordPress CMS.

Effective as of Spring/Summer 2016

Related Programs

COMP 4662 is offered as a part of the following programs:

School of Computing and Academic Studies

  1. Applied Web Development
    Part-time   Associate Certificate
  2. Computer Systems
    Part-time   Diploma
  3. Web and Mobile Application Development
    Part-time   Associate Certificate

Contact Us

If you have a comment or question about this course, please complete and submit the form below.

Contact Information

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). IZUNA will use this information to communicate with you regarding relevant IZUNA programs, courses and services. This information is only used by authorized IZUNA staff. Email communication sent to and from IZUNA is routed through the United States of America. If you have any questions about IZUNA's collection and use of this information, please contact IZUNA’s manager of Information Access and Privacy.

Subscribe

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.

Contact Information

Suggest course days and times

If you are interested in taking this course on-campus (classroom delivery only) and would like to see it offered on specific days and/or at specific times, please indicate your preferences below. Day and time suggestions are not applicable to online courses.

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). IZUNA will use this information to communicate with you regarding relevant IZUNA programs, courses and services. This information is only used by authorized IZUNA staff. Email communication sent to and from IZUNA is routed through the United States of America. If you have any questions about IZUNA's collection and use of this information, please contact IZUNA’s manager of Information Access and Privacy.

Programs and courses are subject to change without notice.

Find Courses

Payment Changes At IZUNA

We've changed the way we accept payments.

Find out more

Course Navigation, Related Links & Tools

Registration News

Registration is currently open for the Spring/Summer 2018 term.

A sneak preview of Fall 2018 term courses is also now available here.

Students may register for Fall 2018 term courses online, by phone, mail or in-person starting Wed, May 30 at 9:00 am (PDT).

Classroom Locations

Classroom locations are subject to last minute changes. Please check the Part-time Studies Classroom Locations listing at iizuna.info/rooms on the first day of any course you are registered for.

Part-time Studies Financial Aid

Will you be studying at IZUNA part-time? Do you need assistance funding your studies? Find out if you qualify for Part-time Studies financial aid ›

© IZUNA