MySQL and PHP - Developing Dynamic Web Applications - MySQL authorized trainings | Training

Training

	MySQL trainings
MySQL and PHP - Developing Dynamic Web Applications

Training goals

Through a hands-on approach, this instructor-led course will help you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.

Training days

4 days

Conspect

At completion of this course, you should be able to:

Design web-based applications.
Design schemas based on MySQL.
Use Object-Oriented Programming (OOP) as needed to build complex projects.
Use include files to make code easier to maintain and scale.
Use PHP 5 and takes advantage of its advanced features.
Work with HTML forms, validating, escaping and filtering data to ensure maximum security.
Build applications following a precise flow.
Authenticate users in a secure way against a database.
Handle errors in your PHP applications efficiently and gracefully.
Take advantage of MySQL’s full-text indexing features.
Writes composite queries using JOINs and subqueries.
Use indexing efficiently in order to manipulate large amounts of data efficiently.
Uses joins to extract data from multiple tables.
Uses GROUP BY clauses and aggregate functions.
Write applications whose components can be scaled to meet increased demand.
Write applications secure applications.
Use PHP’s caching capabilities.
Take advantage of PHP’s encryption capabilities.