Web Development Training
By
MGTechnosoft

Agenda ( Web Development )

PHP & MySQL Training Course Objective

• History of PHP
• Versions and Differences between them
• Practicality
• Installation and configuring Apache and PHP
• Default Syntax
• Styles of PHP Tags
• Comments in PHP
• Output functions in PHP
• Datatypes in PHP
• Configuration Settings
• Error Types

Variables in PHP

• Variable Declarations
• Variable Scope
• PHP’s Superglobal Variables
• Variable Variables

Constants in PHP

• Magic Constants
• Standard Pre-defined Constants
• Core Pre-difined Languages
• User defined Constants

Control Structures

• Execution Control Statements
• Conditional Statements
• Looping Statements whith Realtime Examples

Functions       

• Creating Functions
• Passing Arguments by Value
• Passing Arguments by Reference
• Recursive Functions

Arrays

• What is an Array?
• How to create an Array
• Traversing Arrays
• Array Functions

Include Functions     

• Include, Include_once
• Require, Require_once

Regular Expressions

• Validating textboxes,emails,phone number,etc
• Creating custom regular expressions

Object Oriented Programming in PHP       

• Classes, Objects, Fields, Properties, _set(), Constants, Methods
• Encaptulation
• Inheritance and types
• Polymorphism
• Constructor and Destructor
• Static Class Members, Instance of Keyword, Helper Functions
• Object Cloning and Copy
• Reflections

Strings and Regular Expressions     

• Declarations styles of String Variables
• Heredoc style
• String Functions
• Regular Expression Stntax(POSIX)
• PHP’s Regular Expression Functions(POSIX Extended)

Working with the Files and Operating System      

• File Functions
• Open, Create and Delete files
• Create Directories and Manipulate them
• Information about Hard Disk
• Directory Functions
• Calculating File, Directory and Disk Sizes

Error and Exception Handling         

• Error Logging
• Configuration Directives
• PHP’s Exception Class
• Throw New Exception
• Custom Exceptions

Cookies          

• Why Cookies
• Types of Cookies
• How to Create and Access Cookies

Sessions         

• Session Variables
• Creating and Destroying a Session
• Retriving and Setting the Session ID
• Encoding and Decoding Session Data
• Auto-Login
• Recently Viewed Document Index

MySQL Training Course Objective

• Introduction
• Storage Engines
• Functions
• Operators
• Constraints
• DDL commands
• DML Commands
• DCL Command
• TCL Commands
• Views
• Joins
• Indexing
• MySQL with PHP Programming