LIVE Instructor-Led Courses

PHP with MySQL training course

Build Enterprise Backend Applications Using PHP/MySQL - Reduce Development Time & Costs

JBI training course London UK

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

Enquire & get a quote
Next on 4 Jul - see prices
JBI training course London UK

  • Introduction to PHP, Understand PHP Basics
  • Initialize, Populate and Accessing arrays
  • Use PHP in web applications
  • Learn the Control structures
  • Declare Functions and arguments 
  • The filesystem: Write and read files 
  • Learn to Create Clean Code with OOP
  • Properties and methods visibility
  • Inheritance and Interfaces
  • How to Handle exceptions
  • Use and learn Design patterns and Databases
  • Understand Keys and constraints
  • Learn Inserting, Updating, Deleting, Querying data
  • Learn how to Adapt to MVC
  • How to Work with requests
  • Test: Learn to test Web Applications
  • Learn Integrating PHPUnit
  • Writing unit tests
  • Use Existing PHP Frameworks
  • Learn more features of frameworks
  • Types of frameworks
  • An overview of famous frameworks
  • The Laravel framework: Install and setup project

Introduction to PHP

Setting up the environment – Installing LAMP / WAMP / MAMP which includes PHP MySQL and Apache server for Windows, Linux, and Mac
Web servers - how they work, putting it all together
The built-in PHP testing server

Understanding PHP Basics

PHP Variables and Data Types
Operators – math, assignment, comparison, logical
Incrementing / Decrementing
Operator precedence
Working with strings


Initializing arrays
Populating arrays
Accessing arrays
The empty and isset functions
Searching for elements in an array
Ordering arrays
Other array functions

PHP in web applications

Regular expressions

Control structures

Loops – While, Do While, For, Foreach


Function declaration
Function arguments
The return statement
Type hinting and return types

The filesystem

Reading files
Writing files
Other filesystem functions

Creating Clean Code with OOP

Classes and objects
Class properties
Class methods
Class constructors
Magic methods

Properties and methods visibility

Static properties and methods
Autoloading classes
Using the __autoload function


Introducing inheritance
Overriding methods
Abstract classes



Handling exceptions

The try…catch block
The finally block
Catching different types of exceptions

Design patterns

Anonymous functions

Using Databases

Schemas and tables
Understanding schemas
Database data types – Numeric, String, DateTime, List of Values
Managing tables

Keys and constraints

Primary keys
Foreign keys
Unique keys

Inserting, Deleting, Querying data

Using PDO
Connecting to the database
Performing queries with Prepared statements

Updating and deleting data

Updating data
Foreign key behaviours
Deleting data

Adapting to MVC

The MVC pattern
Using Composer
Managing dependencies
Autoloader with PSR-4
Adding metadata
The index.php file

Working with requests

The request object
Filtering parameters from requests
Mapping routes to controllers
The router
M for model
The customer model
The book model
The sales model
V for view 207
Introduction to Twig
The book view
Layouts and blocks
Paginated book list
The sales view
The error template
The login template
C for controller 215
The error controller
The login controller
The book controller
Borrowing books
The sales controller
Dependency injection
Why is dependency injection necessary?
Implementing our own dependency injector

Testing Web Applications

Types of tests
Unit tests and code coverage

Integrating PHPUnit

The phpunit.xml file
Your first test
Running test


Writing unit tests

The start and end of a test
Expecting exceptions
Data providers

Using Existing PHP Frameworks

The purpose of frameworks
The main parts of a framework

Other features of frameworks

Authentication and roles

Types of frameworks

Complete and robust frameworks
Lightweight and flexible frameworks

An overview of famous frameworks

Symfony 4
Zend Framework 2
Other frameworks

The Laravel framework

Project setup
Adding the first endpoint
Managing users
Setting up relationships in models
Creating complex controllers
Adding tests

JBI training course London UK

Developers who wish to know how to develop commercial PHP web applications.

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

JBI training course London UK
Top 20 "Pain Points" for Data Analysts

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox

+44 (0)20 8446 7555


Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS


Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course