PHP & MySQL

Name: PHP & MySQL
Price: 485.00 SGD

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

Virtual, Private

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 offered as a private training session and can be delivered at our training facility in Suntec City, any 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

Book this course

Call our sales team today

65 697 16440