PHP with MySQL

Learn from basics to advanced web application development with PHP like its syntax, data types, operators, loops, functions. Also web objects, web forms, file handling, cookies and sessions. Creating MySQL database and basic queries. Connecting MySQL database to PHP and handling from PHP forms. Object oriented concepts in PHP.

Each student in our Live Online classes receives a comprehensive set of materials, including course notes and all the class examples.
  • Batch size up to 1 to 3.
  • Access to the trainer any time for any questions and follow-ups.
  • Online in-person training.
  • Every session is followed by practical assignments.
  • Numerous assignments carefully designed on every topic by our professional trainers.
  • Guidance from experienced and professional people in software industry.
  • Assignments evaluation, feedbacks and encouragements to develop in better way.
  • Focus on hands-on training by students during sessions.

Syllabus


Duration: Min 20 hours of classroom training.
Min 25 assignments.

Introduction
  • Introduction to web technology, web pages and Internet
  • PHP Installation
PHP Fundamentals
  • PHP Basic syntax, data Types, variables, Constants,
  • Expressions, Operators, Control Structures, Loops
String
  • Creating and accessing String
  • Searching & Replacing String
  • Formatting String
  • String Library functions
Array
  • Anatomy of an Array
  • Creating index based and Associative array
  • Accessing array Element
  • Looping with Index based array
  • Looping with associative array using each () and foreach()
  • Array Library functions
Function
  • What is a function?
  • Define a function
  • Call by value and Call by reference
  • Recursive function
Positioning
  • Relative positioning
  • Absolute positioning
  • Fixed positioning
  • Floating elements
PHP Forms
  • PHP Form handling
  • PHP GET
  • PHP POST
  • PHP Form Validation
PHP Cookies & PHP Sessions
  • PHP Cookie handling
  • PHP Session Handling
Working with file and Directories
  • Understanding file & directory
  • Opening and closing a file
  • Coping, renaming and deleting a file
  • Working with directories
  • Building a text editor
  • File Uploading & Downloading
Basic MySQL, Simple SQL queries
  • Database basics
  • PHP MyAdmin
  • Connect & Pconnect
  • MySQL Create, Insert, Select, Update, Delete, Truncate, Drop
Advanced SQL query building
  • WHERE condition, Order By
  • Group By, Having, LIKE AND OR operators
  • SQL functions AVG, COUNT, SUM, MIN, MAX, LCASE, UCASE
OOP with PHP
  • Create classes, understand constructors,
  • Inheritance, polymorphism
Learn to developed Web Applications with one of powerful, multiplatform supported scripting language and learn to handle the MySQL DBMS as backend. After successfully completing this training you can start career as web developer.