Audience
This course is intended for software programmers with a need to understand the PHP and MySQL programming language starting from scratch. It will give you enough understanding on PHP programming language from where you can take yourself to higher level of expertise.
Prerequisites
Before attending this course, students must have:
• A basic understanding of any of the programming languages
• Basic computer skills and knowledge of HTML fundamentals
Skills Gained
After completing this course, you should be able to carry of these activities:
- Creating and modifying PHP pages
- Working with variables and data types
- Using if/elseif/else statements to control processing conditionally
- Creating programs that include for, while, and do loops to process statements repeatedly
- Employing the break, continue, and exit statements to modify default loop behaviors
- Using and writing functions, including many new PHP 7 features such as type declarations, REST parameters and argument unpacking
- Using PHP include and restore
- Creating arrays
- Manipulating strings in PHP using built-in functions
- Maintaining state using cookies, session variables, hidden form fields and query strings
- Using PHP to manipulate files
- Identifying and handling the three main types of errors that can occur when programming with PHP
- The fundamental techniques necessary to create a shopping cart solution
- Introduction to OOP (Object Oriented Programming) in PHP
- Using an object-oriented API to access SQL to SELECT, INSERT, UPDATE and DELETE data from tables
- Using the phpMyAdmin utility to administer the MySQL database
- Using OOP in PHP to define and use classes
- Implementing RESTful servers with OOP PHP
Course outline
Part 1: Get started fast with PHP and MySQL
Module 1: Introduction to web development with PHP
Module 2: How to code a PHP application
Module 3: Introduction to relational databases and MySQL
Module 4: How to use PHP with a MySQL database
Module 5: How to use the MVC pattern to organize your code
Module 6: How to test and debug a PHP application
Part 2: Master PHP programming
Module 7: Coding form data
Module 8: How to code control statements
Module 9: Coding strings and numbers
Module 10: Coding dates
Module 11: How to create and use arrays
Module 12: Coding cookies and sessions
Module 13: How to create and use functions
Module 14: How to create and use objects
Module 15: How to use regular expressions, handle exceptions, and validate data
Part 3: Master MySQL programming
Module 16: How to design a database
Module 17: How to use SQL to create a database
Module 18: How to use SQL to work with a database
Module 19: Professional PHP for working with MySQL
Module 20: A database-driven website
Part 4: Master the advanced skillsfor building websites
Module 21: How to create secure websites
Module 22: How to send email
Module 23: Coding files, uploads, and images
Module 24: An eCommerce website
Schedule
Our minimum class-size is 3 for this course. Currently, there are no scheduled dates for this course but it can be customized to suit the time schedule and skill needs of clients and may be held online or at our site or your premises.
Click on the following link below to arrange for a custom course: Enquire about a course date
Reviews
There are no reviews yet.