PHP with MySQL

Objectives
  • Understand, develop and execute programming and scripting related tasks, and performance. Skills that effect PHP Developer salaries

  • A Successful PHP developer must have a good understanding of various client side Scripting languages like HTML, CSS, JavaScript etc.

  • A database is just what the name suggests, it is collection of Data Resources and Information. PHP developer must have the basic knowledge of of database and the methodologies to integrate PHP with different database management tools like MySQL Postgresql, MongoDB, Oracle etc.

  • Many MNC’s are working on PHP based websites/application for rapid growth in web/app development

  • In today’s market of web development half of the websites are developed using PHP development tools which indicates the popularity and future scope of PHP development

  • PHP follows many OOPS Concepts so as a PHP developer one should know the OOPS Concepts and how to use them.

  • PHP developer will gain sufficient knowledge framework.

Pre-requisites
  • C Language

  • Client-side Scripting (HTML, JS, CSS)

  • Database Concepts

Course Content

Module 1: Introduction

Introduction to www, History

Understanding client/server roles

Apache, PHP, MySQL, XAMPP Installation

 

Module 2: PHP Fundamentals

PHP Basic syntax, PHP data Types, PHP Variables

PHP Constants, PHP Expressions, PHP Operators

PHP Control Structures, PHP Loops

 

Module 3: PHP Arrays

PHP Arrays, PHP Associative Arrays

Array Iteration

PHP Multi-Dimensional Arrays

Array Functions

 

Module 4: PHP Functions

PHP Functions, Syntax, Arguments, Variables

References, Pass by Value & Pass by References

Return Values, Variable Scope, PHP include(), PHP require()

 

Module 5: PHP Forms

PHP Form handling, PHP GET, PHP POST, PHP Form Validation, PHP Form

 

Module 6: PHP Cookies & PHP Sessions

PHP Cookie handling, PHP Session Handling, PHP Login Session

 

Module 7: PHP Strings Handling

String Functions

 

Module 8:Javascript Implementation

Introduction to Javascript.

Function

Form/Client-Side validation

 

Module 9 :Jquery Implementation

Introduction to JQuery

Validation using JQuery

JQuery Forms

JQuery Examples

 

Module 10 :AJAX Implementation

Introduction to AJAX

PHP with AJAX

 

Module 11:Working with Database MySQL, Simple SQL Queries

PHP Data Object (PDO)

Insert, Select, Update, Delete data

Joining and Functions

ER diagram and Data flow diagram of case study

 

Module 12 : Advanced SQL query building

WHERE condition, Order By, Group By, Having, LIKE, AND OR operators

 

Module 13: SQL Functions

Using SQL functions AVG, COUNT, SUM, MIN, MAX

 

Module 14 :Introduction to OOPS

Declaring Class, Constructor

Access method and properties using $this variable

Public ,private, protected properties and methods

Static properties and method

Inheritance & Polymorphism

 

Module 15 :Exception Handling

Understanding Exception and error

Try, catch, throw

 

Module 16: File Handling

Open/Close, Read/Write, File Upload

 

Module 17: Introduction to MVC

MVC Architecture Concepts

Handling Database using Models

Defining Routes

Understanding MVC with Laravel

 

Module 20: Project Work 

Quick Enroll
100% Placement Assistance
Top