Do you want to learn how to use both MySQL and PHP effectively?
Have you heard about LAMP and wonder what the fuss is all about?
Do you want to create large web applications using MySQL and PHP?
Then Effective Web Development with MySQL and PHP is the class for you! An Authorized MySQL instructor will teach you how to develop applications in PHP and how to use MySQL efficiently for those applications!
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.
Objectives
At completion of this course, you should be able to:
Design web-based applications
Design schemas based on MySQL
Use include files to make code easier to maintain
Use PHP 5 and takes advantage of its advanced features
Build applications following a precise flow
Authenticate users in a secure way against a database
Handle errors in your PHP applications efficiently and gracefully
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
Build a complete application that includes authentication and session management
Understand how PHP, MySQL and the Apache web server work together to deliver dynamic web content
Who should attend?
Developers who use PHP and MySQL to build and maintain their websites
Developers who want to learn how PHP and MySQL can be used for the rapid prototyping and deployment of dynamic websites
Prerequisites
This class is suitable for web developers with some HTML experience and experience with some other programming language. We will be using Linux as our Operating System.
Format
Instructor led, with hands-on lab exercises
Each student will be provided with their own computer
Sistemi per MySQL
