MySQL and php Developing Dynamic Web Applications 1.0 Training Institute in Chennai (ISQL Global)
MySQL and php - Developing Dynamic Web Applications
Duration: 4 Days
What you will learn
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.
- 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 fundamental 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 efficientlyin 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