PHP & MySQL for Web Development

StayAhead Training

Course summary

2 days

745 GBP excl. VAT

StayAhead Training

Open / Scheduled

Next available date: 20/02/2020 09:30 - London

5.0 (1 Reviews)

Course Dates

London

20/02/2020 09:30

745 GBP

26/03/2020 09:30

745 GBP

14/05/2020 09:30

745 GBP

25/06/2020 09:30

745 GBP

06/08/2020 09:30

745 GBP

24/09/2020 09:30

745 GBP

Show all (8)

Request Information Book Now

Course description

PHP & MySQL for Web Development Course Overview

The PHP & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain HTML/PHP code that utilises the MySQL Database system.

The delegate will learn and acquire skills as follows:

PHP Configuration
Basic SQL Syntax
Connect to a MySQL Database with Error Checking
Use PHP to Interact with a MySQL Database
Utilise PHP with the HTML Environment
Work with Email and Cookies
Consider Security Implications when using PHP and MySQL

Who will the Course Benefit?

UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.

Course Objectives

On completion of the PHP & MySQL for Web Development course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database.

Pre-Requisite Courses

PHP Programming
Introduction to MySQL

Follow-On Courses

Apache Web Server
Perl Programming
Python Programming 1
Ruby Programming
Ruby on Rails

Notes:

Course technical content is subject to change without notice.
Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

PHP & MySQL for Web Development Training Course

Course Contents - DAY 1

Course Introduction

Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions

Session 1: PHP CONFIGURATION

Working with External Files
Error Reporting
Interacting with External Programs

Session 2: BASIC SQL STATEMENTS

Creating Databases and Tables
Inserting Data into Tables
Viewing Tables
UPDATE
Drop

Session 3: CONNECTING TO MySQL

mysqli_connect
mysqli_error
Die

Session 4: USING PHP TO PERFORM DATABASE FUNCTIONS

Inserting Data into a Database
Creating Queries
Executing Queries
Processing the Returned Query Data
Updating the Database

PHP & MySQL for Web Development Training Course

Course Contents - DAY 2

Session 5: GENERATING HTML USING PHP

PHP Inside HTML
HTML Form with Embedded PHP
Multiple HTML Pages/Forms with PHP

Session 6: EMAIL AND COOKIES USING PHP

Generating Email using PHP
Generating Cookies using PHP
Using Cookies

Session 7: PHP AND DATABASE SECURITY

Designing Databases
Connecting to Database
Encrypted Storage Model
SQL Injection
Security Techniques
Error Reporting
User Submitted Data

Request Information

Expenses

£745.00

Continuing Studies

Follow on courses: Apache Web Server, Perl Programming, Python Programming 1, Ruby Programming, Ruby on Rails

Customer Outreach Award

We believe that it should be easy for you to find and compare training courses.

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

StayAhead Training - Unix, Linux, MySQL, Java, CSS, HTML, Oracle, RedHat, Linux, Solaris, PHP, Perl, Python, Programming

StayAhead Training established 1992, is recognised as one of the leading independent IT Training specialists in the UK and the first choice provider for many of UK's largest organisations. Located in 7 training centres throughout the UK: London, Birmingham, Manchester,...