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

5 Day Course
Code QALAMP

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

Based around a realistic case study, this 5-day hands-on course provides a comprehensive introduction to the use of LAMP to build a dynamic, commercial web site. The courses uses a RedHat-based Linux system as a basis for hands-on exercises but is not closely tied to a specific linux distribution.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Setting the scene (3 topics)

  • The architecture of web applications
  • The case study

Installing Linux (5 topics)

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

Survival Linux (6 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 (6 topics)

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

An HTML Primer (5 topics)

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

PHP core language (6 topics)

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

PHP advanced features (5 topics)

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

Processing web forms with PHP (4 topics)

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

Database Fundamentals (5 topics)

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

Structured Query Language (5 topics)

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

Installing and configuring MySQL (6 topics)

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

Accessing a database using PHP (5 topics)

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

Staying safe (6 topics)

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

Prerequisites

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.

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections