PHP and MySQL

4.1 (3521) 4700 Learners

Become an Wissenhive certified PHP & MySQL Professional. An online course designed to make you an expert in using PHP & MySQL and learn all that is required to create real world web applications with PHP & MySQL.

Download Syllabus

Overview

Wissenhive PHP & MySQL with MVC framework, will introduce attendees to PHP, MySQL and CakePHP MVC framework. The course will cover aspects of how to use PHP, MySQL along with CakePHP MVC framework to create powerful and easy to maintain database driven websites. The course will also cover Installation & Configuration of PHP, MySQL and CakePHP. Attendees will also get to implement one project towards the end of the course.

What you will learn

  • The major concepts of Web Technology
  • To build web applications using PHP on MVC Framework
  • To build interactive, data-driven sites
  • To create forms using helper functions and work with form data
  • To use arrays and hashes and SQL syntax
  • Work with cookies and email
  • Implement security strategies while developing applications
  • Write code that is clean, iterative and can be reused
  • Testing strategies to debug and make application error free

Benefits

Why should you take PHP & MySQL with MVC Frameworks?

This course will give you the required training to build powerful web based applications that are feature and functionality rich, using PHP and MySQL with MVC Framework. Any framework makes software development easier and the MVC framework gives more control and better testability to the developer. You will learn to harness the power of the open source PHP language as well as MySQL by learning about CakePHP, its views and layout and the various interactions with the database. This is a great course for those who want to make a career in web development

 

  • PHP has its own community on web with more than 20 million websites.
  • Accenture, Rackspace, Tesla, Nokia, Zynga & many other MNC's worldwide use PHP and MySQL across industries.
  • Average salary of PHP and MySQL is $70k (Indeed.com Salary Data)

Course Content

Introduction to PHP Play
Installation of PHP Play
Understanding the concepts Play
Learning about the various data types Play
Script syntax and variable declaration Play
Working with operators Play
Constants Play
Loop types and decision-making statements Play
Learning about the Regular Expressions, File Inclusion, working with Quantifiers, Modifiers, learning to deploy various Regular Expressions in PHP like preg_filter, preg_match, preg_split, understanding Escape Sequences. Play
File Inclusion Play
Working with Quantifiers Play
Modifiers Play
Preg_filter Play
Preg_match Play
Preg_split Play
Understanding Escape Sequences Play
Introduction to Object Oriented Programming Play
Learning about the various functions Play
Variables Play
Classes and objects Play
Deploying Function overriding Play
Core OOP concepts Play
Polymorphism Play
Encapsulation Play
Inheritance and abstraction Play
Working with access modifiers Play
Scope resolution operator Play
Constructors and destructors Play
Understanding the basics of Model-View-Controller Architecture Play
Its significance and deployment Play
Introduction to CakePHP – open source rapid development framework for PHP Play
Understanding the CakePHP conventions Play
Folder structures and important concepts Play
The MVC layers in CakePHP Play
Understanding the flow of data between the View and Controller Layers Play
Deploying CakePHP helpers – HTML, cookies, sessions, forms, learning to design layouts, map URLs, and creation of controller Play
Creation of basic HTML form Play
Deploying CakePHP helpers to come up with various components of forms like radio buttons Play
Input boxes Play
Dropdown link Play
Form validation using data validation rules Play
Understanding creation Play
Retrieval and deletion of sessions variables Play
Cookies and file handling Play
Deploying global variables Play
Understanding MySQL open source database Play
The client and server concepts Play
Working with database objects Play
Understanding MySQL Play
Open source database capabilities Play
MySQL administration Play
Data types Play
Tables and queries Play
Installation of MySQL Play
Understanding how MySQL can be deployed for data manipulation and coming up with advanced queries Play
Learning to deploy MySQL Constraints Play
MySQL ALTER TABLE Command Play
Working with MySQL IN Operator Play
MySQL Sorting Play
MySQL Joins Play
Understanding MySQL Sequences Play
MySQL Injections Play
Deploying SQL for data manipulation Play
Searching, adding Play
Removing Play
Modifying and deleting data Play
Querying recurring data Play
Working with advanced concepts of joining tables Play
Grouping and aggregating functions and expressions Play
Sequence or unit of work done in logical manner Play
Understanding the concepts of Transactions Play
Studying the ACID properties of Transactions Play
Working with data to move it from source to destination Play
Creation of destination database Play
File and table using SQL Import/Export Play
CakePHP database access layers Play
Keeping connection with database Play
Building queries Play
Working with data schemas Play
Deploying Find Play
Update and Save for working with Table data Play
Understanding database Play
Phpconfig to work with databases Play

Course Details

PHP and MySQL are incredibly powerful open source technologies that allow people to create functional websites and apps that go way beyond basic HTML. While it can seem intimidating to someone with no background in coding, working with PHP is much easier than many realize. With the right guidance and a desire to learn, most people can learn how to put together a functional web app in a few days!

Who Should go for this course?

This course can be taken by anyone who wants to be a Web Developer or wants to learn PHP & MySQL.

  • UI Designers and HTML
  • Java Developers
  • Database Developers
  • Administrators

Pre-requisites

Basic HTML knowledge, basic understanding of computer programming language, internet, database, especially RDBMS.

Course Info.

Lenght
16+ Hours
Effort
2-3 Hours/week
Institution
Open Source
Language
English
Video Script
English

Training Options

Selfpaced Training

299
  • Lifetime access to high-quality self-paced eLearning content curated by industry experts
  • 3 simulation test papers for self-assessment
  • Lab access to practice live during sessions
  • 24x7 learner assistance and support

Live Virtual Classes

449
  • Online Classroom Flexi-Pass
  • Lifetime access 
  • Practice lab and projects with integrated Azure labs
  • Access to Microsoft official content aligned to examination

One on One Training

999
  • Customized learning delivery model (self-paced and/or instructor-led)
  • Flexible pricing options
  • Enterprise grade learning management system (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Exam & Certification

No Exam Required.

you will be required to complete a project which will be assesd by our certified instructors. on succesful completion of the project you will be awarded a training certificate.

PHP and MySQL

FAQs

Basic knowledge of an RDBMS, HTML and of the internet is required.

This course is apt for professionals who want to strengthen their concepts of PHP & MySQL with a MVC framework or those who want to make a career in Web development