Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/content/77/8880177/html/ipartner/db.php on line 2
PHP and MySQL Training -iPartner

PHP and MySQL Training

  1. PHP and MySQL Training
16 hr / 510*
(* including all taxes.)

Key Features

Course Agenda

  • PHP Introduction
  • PHP Installation
  • Web Concepts
  • Script Syntax
  • Declaring Variables and Data Types
  • Strings
  • Constants
  • Operators
  • Decision making statements
  • Loop Types
  • Arrays
  • PHP File Handling
  • PHP Error Handling
  • PHP Exception Handling
  • PHP Functions
  • PHP Built-in Functions
  • PHP User-defined Functions
  • PHP File Inclusion
  • Regular Expression
  • Meta Characters
  • Quantifiers
  • Modifiers
  • Special Sequences
  • PCRE methods preg_match(), preg_match_all(), preg_replace() and preg_split()
  • PHP Mails
  • Object oriented concepts
  • Classes and objects
  • Member variables and functions
  • Constructor and destructor
  • Inheritance
  • Function overriding
  • Access specifiers (Public, protected and private)
  • Abstract classes
  • Interfaces
  • Constants
  • Scope resolution operator (::)
  • Static keyword
  • Final keyword

  • Introduction to MySQL
  • MySQL Administration
  • MySQL Database
  • MySQL Data Types
  • MySQL Table
  • MySQL Query
  • MySQL Constraints
  • MySQL WHERE Clause
  • MySQL BETWEEN Operator
  • MySQL LIKE Operator
  • MySQL IN Operator
  • MySQL Sorting
  • MySQL Joins
  • Handling NULL Values
  • Regular Expressions
  • MySQL Transactions
  • MySQL Indexes
  • MySQL Temporary Tables
  • MySQL Clone Tables
  • Database Information
  • MySQL Sequences
  • MySQL Handling Duplicates
  • MySQL Injections

  • Introduction to MVC
  • What are Model-View-Controller
  • Advantages of MVC
  • Why use framework in the project (conventional vsmvc project)
  • Installation of CakePHP
  • CakePHP Folder Structure
  • File Naming Conventions
  • Important config files
  • Application flow
  • How View and Controller exchange data?
  • Introduction to CakePHP helpers
  • Common Helpers like Form, Cookies, HTML and Sessions
  • Controller Creation
  • URL Mapping to Controller and Views
  • Views and Layout Creation
  • Annie’s Quizzes, Q&A session and Quick Summary
  • Introduction to Models
  • Models interaction with database
  • Access and Manipulate table data using Find, Update and Save
  • Table Joins
  • Conditions and conditions other than =(LIKE, BETWEEN,), Order by
  • Dynamic Changing of database using definitions in database.phpconfig file
  • Annie’s Quizzes, Q&A session and Quick Summary
  • Basic Html form, get and post methods
  • Form elements generation like Input boxes, Link Dropdowns, Radio buttons using CakePHP Html Helper
  • Validation of Form using Model Validation Definitions
  • Create, Retrieve and Delete Cookies
  • Create, Retrieve and Delete Session Variables
  • Handling Files (Create, Delete and Read files)
  • Implementation of Global variables
  • Annie’s Quizzes, Q&A session and Quick Summary
    • Project 1:

      The main aim of this project is to create an HTML Registration Form using CakePHP helpers. Perform data posting and finally send an email

    • Project 2:

      Develop a website using CakePHP helpers that will cover details about Institutions, Courses available and Student Information using

    • Creating the website layout
    • Perform functions Add/View/Edit/Delete on Institute details
    • Perform functions Add/View/Edit/Delete on Course details
    • Perform functions Add/View/Edit/Delete on Student information

  • Client/Server Concepts
  • Database and Database Objects
  • Databases
  • Data Types
  • Tables
  • Constraints and Indexes
  • Views
  • Recurring SQL Constructs
  • Adding data
  • Modifying data
  • Removing data
  • Searching data
  • Expressions
  • Grouping and Aggregate Functions
  • Joining Tables
  • Transaction Concepts
  • SQL for working with Transaction
  • Tools for Import/Export
  • SQL for Import/Export

Learn & Get

  • Understand the basics of PHP, its Architecture and Mysql App Market
  • Gain in-depth understating of how PHP components, Application Lifecycle Resources
  • Learn how to create various Layouts and Menus in PHP
  • Create Applications using SQLite Database
  • Developing data storage, Creating Content Provider, Google Maps API V2, Multimedia and Animation, App Exporting
  • 70% of extensive learning through Hands-on exercises , Project Work , Assignments and Quizzes

Payment Method

You need to pay through PayPal. We accept both Debit and Credit Card for transaction.
We subsidize our fees by 10% for military personnel, and college students with exceptional records. To apply for a scholarship, email
In our iPartner self-paced training program, you will receive the training assessments, recorded sessions, course materials, Quizzes, related softwares and assignments. The courses are designed in such a way that you will the get real world exposure; the solid understanding of every concept that allows you to get the most from the online training experience and you will be able to apply the information and skills in the workplace. After the successful completion of your training program, you can take quizzes which enable you to check your level of knowledge and also enables you to clear your relevant certification at higher marks/grade where you will be able to work on the technologies independently.
In Self-paced courses, the learners are able to conduct hands-on exercises and produce learning deliverables entirely on their own at any convenient time without a facilitator whereas in the Online training courses, a facilitator will be available for answering queries at a specific time to be dedicated for learning. During your self-paced learning, you can learn more effectively when you interact with the content that is presented and a great way to facilitate this is through review questions and quizzes that strengthen key concepts. In case if you face any unexpected challenges while learning, we will arrange a live class with our trainer.
All Courses from iPartner are highly interactive to provide good exposure to learners and gives them a real time experience. You can learn only at a time where there are no distractions, which leads to effective learning. The costs of self-paced training are 75% cheaper than the online training. You will offer lifetime access hence you can refer it anytime during your project work or job.
Yes, at the top of the page of course details you can see sample videos.
As soon as you enroll to the course, your LMS (The Learning Management System) Access will be Functional. You will immediately get access to our course content in the form of a complete set of previous class recordings, PPTs, PDFs, assignments and access to our 24*7 support team. You can start learning right away.
24/7 access to video tutorials and Email Support along with online interactive session support with trainer for issue resolving.
Yes, You can pay difference amount between Online training and Self-paced course and you can be enrolled in next online training batch.
Please send an email. You can join our Live chat for instant solution.
We will provide you the links of the software to download which are open source and for proprietary tools, we will provide you the trail version if available.
You will have to work on a training project towards the end of the course. This will help you understand how the different components of courses are related to each other.
Classes are conducted via LIVE Video Streaming, where you get a chance to meet the instructor by speaking, chatting and sharing your screen. You will always have the access to videos and PPT. This would give you a clear insight about how the classes are conducted, quality of instructors and the level of Interaction in the class.
Yes, we do keep launching multiple offers that best suits your needs. Please email us at: and we will get back to you with exciting offers.
We will help you with the issue and doubts regarding the course. You can attempt the quiz again.
Sure! Your feedbacks are greatly appreciated. Please connect with us on the email support -