PHP and MySQL Online Training | PHP Certification Course | Edureka

PHP & MySQL with MVC Frameworks Certification Training

Become an Edureka 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.


Watch the demo class

Why should you take PHP & MySQL with MVC Frameworks course ?

  • 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)
  • 2K + satisfied learners. Reviews

Online self - paced learning

Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You'll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.
9999
EMI Option availableGive us a call at +91 98702 76459

Edureka For Business

Train your employees with exclusive batches and offers and track your employee's progress with our weekly progress report.

Learning Objectives - In this module, we will understand what PHP &MySQL is and why it is so popular. You will learn PHP basics, installation setup, data types, arrays and decision making statements.

Topics - PHP introduction, Environment setup in different platforms, Script syntax, How to declare variable and data types, Constants, Arrays, Strings, Web concepts, Decision making statements, loop types, operators, Annie’s Quizzes, LAB, Q & A and Quick Recap.

Learning Objectives - In this module, we will learn about the functions. Next, we will learn about how to send mails using PHP. In addition, we will learn regular expressions, predefined functions and its uses. We will also understand how to manipulate with system files, error handling and debugging. 

Topics - What is Functions , Creating PHP functions, PHP functions with parameters, Argument by reference, setting default values for function parameters, dynamic function calls, PHP mails, how to send text mail, how to send html emails , how to send attachments with emails, regular expressions, POSIX regular expressions, predefined character ranges, Regexp POSIX functions, PERL style regular expressions, Regexp PERL compatible functions, Date and time functions,Built-in functions, file inclusion, file manipulations, exception handling, bugs debugging, Annie’s Quizzes, LAB, Q & A and Quick Recap.

Learning Objectives - In this module, we will learn how to define classes, how to create object for the class and how to invoke methods and functions. Next, we will learn the object oriented functionalities like inheritance, method overriding, interfaces, constants, Access Specifiers and abstract classes.

Topics - What is Object Oriented Concepts, Defining  classes, Creating Objects, Member functions, Constructor and Destructor, Inheritance, Function overriding, Access Specifiers- private, public and protected members, Interfaces, Constants, Abstract Classes, Static keyword, Final keyword, calling parent constructors, Annie’s Quizzes, LAB, Q & A and Quick Recap.

Learning Objectives - In this Module, We will discuss what is database and database terminology. Then we will see how to install MySQL in our system. We will see how to connect with MySQL. Then we will discuss about syntax, database creation and create tables inside database and database manipulations like add, edit, and delete. 

Topics - Database Introduction, MySQL installation on various platforms, MySQL connection, Database creation, Database Manipulations- Add, Edit, Retrieve and Delete. Table creation and table manipulations- Add Edit, Retrieve and Delete Annie’s Quizzes, LAB, Q & A and Quick Recap.

Learning Objectives - In this module, we will learn advanced queries and SQL injection concepts. We will discuss about Like clause, how to sort values, how to fetch using joins, how to handle NULL values, Regular expressions, Transactions and alter command. We will also discuss Indexes of the table, temporary tables and clone tables. Then we will see duplicate tables and SQL Injection. We will learn how to retrieve and manipulate data using PHP.

Topics- LIKE clause, Sorting, Joins, Handling NULL Values, Regular Expressions, Transactions, ALTER Command, Indexes, Temporary Tables, Clone Tables, Database, Information, Sequences, Handling Duplicates, SQL Injections, Select, insert, update and delete using PHP script, Annie’s Quizzes, Q & A,Quick Recap.

Learning Objectives - In this module we will learn the MVC terminology, advantages of MVC. We will learn how to install and configure CakePHP on top of existing PHP apache web server we will also see CakePHP folder structure and important configuration.

Topics - Introduction to MVC, What are Model-View-Controller, Why use framework in the project (conventional vs. MVC project), Installation of CakePHP, CakePHP folder structure, File naming conventions, Important config file (core.php, database.php), Annie’s Quizzes, Q & A, Quick Recap.

Learning Objectives - In this module we will learn how to create controllers and views. We will learn how URLs are mapped to the controllers and views. We will learn how the controller and view interacts and exchanges data between them.


Topics - Application flow - How Controller and view interacts/ exchanges data, What are CakePHP helpers?, Most commonly used helpers like Form, HTML, Session, Cookie etc, Create a controller and how URLs mapped to controller and views, Create views and layouts, Annie’s Quizzes, Q & A, Quick Recap.

Learning Objectives - In this module we will learn models in detail. How to define models, use it for database access and manipulation. How to use basic SQL queries in models.


Topics - Models: What are models and how they interact with database?, Accessing and manipulating table data using find, save, update methods of the model, Joining tables, conditions, conditions other than =(LIKE, BETWEEN,), order by in CakePHP models, Change database dynamically using the definitions in database.php config file, Annie’s Quizzes, Q & A, Quick Recap.

