PROGRAMMING LANGUAGE (PHP-MySQL)

Course Description:

The contents of this course are a comprehensive solution that moulds you to a PHP specialist by providing a combination of on hand labs and the training provided in the class. It helps the trainee to learn and develop various php technology applications that definitely meets the current industry needs.

Section 1: PHP – Understanding the Preliminaries.

  • Introduction to web & internet
  • Introduction to server
  • Understanding localhost server
  • Starting PHP
  • PHP syntax and variables
  • Operators and Expressions
  • Conditional Branching and Looping Statements
  • Learning Arrays in PHP 

Section 2: PHP - The Core Logics and Techniques.

  • String and Math functions in PHP
  • Introduction HTML Form Elements and Fields
  •  Accessing PHP, HTTP Data
  • Query Strings and Hyperlinks
  • Describing Pre-Defined Variables - Super Global Arrays
  • Understanding Functions, Important PHP Functions
  • What are the Scope of variables
  • Usage of Include and require statements 

Section 3: PHP – File Handling. The Plain Repository of Data

  • Handling files and directories in PHP
  • Fetching information from files
  • Uploading and downloading files 

Section 4: PHP and MySQL - The Structured Repository

  • PHP MySQL Connectivity
  • Integrating Web Forms and Database
  • Using PHP’s MySQL Extension
  • Using PHP’s PDO Extension 

Section 5: Learn More Advanced Techniques in PHP

  • Introduction to Object Oriented Programming
  • Classes and Objects
  • Abstraction, Encapsulation, Inheritance and Polymorphism
  • Constructors and Destructors
  • Overloading, Overriding of functions
  •  Exception Handling
  • Regular Expressions
  • Session Handling
  • Using Cookies 

Section 6: Working with XML and JSON

  • Introduction to XML
  • How to Integrate PHP and XML
  •  Introduction to JSON
  •  Building a Sample Web Application 

MySQL

Section 1: Relational Database Basics

  • Brief History of MySQL
  • Relational Databases and Popular Databases
  • SQL Statements 

Section 2: Data Manipulation Language (DML)

  • INSERT
  • UPDATE
  • DELETE
  • SELECT 

Section3: Data Definition Language (DDL)

  • CREATE
  • ALTER
  • DROP 

Section4: Sub-Queries, Joins and Unions with MySQL

  • Order By, Like , And & Or, Where , Between
  • Joins & Unions
  • Aggregate Functions and Grouping 

Section 5: Constraints and Normalization

  • Understanding Primary and Foreign Keys
  • Understanding Database Normalization
  • Views and Triggers