PHP Mysql Training in Dehradun

PHP & MySQL Training

PHP stands for Hypertext Preprocessor. It is a server side technology like ASP. Unlike HTML, PHP needs server to run. You can freely download this software from the internet. It is open source software; you can easily customize this software according to your requirement. There are lots of plug-in available in the market that makes its development faster. Currently most of the sites are built in PHP rather than others technologies because of shorter time of development. There are a number of technologies that used PHP like Word Press, OS Commerce, Joomla, Magento etc. PHP supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.)

My SQL is an ORACLE product and usually used in PHP and JAVA. It is used to store, update, delete and retrieve data. It is very powerful software and used in big and small application. It is a free software. MySQL is also used in large application including , Google and Facebook. MySQL is very flexible and its performance is very high.

Course Outline

Overview of the PHP

Introduction of different Web Technology
Introduction of PHP
PHP Architecture
Popular code editors

Setting up and Installing PHP

Installing Apache http server
Installation of PHP
Introduction, History, Web Brower, Web Server, Xampp, Installation and Configuration files.

HTML, CSS & JavaScript

Basic of HTML, CSS and JavaScript

PHP Language and Syntax fundamentals

Language conventions
Variables & Data Types
Constants

Data-driven functionality

Superglobals
HTTP Request / Response cycle
Forms and User Input
Control Structures
- If, Else, If-Else
- While, Do-while
- For
Creating Functions
Using Parameters
Closures
Strings & Strings Manipulations
Arrays
Iterating
Array Indexing
Array Content

Introduction to Object Oriented programming in PHP

Reusability of code
Overview of Objects & Classes
Namespaces
Encapsulation
Inheritance
Autoloading
Closures in an OO context

Connecting to Databases

Data Source Names (DSN)
PHP Data Objects (PDO)
SQL querying with PDO
Sanitizing data and binding parameters
Displaying the results
Exiting gracefully

Exception Handling

Creating a custom exception handler
Terminating Statements
Reporting

Sessions, Cookies and Authentication

Authenticating against a database
Password hashing and security
Working with sessions
Persisting authentication with Cookies

Components and Packages

Introduction to Composer
Importing packages from Packagist
Composer autoloading

Overview of MY SQL

Installation of MY SQL
Introduction about Database, Data Types, DML, DDL, Aggregate functions, Data Time functions, Stored Procedure, Sub query and join
MySQL Introduction
MySQL Connect
MySQL Create
MySQL Insert
MySQL Select
MySQL Where
MySQL Order By
MySQL Update
MySQL Delete

Javascript Validation

Required Field Validator Control
Regular Expression Validator Control
Compare Field Validator Control
Range Validator Control
Validation Summary Control
Custom Validator Control

AJAX (Asynchronous JavaScript and XML)

About Ajax
Setting up and implementing Ajax
PHP and AJAX
AJAX Intro
AJAX PHP
AJAX Database
AJAX XML
AJAX Live Search
AJAX RSS Reader
AJAX Poll

Working with web services

Encoding and decoding JSON
Making HTTP requests

Live Project

Project
Project Case Study

PHP & MySQL

PHP & MySQL Training

Course Outline

Web Training

Core Skills & Expertise

Mobile Development

Course Registration

About Us