Developing and delivering dynamic web sites using Linux, Apache, MySQL and PHP

5 Day Course

This course has been retired. Please view currently available Web Skills Training Courses.


Hide all

Setting the scene (2 topics)

  • The architecture of web applications
  • The case study

Installing Linux (4 topics)

  • Installation Methods
  • Partitioning
  • Account creation
  • Other configuration choices

Survival Linux (5 topics)

  • Key command line tools
  • File system management commands
  • File permissions
  • System activity reporting tools
  • File system tour: what lives where

Installing and configuring Apache (5 topics)

  • Installation
  • Basic configuration
  • Virtual Hosting
  • Access control
  • Creating secure connections with SSL

An HTML Primer (4 topics)

  • Basic tags and attributes
  • Tables
  • Forms
  • Cascading style sheets

PHP core language (5 topics)

  • Creating a stand-alone script
  • Data types and variables
  • Arithmetic operators
  • Relational operators
  • Flow control

PHP advanced features (4 topics)

  • Functions
  • Arrays
  • String manipulation
  • Object-oriented programming

Processing web forms with PHP (3 topics)

  • Embedding PHP into a web page
  • Accessing form data from PHP
  • Maintaining state in web applications

Database Fundamentals (4 topics)

  • Tables, columns and keys
  • Data types
  • Data relations
  • Designing our database

Structured Query Language (4 topics)

  • Creating tables
  • Inserting data
  • Querying the database
  • Deleting data

Installing and configuring MySQL (5 topics)

  • Installation
  • Administration using mysql command line tool
  • MySQL Workbench
  • Granting rights to users
  • Creating, populating and querying tables

Accessing a database using PHP (4 topics)

  • Connecting to the database
  • Building and executing a query
  • Accessing the results of a query
  • Putting it altogether

Staying safe (5 topics)

  • Applying the principal of least privilege
  • Hardening linux
  • Protecting the database
  • Authentication and authorisation in web applicactions
  • Validating user input


Delegates should have basic Linux command-line competence including knowledge of file system commands, users and groups, and file permissions. Prior exposure to some of the relevant technologies (Databases, SQL, HTML, and a programming language) would be advantageous but is not essential. No prior specific knowledge of Apache, MySQL or PHP is assumed.

Course PDF