PHP & MySQL

4.7 / 5 Feefo reviews

New to PHP and want to harness its power? Our two-day PHP & MySQL course will teach you everything you need to know so that you can set up your sever and create interactive website functionality.

Book this course
Call our sales team today
2 day course
Supporting material
Private
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.

On this two-day course, we’ll start by teaching you how to set up your server, and write your first line of PHP code.

Over two consecutive days, you’ll learn how to send and receive information to and from a database, and how to create secure, interactive website functionality. Through project-based learning you’ll gain hands-on experience working with variables, arrays, conditional statements, loops, functions, objects, error reporting and exceptions.

Our PHP & MySQL course is available as a private training session that can be delivered via Virtual Classroom or at a location of your choice in the US.

Course overview

Who should attend:

If you want to take your first steps toward becoming a back-end developer, but currently have no experience and don’t know where to start, then this is the course for you.

What you'll learn:

By the end of this course, you will be able to:

  • Customize 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
  • Set up and use a secure link with a database to run MySQL queries

Course agenda

Introduction
  • PHP overview
  • XAMPP set-up
  • 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 and properties
  • Inheritance
Database Introduction
  • Database overview
  • MySQL
  • Command line
  • phpMyAdmin
Using MySQL
  • Running a query from PHP
  • Query types
  • Relationships
  • Variable types
  • Date and time
MVCs
  • Model View Controller overview
  • Top MVCs
  • Advantages of using a MVC
close
Don't miss out
Keep up to date with news, views and offers from Jellyfish Training.
Your data will be handled in accordance with our Privacy Policy
Feefo logo
4.7 / 5 Feefo reviews
Independent Service Rating based on 3 verified reviews

PHP & MySQL

good course and dan knew his stuff

Daniel Wright 15 March, 2022

PHP & MySQL

Very well structured course with hands-on coding sessions. I find it useful for me current projects.

Trusted Customer 9 November, 2020

PHP & MySQL

Yes it was worth it and I would be interested in other courses

Russell Williams 19 July, 2018