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.

Duration
16+ Hours
Institution
Open Source
Language
English
Video Script
English

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

Syllabus

International industry expertise at your disposal as you deep-dive into the research topic and sector of your choice.

Course Content

PHP Introduction (8 Lectures)

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

PHP Functions (8 Lectures)

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

OOP Concepts (12 Lectures)

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

MVC Architecture CakePHP (5 Lectures)

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

Deep dive into CakePHP (3 Lectures)

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

CakePHP Dynamic Forms Creation (9 Lectures)

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

Introduction to MySQL (3 Lectures)

Understanding MySQL open source database

Play

The client and server concepts

Play

Working with database objects

Play

Working with MySQL (6 Lectures)

Understanding MySQL

Play

Open source database capabilities

Play

MySQL administration

Play

Data types

Play

Tables and queries

Play

Installation of MySQL

Play

Data Manipulation & Advance Queries (8 Lectures)

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

SQL Data Manipulation (5 Lectures)

Deploying SQL for data manipulation

Play

Searching, adding

Play

Removing

Play

Modifying and deleting data

Play

Querying recurring data

Play

Advanced Data Manipulation (2 Lectures)

Working with advanced concepts of joining tables

Play

Grouping and aggregating functions and expressions

Play

SQL Transactions (3 Lectures)

Sequence or unit of work done in logical manner

Play

Understanding the concepts of Transactions

Play

Studying the ACID properties of Transactions

Play

SQL Import and Export (3 Lectures)

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 Interaction (8 Lectures)

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.

Enquiry

Training Options

Self-paced 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

Enquiry Now
  • 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

Frequently Asked Questions

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