Learning Objectives - In this module, we will learn about how to generate forms using CakePHP html helper, validate forms using model definitions, difference between get and post methods, cookies , uses of cookies, how to set and retrieve cookies, what is sessions, how to start and destroy sessions, automatically start sessions and use sessions without cookies, file uploading and predefined variables. 

Topics - Introduction to basic html form, get, post methods, Generate form elements like input boxes, dropdowns, radio buttons, and links using CakePHP html helper, Form validation using Model validation definitions, Create, retrieve and delete cookies, Create, retrieve and delete session variables, File handling in CakePHP (create, delete, read files), CakePHP Global variables and their use, Annie’s Quizzes, Q & A, Quick Recap

Learning Objectives - In this module we will see some other frameworks available in PHP like Zend, CodeIgniter, Laravel. We will see the comparison between the frameworks. We will also discuss the project details.

Topics -

Project 1: Create basic HTML registration form using CakePHP helpers. Post data to database and send an email

Project 2: The main aim of the project is to develop an online website, which will cover details about institutes, courses and student information using CakePHP

1. Create a basic layout for the website.

2. Add/Edit/View/Delete institute details

3. Add/Edit/View/Delete course details

4. Add/Edit/View/Delete student information

. Call a Course Adviser for discussing Curriculum Details . 1844 230 6365

Edureka's 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.

After the completion of the 'PHP & MySQL with MVC Framework' Course at Edureka, you should be able to:

1. Understand the basics of the Web Technology

2. Learn all major concepts of PHP and MySQL that beginner developers need to master.

3. Learn all major concepts of MVC architecture in general and it advantages over conventional web development methods. 

3. Round off your application development skills by understanding how to implement PHP on a website using MVC framework.

4. Gain the PHP programming skills needed to successfully build interactive, data-driven sites

5. Create forms easily using helper functions and work with form data

6. Use cookies and sessions with helper functions

7. Work with regular expressions, handle exceptions, and validate data

8. Work with PHP text mails and HTML emails

9. How to use and create functions

10. Object oriented concepts

11. Uploading files to server

12. Manipulate system files

13. Able to architect, write, debug, and run complete web applications

14. Test and debug a PHP application

15. Become a proficient PHP/MySQL web developer using MVC architecture.

PHP scripting and MySQL database are one of the worlds most popular open source techniques used to develop websites. Add an advantage of a MVC framework to it and you can develop powerful, dynamic and easy to maintain database driven websites. PHP, MySQL and CakePHP are also platform independent i.e. You can easily port a website developed on a windows machine to a Linux based apache web server with minimal to no changes. The CakePHP MVC architect also adds  some additional security against threats like SQL injections, hacking etc.

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

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

The system requirements include Windows / Mac / Linux PC, minimum 4GB RAM, 20 GB HDD Storage and processor, i3 or above.
For your practical work the required installation guide is present in LMS. You can use this documents to do your practicals.

Project: (i) Create basic HTML registration form using CakePHP helpers. Post data to database and send an email. (ii) Institution management website.

Course Duration

You will undergo self-paced learning where you will get an in-depth knowledge of various concepts that will be covered in the course.

Real-life Case Studies

Towards the end of the course, you will be working on a project where you are expected to implement the techniques learnt during the course.

Assignments

Each module will contain practical assignments, which can be completed before going to next module.

Lifetime Access

You will get lifetime access to all the videos,discussion forum and other learning contents inside the Learning Management System.

Certification

edureka certifies you as a expert in PHP based on the project reviewed by our expert panel.

Forum

We have a community forum for all our customers that further facilitates learning through peer interaction and knowledge sharing.
As soon as you enrol into 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 Videos, PPTs, PDFs and Assignments. You can start learning right away.
To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the "create your resume" option.
You can pay by Credit Card, Debit Card or NetBanking from all the leading banks. We use a CCAvenue Payment Gateway. For USD payment, you can pay by Paypal. We also have EMI options available.
You can give us a CALL at +91 98702 76459/1844 230 6365 (US Tollfree Number) OR email at sales@edureka.co
You no longer need a credit history or a credit card to purchase this course. Using ZestMoney, we allow you to complete your payment with a EMI plan that best suits you. It's a simple 3 step procedure:
  • Fill your profile: Complete your profile with Aadhaar, PAN and employment details.
  • Verify your account: Get your account verified using netbanking, ekyc or uploading documents
  • Activate your loan: Setup automatic repayment using NACH to activate your loan

  • Once you are successfully through the project (Reviewed by a edureka expert), you will be awarded with edureka’s PHP Developer certificate.
  • edureka certification has industry recognition and we are the preferred training partner for many MNCs e.g.Cisco, Ford, Mphasis, Nokia, Wipro, Accenture, IBM, Philips, Citi, Ford, Mindtree, BNYMellon etc. Please be assured.

user

PHP & MySQL with MVC Frameworks Certification Training