EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


PHP with MySQL Training Course

NEXT COURSE
3 Sep London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

PHP with MySQL training course (code: PHPMYSQL)

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


SEE MORE COURSES IN THIS CATEGORY

TRAINING COURSE OVERVIEW

On our PHP+MySQL training course, we will show you why it is such a popular language and how it makes learning programming very easy for the novice to expert programmer. We will also show you how object orientation, which was  added to PHP 5, enables it to be used for more than just web development. Combined with MySQL, an open source database, we show how PHP can be used to develop applications for mobile and fixed devices.  Not only will you look at the basics of PHP and MySQL, but we’ll also look at its framework Laravel. Using Laravel not only lets you leverage the popularity of PHP and MySQL, but develop apps quicker and faster by using built in features like Eloquent and the Blade templating engine.

AUDIENCE

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



DETAILHIGHLIGHTS

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

Arrays

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

Processing
Display
Formatting
Tokenising
Regular expressions

Control structures

Conditionals
Switch…case
Loops – While, Do While, For, Foreach

Functions

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

Encapsulation
Static properties and methods
Namespaces
Autoloading classes
Using the __autoload function

Inheritance

Introducing inheritance
Overriding methods
Abstract classes

Interfaces

Polymorphism
Traits

Handling exceptions

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

Design patterns

Factory
Singleton
Anonymous functions

Using Databases

MySQL
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
Indexes

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
Assertions
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
ORM
Cache
Internationalization

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

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

  • Introduction
  • Understanding PHP Basics
  • Arrays
  • PHP in web applications
  • Control structures
  • Functions
  • The filesystem
  • Creating Clean Code with OOP
  • Properties and methods visibility
  • Inheritance
  • Interfaces
  • Handling exceptions
  • Design patterns
  • Using Databases
  • Keys and constraints
  • Inserting, Deleting, Querying data
  • Updating and deleting data
  • Adapting to MVC
  • Working with requests
  • Testing Web Applications
  • Integrating PHPUnit
  • Writing unit tests
  • Using Existing PHP Frameworks
  • Other features of frameworks
  • Types of frameworks
  • An overview of famous frameworks
  • The Laravel framework
Receive the latest version of this course into your inbox


PUBLIC COURSES (LONDON, UK)
 

3rd Sep 2018 - 5 days £1995
Book

see all dates


X

Show Discount for this course


PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


Get in touch
0800 028 6400




Excellent feedback, consistently !

►"great tips help reduce build times"
► "we got access to exclusive content"
► "Short course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"


Newsletter ! Get exclusive news about upcoming programs, technical insights & special offers