PHP & MySQL Training in Coimbatore | RedLeaf Technologies

MySQL and PHP - Developing Dynamic Web Applications
Introduction
1. Structure of MySQL AB
2. MySQL Products and Services
3. MySQL Partners
4. Supported Operating Services
5. MySQL Certification Program
6. Training Curriculum Paths
7. MySQL Website
Verify Installation
1. LAMP Architecture
2. Install/Verify Apache Installation
3. Install/Verify MySQL Installation
4. Install/Verify PHP Installation
5. Putting it All Together
PHP Foundations
1. Delimit PHP Code Within HTML
2. Comment PHP Code
3. Construct PHP that interacts with end users
4. Data Types in PHP
5. Key Control Systems
6. Use Defined Functions
MySQL Foundations
1. General Architecture
2. SQL Parser and Storage Engine Tiers
3. MySQL Client
4. MySQL Query Browser
Manage Databases
1. Database Properties
2. Database Design Practices
3. MySQL Identifiers
4. Create Databases
5. Alter Databases
6. Drop Databases
Manage Tables
1. Table Properties
2. MySQL Data Types
3. Create Table
4. Alter Table
5. Empty Table
6. Remove Table
7. Indexes
8. Foreign Keys
SQL SELECT Commands
1. SELECT Statements
2. Aggregating Query Results
SQL Expressions
1. SQL Expressions
2. Functions in SQL Expressions
SQL DML Commands
1. INSERT Statement
2. DELETE Statement
3. UPDATE Statement
4. REPLACE Statement
SQL Joins
1. What is a Join
2. Inner Joins
3. Outer Joins
4. Using Qualifiers and Aliases
5. Multiple Table UPDATE and DELETE Statements
MySQL Database Driven Web Based Forms
1. Connecting to MySQL
2. Retrieving Data
3. Inserting Data
4. Updating Existing Data
5. Deleting Data
6. MySQL Metadata
7. MySQL Error Information
Session Handling
1. What is Session Handling
2. Session Handling Tasks
3. PHP Session Handling with MySQL
Object Oriented Programming
1. Benefits of OOP
2. Working with Objects
3. Exception Handling
Authentication
1. HTTP Authentication
2. PHP Authentication
Securing PHP and MySQL
1. PHP Configuration Parameters
2. Data Encryption
3. Securing the MySQL Server
4. Privileges
Conclusion
1. Course Overview
2. MySQL System Overview
3. Training and Certification Website
4. Course Evaluation
5. Thank You!
6. QA Session