PHP MySQL Training

Why PHP MySQL ?

In today's fast growing internet environment, web applications are used by many corporate companies and sme companies. To create a Web Application we use Server Side Scripting Language and Database to store the information. Web applications are Portable, Cost Effective, Scalable, Available from any system and enable storing the information on server.

We can use server side scripting languages like PHP, JSP, ASP and CFM etc to create web applications. Out of these PHP is used by more than 50% of the websites for creating dynamic applications. Many companies like Google, Yahoo!, Facebook, Digg, Oracle, Wikimedia, Intel, Ebay are using PHP MySQL. In fact many popular Open Source Software like Drupal , Joomla, Wordpress. Moodle and OsCommerce are developed using PHP MySQL.

PHP Training in Canada

Do you want to start you career as a Professional PHP Web Developer? Creating web applications is not like designing as website, there will be a huge difference in web design and web development. In design you have to provide a visual look and feel. But developing PHP Application is about writing a logic to suit client requirements. PHP MySQL can only be learn by writing programs, reading programs and learning new php stuff regularly. So we give the highest priority on practicals to make you able to do the coding and implement logic in the programs. We also offer Online PHP Training and Corporate PHP Traininga for corporate companies.

Benefits of learning PHP Training @ Smash

PHP Training provided by Experienced Trainer
Job Placements Assistance for PHP Developers
PHP Project with Explanation and Implementation
PHP Study Material / Softwares
Practicals / Assignments throughout the course.

PHP Training Course Modules

HTML (Module 1)

Introduction to Websites / Domains.
Server Client Environment
HTML Basics
Working with HTML Forms
CSS Concepts
Working with Dreamweaver

PHP Introduction (Module 2)

Introduction PHP and MySQL
Benifits of using PHP MySQL
Setup of PHP Environment
Testing the Page
Troubleshooting Installation Errors

PHP Programming Concepts (Module3)

Write your First PHP Program
Embed PHP in HTML / HTML in PHP
PHP Data Types
Variables in PHP
SuperGlobal Variables
Operators in PHP
Conditional Statements
Loops (For, While, Do While, Foreach)

PHP Functions (Module 4)

Using Functions in PHP
Userdefined Functions
Predefined Functions
Common Functions
String Functions
File Functions
Date Functions
Hash Functions
Mail Function

MySQL Database Training (Module 8)

What is Database ?
Understanding an RDBMS
Understanding Tables, Records, and Fields
SQL Language
Using the MySQL Command-Line Client

Working with MySQL Admin (Module 9)

Working with PHP MyAdmin
Creating Databases
Types of Databases
Creating Tables in Database
Specifying Field Data Types
Selecting the Most Appropriate Data Type
Adding Field Modifiers and Keys
Selecting a Table Type Altering Tables
Altering Table and Field Names
Altering Field Properties
Adding and Removing Fields and Keys
Altering Table Types
Backing Up and Restoring Databases and Tables
Backing Up Databases and Tables
Restoring Databases and Tables from Backup
Dropping Databases and Tables
Viewing Database, Table, and Field Information

SQL Queries (Module 10)

Inserting Records
Editing and Deleting Records
Performing Queries
Retrieving Specific Columns
Filtering Records with a WHERE Clause
Using Operators
Sorting Records and Eliminating Duplicates
Limiting Results
Using Built-In Functions
Grouping Records
Joining Tables
Using Subqueries
Using Table and Column Aliases

Arrays and Array Functions (Module 5)

Why use Arrays
Types of Arrays
Creating Arrays
Accessing Arrays
Array Functions
Using Array Functions

Sessions & Cookies (Module 6)

Why use Sessions
Creating Sessions
Checking Sessions
Destroying a Session
Sessions with Time
Authentication Program using Sessions
Why us Cookies
Creating Cookies
Storing data in Cookies
Retrieving Cookie Data
Authentication program with Cookies

Error Handling in PHP (Module 7)

Introduction to Error Handling
Types of Errors in PHP
Writing a Try Catch Block

MySQL Functions in PHP (Module 11)

Managing Database Connections
Performing Queries
Processing Result Sets
Queries Which Return Data
Queries That Alter Data

Validations with JavaScript (Module 12)

Basics of Java Script
Variables, operators, loops
Using Objects, Events
Java Script Validations

PHP Live Project (13)

Requirements analysis of Project
Project Planning
Project code Execution
Project Testing