Home IT Courses IT Programming Professional Certificate in PHP & MySQL
Professional Certificate in PHP & MySQL Print E-mail

Professional Certificate in PHP & MySQL

 

 

Course overview

 

This course is designed so that participants will effectively learn how to use both MySQL and PHP and create web applications using MySQL and PHP. Through a hands-on approach, this course will help you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.

 

 

 

 

Who should attend:

 
  • Developers who use PHP and MySQL to build and maintain their websites
  • Developers who want to learn how PHP and MySQL can be used for the rapid prototyping and deployment of dynamic websites
 

Prerequisites

 

Participants should have some HTML experience and experience with some other programming language. We will be using Windows as our Operating System.

 

 

 

 

 

This course will cover the following topics:

 
  • Programming with PHP 5
  • Design schemas based on MySQL
  • Use include files to make code easier to maintain
  • Authenticate users in a secure way against a database
  • Handle errors in your PHP applications efficiently and gracefully
  • Writes composite queries using JOINs and subqueries
  • Use indexing efficiently in order to manipulate large amounts of data efficiently
  • Uses joins to extract data from multiple tables
  • Uses GROUP BY clauses and aggregate functions
  • Write applications whose components can be scaled to meet increased demand
  • Build a complete application that includes authentication and session management
  • Understand how PHP, MySQL and the Apache web server work together to deliver dynamic web content