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.
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.
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
Reach Us
Useful Links
Company
-
B-115, Sector-2, Noida, Uttar Pradesh - 201301
-
+91-1204229536
-
info@wissenhive.com
Disclaimer
- ITIL® is a [registered] trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
- IT Infrastructure Library is a [registered] trade mark of AXELOS Limited used, under permission of AXELOS Limited. All rights reserved.
- The Swirl logo™ is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
- The Swirl logo™ is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
- MSP® is a [registered] trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.