Home Link
About UsOur PartnersBlogCourse Login
  • For Workers & Job Seekers
  • For Businesses & Employers
  • Courses & Training
Contact Us
Back to all courses

PHP and MySQL Series

Create dynamic, interactive web pages that allow users to post and retrieve information using the PHP programming language and MySQL database server. After learning the basics, you discover how to create an interactive online store with a catalog, shopping cart, and order completion capabilities. You will even gain useful code templates to help you create your own web-based content management system and online store as you complete your coursework!

$199
Instructor-Led48 Course Hours
View Course
Computer Science
PHP and MySQL Series

Description

Introduction to PHP and MySQL

Learn how to create an interactive website, allowing visitors to post and retrieve information provided by you or your site's visitors. In this six-week online course, you'll see how to create dynamic web pages using the PHP programming language and the MySQL database server.

During the course, you'll walk through the development of a complete content management system web application. You'll receive clear, step-by-step, instructions demonstrating how to create a complete website capable of dynamically displaying data from a MySQL database.

You'll discover how you can allow your site's visitors to add new information to an online database, search through posted data, and create meaningful printed reports. By the end of this course, you'll have plenty of useful code templates that will help you create your very own dynamic, web-based, content management system.

Intermediate PHP and MySQL

Learn how to create an interactive online store complete with an online catalog of products, allowing customers to browse the catalog to select items, place them in a shopping cart, and complete an order. In this six-week online course, you'll see how to create a commercial online store using the PHP programming language and the MySQL database server.

We'll walk through the steps for developing a complete online store web application. During the course, you'll see step-by-step how to create all of the software and database objects used in the application. The application consists of two parts, an administrative web application allowing a store manager to post new products, alter product information, and process customer orders, and a customer web application allowing customers to browse the catalog of products, select products for purchase, and check out using a shopping cart. At the end of the course, you'll be able to use these code templates to create your own online store application.

Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

Syllabus

requirements

Prerequisites:

There are no prerequisites to take this course. Prior HTML coding experience is helpful, but not required.

Requirements:

Hardware Requirements:

  • This course can be taken on either a PC or Mac.
  • Mac users will not be able to use the WAMP5 software, and must provide their own PHP and MySQL development environment.

Software Requirements:

  • PC: Windows 8 or later.
  • Mac: macOS 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • Adobe Acrobat Reader.
  • Software must be installed and fully operational before the course begins.
  • During the first lesson in the course, you will be walked through the process of installing WAMP5 software, which provides a full PHP and MySQL development environment. You can download WAMP5 for free.

Other:

  • Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

about the instructor

Richard Blum

Richard Blum has been an IT industry professional for over 20 years, working mainly as a network and systems administrator. During this time, he has worked with Microsoft, Novell, Unix, and Linux servers, and has created websites using a variety of different programming languages. Blum is the author of several programming and systems administration books, including Professional Assembly Language, C# Network Programming, PostgreSQL 8 for Windows, Sendmail for Linux, Postfix, and Network Performance Open Source Toolkit.

Instructor Interaction: The instructor looks forward to interacting with learners in the online moderated discussion area to share their expertise and answer any questions you may have on the course content.

related courses

Home LinkThe REDC is a Division of Yavapai College.Go to yc.edu
Contact Us