FastTrack to PHP / MySQL

Highlander's FastTrack to PHP / MySQL training course combines the 3 day instructor led FastTrack to PHP / MySQL class, with 6 months access to our Learning Management System (LMS) including course slides and demos, discussion forums, extensive PHP & MySQL glossary, additional exercises and samples, and other online learning support.

The 3 day classroom course is run monthly at our London centre or available at your own location, and is a great way to get up to speed on using the PHP Language on top of the MySQL database. The course is suitable for anybody new to PHP and MySQL, and whilst you may find it useful to attend our DreamWeaver CS3 Website Development course first is is not neccessary for attending the course.

Classroom Course Overview

Introduction to PHP

  • Why choose PHP/MySQL/Apache
  • PHP's purpose and capabilities
  • Server Side vs. Client Side Scripting
  • What PHP looks like – Basic structure
  • Setting your development environment up with your testing server
  • Testing PHP installations in your server
  • Which servers can use php
  • Where to write the php code and using which applications

Language Basics

  • Structure and Syntax
  • Data Types in PHP
  • Using Variables and Constants
  • Processing data using operators
  • Understanding Arrays
  • Working with combinations of Data Types, Variables and Arrays

Arrays

  • Array types
  • Multi-dimensional arrays
  • Getting data out of arrays
  • Array operations
    • addition
    • comparing
    • Counting
    • Searching
    • Flipping/Reversing
  • Deleting elements within an array

More Arrays

  • Sorting arrays
    • sort
    • asort
    • ksort
    • natsort
    • shuffle
    • key sort
  • Stacks and Queues
    • push/pop
    • shift/unshift
  • Sets
    • array_diff
    • array_intersect

Strings

  • Escape sequences
  • Variables and string combined
  • Escaping literal values
  • Length
  • translation
  • comparison
  • searching
  • matching
  • search and replace

Giving your code life – Control Structures

  • Conditional decision making – if, else, and elseif
  • True, false, and evaluation of expressions
  • Multiple and nested conditions
  • Short Circuit Evaluation – break and continue
  • The ‘?’ Operator
  • Decision making using the switch statement
  • Iterations using while, do...while, for and for each loops
  • Iterating through an array
  • Terminating code using exit, return, and die

Creating Dynamic Web Content

  • Embedding PHP in Web pages
  • Retrieving user input through forms, using the GET and POST method
  • Handling the date and time
  • Dynamically including code using include and require
  • mail and php
  • Cookies

Using PHP's built-in functions

  • Mathematical functions
  • Generating random numbers

Creating custom functions

  • Why write your own functions
  • Syntax for defining a function
  • Variable scope, and the global statement
  • Adding in function parameters
  • Return values from functions

Objects and Classes

  • Basic OOP
  • Constructors/Destructors
  • Visibility & Scope
  • Static
  • Constants

Introduction to Databases

  • Why use a database – The three-tier architecture approach
  • Introducing MySQL and PHPMyAdmin
  • Understanding the database structure
  • Creating a simple database
  • Basic SQL commands

Making PHP and MySQL work for each other

  • Connecting to the database
  • Displaying database content through PHP
  • Inserting and deleting data into the Database
  • Updating data in the Database
  • Security considerations

Course Facts

Name: FastTrack to PHP /MySQL
Duration: 3 days
Locations: London, onsite
Max Class: 10 delegates
Post Course Support: 6 months

Call Free on 0800 156 0777
for pricing, availability and advice.

 

Post Course Online Support Including:

Course slides, movies and exercises: You will have access to course slides, movies and exercises via our Learning Management System (LMS). Refresh your memory or rework something in your own time and environment.

Post Course Support: You will have 6 months post course support via the LMS. This is in the form of the course forums in which you can post questions on any topic within the course that you are struggling with, and the instructor (and sometimes other delegates) will respond.

PHP / MySQL Sample Files: In addition to the files used in the course, the LMS gives you the ability to work through additional sample files, and real world examples thereby extending both your understanding of ActionScript and your ability to apply the techniques.

PHP / MySQL Glossary: The training includes access to the glossary which allows you to search through a vast range of terms, functions, data types etc. Due to the glossary being autolinked within our forums and other material, this also acts as a valuable quick reference directory when working through the material.

Useful Resources: Our instructors spend a vast amount of research time on technologies like PHP and MySQL, and in doing so come across a lot of useful 3rd party material. In this section we republish links to some of the more useful resources they come across, letting you benefit from their research time.

Skills Assessment: As part of the course you will also have the opportunity to take the Skills Assessment test. This multiple choice test is made up of 36 random questions, and is run over a timed period of 30 minutes. It is designed to give you an idea of how well your PHP and MySQL skills are developing and can be a nice way to measure improvement, not to mention provide feedback to management showing the value of the course.

 

Booking and Dates

The scheduled 3 day FastTrack to PHP / MySQL training class runs on the following dates at our London centre:

04 Jun 08
14 Jul 08
08 Sep 08
03 Nov 08