Home » Training Courses » Programming & Networking Training » PHP MySQL Training

PHP MySQL Training

2 days - private courses from £1450 + vat

PHP is a scripting language written by and for web developers: it is quick to learn, easy to deploy and provides many of the programming tools a web developer could wish for ... all in a single, free, cross-platform, open-source package.

PHP MySQL Training Course Objectives

This PHP MySQL course concentrates on using PHP with the popular MySQL database.

PHP MySQL Training Course Content

• Get up to speed with tried-and-true programming strategies, for both Web and local development.
• Gain valuable tips and tricks for using the PHP language and syntax.
• See how to integrate MySQL in Windows, PHP's most popular development platform.
• Learn how to streamline PHP's interaction with MySQL, SQL, and relational databases in general.
• See how Object Orientated Programming with PHP can allow for code reuse, modularity and rapid development.
• Watch how PHP's sessions can be used to quickly build full-scale web applications.
• Glimpse at PHP's inner workings to understand how to build secure and performance conscience programs, including proper use of references, global variables and scope.
• Begin to see how PHP Technology can be leveraged to rapidly create and maintain large enterprise web applications.

After two full days of intensive PHP MSQL course, you will leave with a comprehensive understanding of premier PHP use and features, including MySQL, Object Orientated PHP Programming, sessions, security and performance.

First principles

Looks at the building blocks of PHP, examining data types, control structures, operators and arrays. Roll your own functions and learn about PHP's in-built function toolkit. Consider good practice in application design, program structure and coding. Adopt best practices in variable referencing and scope.

MySQL development

Get up to speed with relational theory. Design a database to support a real world task. Move on to choose appropriate MySQL data types, naming conventions and indexes for your database. Analyse the different strategies to access and manipulate data, from building Select, Insert, Delete and Update queries to Group By and multi-table statements. Use your learning in a real world context.

Sessions and Cookies

Compare different techniques of preserving state on a website. Use sessions and cookies to track users. Put learning into practice by building a user authentication application, enabling site visitors to log into a secure website.

Object oriented PHP

Consider the benefits of OO programming. Learn how to build and use classes in PHP.

Tips and tricks

Use PHP to generate e-mail. Re-use your code to template your site. Pick up tips about debugging your code and trapping errors.

PHP MySQL Training Course Prerequisites

It is recommended that students be familiar with:

• Hand coding HTML and web form design
• SQL and Relational database theory
• Fundamental programming techniques, style and logic

PHP MySQL Course Recommended Reading

PHP and MYSQL for Dummies - Valade – buy from amazon

Download course outline as pdf.

Share This

• Digg
• Twitter
• Stumbleupon
• Delicious
• Facebook
• Myspace
• Google
• Technorati
• Newsvine