MySQL
and php - Developing Dynamic Web ApplicationsDuration:
4 Days
What
you will learn
In
the MySQL 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.
Students
who can benefit from this course:
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
Required
Prerequisites
Have
some programming experience (preferably php)
Have
some understanding and experience of Object-Oriented Pr
Some
experience with relational databases
Understand
fundament al php syntax
Understand
how html files are assembled
Course
Objectives
- 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
Course Topics
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
Define d 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