PHP & MySQL for Web Development

2 days @ £645.00  
S5

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.

Skills Gained

The delegate will learn to:

  • Install and Test MySQL
  • 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.

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: MySQL

  • Installing MySQL
  • Testing MySQL

Session 2: BASIC SQL STATEMENTS

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

Session 3: CONNECTING TO MySQL

  • mysql_connect
  • mysql_error
  • mysql_select_db
  • 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

Pre-Requisite Courses

Follow-On Courses


       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking

In London


MOD Career Transition

Ministry Of Defense - Career Transition Partnership

 

We have created our website to the following W3C standards, this helps makes our pages easier to use for you.

Valid HTML 4.01 Transitional

Valid CSS!

If you find a non-compliant page on our site, please let us know and we will endeavour to fix it immediately.
 

Publicly Scheduled
Training Locations
London centre:
6 Long Lane
Barbican
London
EC1A 9HF
UK

telephone:
+44 (0)20 7600 6116
Manchester centre:
MWB Manchester
Pall Mall Court
61-67 King Street
Manchester
M2 4PD
UK
Birmingham centre:
MWB Birmingham
43 Temple Row
Birmingham
B2 5LS
UK
Bristol centre:
Woodhouse Manor
Fern Hill
Almondsbury
Bristol
BS32 4LX
UK
Leeds centre:
c/o Blue Chip Training Solutions
11 New Princess Street
Leeds
LS11 9BA
UK
Edinburgh centre:
16 St Mary's Street
Edinburgh
Scotland
B3 2HJ
UK
Please contact our London office for all enquiries.

telephone:
+44 (0)20 7600 6116

or email:

info@
stayahead.com



 

Top  |  Go back  

Print Friendly

Printer friendly version of the PHP & MySQL for Web Development outline