PHP Mysql With MVC Frameworks Certification Training

PHP & MySQL with MVC Frameworks Training

Become an OL Tech Edu 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.

PHP has its own community on web with more than 20 million websites.

Accenture, Rackspace, Tesla, Nokia, Zynga & other MNC's use PHP and MySQL across industries.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Php Mysql UpComing Batches

Nov-22 - Jan-03

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-04 - Jan-15

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-25 - Feb-05

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

PHP & MySQL with MVC Frameworks Certification

SELF PACED

Become an OL Tech Edu's 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.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Certified PHP And MySQL Professional

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.


Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Projects

Which case studies will be the part of this course?

Dream World International has recently done a SharePoint 2013 deployment to integrate and enhance its information technology base As a SharePoint developer, you have been assigned the following task:- The Sales department needs a master calendar control in its top level site which will consolidate all the individual events from all calendar apps used by any user in the sales department.

What are the system requirements for this course?

The system requirements include Windows / Mac / Linux PC, minimum 4GB RAM, 20 GB HDD Storage and processor, i3 or above.

How will I execute the practicals?

For your practical work the required installation guide is present in LMS. You can use this documents to do your practicals.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2021 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers