PHP & MySQL are development technologies that are normally used together to develop web server applications. Currently there is massive demand for developers who are skilled with these development tools.
Our training is delivered through our On-line 24/7 Mentored training platform.
The training is broken up into modules from Beginner to Intermediate to Advanced.
PHP & MySQL Course Outline
Getting Started
- To install and configure MySQL
- To install and configure Apache with PHP
- To create MySQL users and grant privileges
- To test PHP and MySQL installations
- To configure PHP
PHP an Overview
- Identify basic PHP syntax
- Create basic PHP scripts
- Send data to the Web browser
- Apply variables, strings, and constants to a PHP a script
Programming with PHP
- Handle HTML forms using PHP scripts
- Validate form data
- Manage arrays using various types of loops
- Work with magic quotes
Creating Dynamic Website
- Create PHP scripts using multiple files
- Display and handle HTML forms within a single PHP script
- Create and call functions
- Create functions that take arguments and return values
- Set and alter variable scope
- Send email from a PHP script
SQL and MySQL an Overview
- Choose column types and other column properties
- Create databases and tables
- Insert records, select, update and delete data
- Use conditionals and functions
Advanced SQL and MySQL
- Normalize a database into First, Second and Third Normal Forms
- Create and populate a database in MySQL
- Search a database using joins, groupings, and FULLTEXT searches
- Change the search engine type of a table
- Create indexes to improve the ability to search a database
Error Handling and Debugging
- Identify error types
- View, log, and debug errors
- Adjust PHP's error reporting
- Create custom error handlers
Using PHP with MySQL
- Describe how arguments and PHP functions relate to the database
- Differentiate between simple and complex functions depending on execution results
- Understand the importance of associative and indexed arrays.
- Modify specific scripts to allow for secure data transmission
- Update database records using PHP scripts
Developing Web Applications
- Adjust behavior for server settings
- Pass variables and values to a script
- Edit existing records
- Paginate query results
- Make sortable displays
- Use HTTP headers
Cookies and Sessions
- Use cookies
- Use sessions
- Improve session security
- Manage the relationship between cookies and sessions
Web Application Security
- Prevent forms from being submitted multiple times
- Validate form data
- Define patterns and both match and replace them
- Manage database encryption and decryption techniques
Advanced Topics
- Upload a file in PHP
- Develop JavaScript using PHP
- Utilize output buffering
- Identify Improved MySQL Extension functions
- Describe the purpose of PEAR
Content Management Example
- Create the advanced PHP scripts needed for a content management site
- Update and add information with a database
- Download files through PHP scripts and database interactions
- Manage files through PHP scripts and database interactions
User Registration Example
- Handle user registration
- Activate accounts
- Create login and logout scripts
- Apply password management
E-commerce Example
- Create a database for an e-commerce site
- Create the administrative pages for an e-commerce site
- Create pages for a customer to browse the inventory and place orders from an e-commerce site
- Create and manage an online shopping cart for your e-commerce site
Other Training Benefits
- Specialised Teacher Support - You will have support for all your questions
- Hands on skills - Software simulations in real world scenarios
- Cost effective - You don't have to break your budget to get started
- Flexibility - You don't have to take time off work or disrupt your schedule
Take the next step now!
Register for more information and receive FREE of charge our e-book
"11 Breakthrough strategies for Interview Success"