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 SyllabusWissenhive 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.
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
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 |
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.
Pre-requisites
Basic HTML knowledge, basic understanding of computer programming language, internet, database, especially RDBMS.
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.
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