PHP & MySQL

Name: PHP & MySQL
Start: 2023-07-17 00:00:00
Location: The Shard, London

Are you looking to add web functionality that only server side scripting will allow? Then our two day PHP & MySQL course is the perfect place to start.

2 day course

Supporting material

Classroom, Virtual, Private

Classroom

Face to face, interactive classroom training run from our global training centres.

Virtual Classroom

A convenient and interactive learning experience, that enables you to attend one of our courses from the comfort of your own home or anywhere you can log on. We offer Virtual Classroom on selected live classroom courses where this will appear as an option under the location drop down if available. These can also be booked as Private Virtual Classrooms for exclusive business sessions.

Private

A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

PHP is the language powering more than 80% of the web that uses server side technology, if you want your website to interact with a database and have back end functionality, then you need to know PHP.

This course starts from the beginning of setting up your server and writing your first line of PHP code. Then over two consecutive days you will gain understanding on how to send and receive information to and from a database and how to create secure interactive website functionality.

Through project based learning you will gain practical experience in working with variables, arrays, conditional statements, loops, functions, objects, error reporting and exceptions.

Our PHP & MySQL course is available at our training centre in The Shard, London. We also offer private training at a location of your choice or via Virtual Classroom.

Course overview

Who should attend:

If you want to take your first steps in becoming a backend developer, but currently have no experience and don’t know where to start, then this is the course for you. This course will run over two consecutive days.

Walk away with the ability to:

Customise your web server and use it to run your PHP programs
Work effectively with all the PHP variable types
Work with inbuilt PHP functionality to increase your workflow
Use conditional statements, loops, functions and objects to solve a range of problems
Setup and use a secure link with a database to run MySQL queries

Course agenda

Introduction

PHP Overview
XAMPP Setup
Hello World!
Comments

Variables

Declaration
Types
String Functions

Arrays

Declaration and Using
Associative Arrays
Multidimensional
Array Functions

Logic

If Statement
If Else Statement
Switch Statement

Loops

While Loop
Do…While Loop
For Loop
Foreach Loop

Functions

Declaration
Variable Scope
Passing Values

Objects

OO Programming
Class declaration
Methods & Properties
Inheritance

Database Introduction

Database Overview
MySQL
Command Line
phpMyAdmin

Using MySQL

Running a Query from PHP
Query Types
Relationships
Variable Types
Date & Time

MVC’s

Model View Controller Overview
Top MVCs
Advantages of Using a MVC

Upcoming courses

The Shard, London PHP & MySQL	Mon, Jul 17 2023 £599 ex VAT	ADD TO BASKET
The Shard, London PHP & MySQL	Mon, Sep 18 2023 £599 ex VAT	ADD TO BASKET
The Shard, London PHP & MySQL	Mon, Nov 20 2023 £599 ex VAT	ADD TO BASKET

Upcoming courses

The Shard, London

PHP & MySQL

Mon, Jul 17 2023

£599 ex VAT

ADD TO BASKET

The Shard, London

PHP & MySQL

Mon, Sep 18 2023

£599 ex VAT

ADD TO BASKET

The Shard, London

PHP & MySQL

Mon, Nov 20 2023

£599 ex VAT

ADD TO BASKET

Book this course

Location

Date

£599 ex VAT