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

Level

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

Aikona
Logo Aikona

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: PHP, PHP, and Linux.

Description

Overview

The 'LAMP' stack of open-source technologies (Linux, Apache, MySQL and PHP) provides an excellent platform for web content delivery. 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.

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 la…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: PHP, PHP, Linux, Web Accessibility, and Web Analytics.

Overview

The 'LAMP' stack of open-source technologies (Linux, Apache, MySQL and PHP) provides an excellent platform for web content delivery. 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.

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.

Delegates will learn how to

  • Install and configure Linux, Apache, MySQL and PHP onto a bare machine
  • Configure apache to support virtual hosting, authenticated login, and SSL
  • Design, create and populate a relational database using MySQL
  • Design and run database queries and updates using SQL
  • Keep web servers and web applications secure
  • Create web pages and web forms using HTML and CSS
  • Use PHP for server-side processing and database access within a web application

Course Outline.

Setting the scene

  • The architecture of web applications
  • The case study

Installing Linux

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

Survival Linux

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

Installing and configuring Apache

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

An HTML Primer

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

PHP core language

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

PHP advanced features

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

Processing web forms with PHP

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

Database Fundamentals

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

Structured Query Language

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

Installing and configuring MySQL

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

Accessing a database using PHP

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

Staying safe

  • Applying the principal of least privilege
  • Hardening linux
  • Protecting the database
  • Authentication and authorisation in web applicactions
  • Validating user input
There are no reviews yet.
  • View related products with reviews: PHP, PHP, and Linux.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.