MySQL and PHP - Developing Dynamic Web Applications

Σκοπός Εκπαιδευτικού Προγράμματος
In the MySQL[tm] and PHP - Developing Dynamic Web Applications you will learn 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.

Πού Απευθύνεται

• 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

Θεματικές Ενότητες

• Introduction
• Structure of MySQL AB
• MySQL Products and Services
• MySQL Partners
• Supported Operating Services
• MySQL Certification Program
• Training Curriculum Paths
• MySQL Website

Verify Installation

• LAMP Architecture
• Install/Verify Apache Installation
• Install/Verify MySQL Installation
• Install/Verify PHP Installation
• Putting it All Together

PHP Foundations

• Delimit PHP Code Within HTML
• Comment PHP Code
• Construct PHP that interacts with end users
• Data Types in PHP
• Key Control Systems
• Use Defined Functions

MySQL Foundations

• General Architecture
• SQL Parser and Storage Engine Tiers
• MySQL Client
• MySQL Query Browser

Manage Databases

• Database Properties
• Database Design Practices
• MySQL Identifiers
• Create Databases
• Alter Databases
• Drop Databases

Manage Tables

• Table Properties
• MySQL Data Types
• Create Table
• Alter Table
• Empty Table
• Remove Table
• Indexes
• Foreign Keys

SQL SELECT Commands

• SELECT Statements
• Aggregating Query Results

SQL Expressions

• SQL Expressions
• Functions in SQL Expressions

SQL DML Commands

• INSERT Statement
• DELETE Statement
• UPDATE Statement
• REPLACE Statement

SQL Joins

• What is a Join
• Inner Joins
• Outer Joins
• Using Qualifiers and Aliases
• Multiple Table UPDATE and DELETE Statements

MySQL Database Driven Web Based Forms

• Connecting to MySQL
• Retrieving Data
• Inserting Data
• Updating Existing Data
• Deleting Data
• MySQL Metadata
• MySQL Error Information

Session Handling

• What is Session Handling
• Session Handling Tasks
• PHP Session Handling with MySQL

Object Oriented Programming

• Benefits of OOP
• Working with Objects
• Exception Handling

Authentication

• HTTP Authentication
• PHP Authentication

Securing PHP and MySQL

• PHP Configuration Parameters
• Data Encryption
• Securing the MySQL Server
• Privileges

Conclusion

• Course Overview
• MySQL System Overview
• Training and Certification Website
• Course Evaluation
• Thank You!
• QA Session

Διάρκεια Προγράμματος
4 ημέρες

Προϋποθέσεις Συμμετοχής
Have some programming experience (preferably PHP)
Have some understanding and experience of Object-Oriented Pr
Some experience with relational databases
Understand fundamental PHP syntax
Understand how HTML files are assembled

Ενδιαφέρομαι για σεμινάρια, πιστοποιήσεις, άλλα θέματα.