PHP MySQL Training

Free
View cart
PHP MySQL Training

About SimplyAnalytics

We are the best Training institute for learning PHP MySQL Training in Chennai . We have expert trainers and excellent materials to transform your skills to fit into the job market .

Module 1 : Basics of PHP and Conditional Logic

  • 1. PHP Introduction
  • 2. PHP Installation
  • 3. Web Concepts
  • 4. Script Syntax
  • 5. Declaring Variables and Data Types
  • 6. Strings
  • 7. Constants
  • 8. Operators
  • 9. Decision making statements
  • 10. Loop Types
  • 11. Arrays

Module 2 : Functions and Error Handling

  • 1. PHP File Handling
  • 2. PHP Error Handling
  • 3. PHP Exception Handling
  • 4. PHP Functions
  • 5. PHP Built-in Functions
  • 6. PHP User-defined Functions
  • 7. PHP File Inclusion
  • 8. Regular Expression
  • 9. Meta Characters
  • 10. Quantifiers
  • 11. Modifiers
  • 12. Special Sequences
  • 13. PCRE methods preg_match(), preg_match_all(), preg_replace() and preg_split()
  • 14. PHP Mails

Module 3 : Object Oriented Programming Concepts

  • 1. Object oriented concepts
  • 2. Classes and objects
  • 3. Member variables and functions
  • 4. Constructor and destructor
  • 5. Inheritance
  • 6. Function overriding
  • 7. Access specifiers (Public, protected and private)
  • 8. Abstract classes
  • 9. Interfaces
  • 10. Constants
  • 11. Scope resolution operator (::)
  • 12. Static keyword
  • 13. Final keyword

Module 4 : Installation and Introduction of MySQL

  • 1. Introduction to MySQL
  • 2. MySQL Administration
  • 3. MySQL Database
  • 4. MySQL Data Types
  • 5. MySQL Table
  • 6. MySQL Query

Module 5 : Advance Queries and Data Manipulation using PHP

  • 1. MySQL Constraints
  • 2. MySQL ALTER TABLE Command
  • 3. MySQL WHERE Clause
  • 4. MySQL BETWEEN Operator
  • 5. MySQL LIKE Operator
  • 6. MySQL IN Operator
  • 7. MySQL Sorting
  • 8. MySQL Joins
  • 9. Handling NULL Values
  • 10. Regular Expressions
  • 11. MySQL Transactions
  • 12. MySQL Indexes
  • 13. MySQL Temporary Tables
  • 14. MySQL Clone Tables
  • 15. Database Information
  • 16. MySQL Sequences
  • 17. MySQL Handling Duplicates
  • 18. MySQL Injections

Module 6 : MVC Infrastructure and Introduction to CakePHP

  • 1. Introduction to MVC
  • 2. What are Model-View- Controller
  • 3. Advantages of MVC
  • 4. Why use framework in the project (conventional vsmvc project)
  • 5. Installation of CakePHP
  • 6. CakePHP Folder Structure
  • 7. File Naming Conventions
  • 8. Important config files

Module 7 : CakePHP Controller, Layout and Views

  • 1. Application flow
  • 2. How View and Controller exchange data?
  • 3. Introduction to CakePHP helpers
  • 4. Common Helpers like Form, Cookies, HTML and Sessions
  • 5. Controller Creation
  • 6. URL Mapping to Controller and Views
  • 7. Views and Layout Creation

Module 8 : Introduction to Models and Database Interaction in CakePHP

  • 1. Introduction to Models
  • 2. Models interaction with database
  • 3. Access and Manipulate table data using Find, Update and Save
  • 4. Table Joins
  • 5. Conditions and conditions other than =(LIKE, BETWEEN,), Order by
  • 6. Dynamic Changing of database using definitions in database.phpconfig file

Module 9 : Dynamic Forms Creation using CakePHP Html Helpers

  • 1. Basic Html form, get and post methods
  • 2. Form elements generation like Input boxes, Link Dropdowns, Radio buttons using CakePHP
  • 3. Html Helper
  • 4. Validation of Form using Model Validation Definitions
  • 5. Create, Retrieve and Delete Cookies
  • 6. Create, Retrieve and Delete Session Variables
  • 7. Handling Files (Create, Delete and Read files)
  • 8. Implementation of Global variables

Module 10 : MVC and CakePHP to develop a website

Project 1: The main aim of this project is to create an HTML Registration Form using
  • CakePHP helpers. Perform data posting and finally send an email
Project 2: Develop a website using CakePHP helpers that will cover details about
  • 1. Institutions, Courses available and Student Information using
  • 2. Creating the website layout
  • 3. Perform functions Add/View/Edit/Delete on Institute details
  • 4. Perform functions Add/View/Edit/Delete on Course details
  • 5. Perform functions Add/View/Edit/Delete on Student information

MySQL

Module 1 : Theory, Terminology and Concepts

  • 1. Client/Server Concepts
  • 2. Database and Database Objects

Module 2 : Data Definition using SQL

  • 1. Databases
  • 2. Data Types
  • 3. Tables
  • 4. Constraints and Indexes
  • 5. Views

Module 3 : Basic Data Manipulation using SQL

  • 1. Recurring SQL Constructs
  • 2. Adding data
  • 3. Modifying data
  • 4. Removing data
  • 5. Searching data

Module 4 : Advanced Data Manipulation using SQL

  • 1. Expressions
  • 2. Grouping and Aggregate Functions
  • 3. Joining Tables

Module 5 : Transactions

  • 1. Transaction Concepts
  • 2. SQL for working with Transaction

Module 6 : Import/Export

  • 1. Tools for Import/Export
  • 2. SQL for Import/Export

Why choose SimplyAnalytics for PHP MySQL Training in Chennai?

  • 1. 100% Practical and placement oriented training.
    2. We are registered training organization.
    3. Expert trainers from IT industries.
    4. Placements Assistance.
    5. Flexible timings.
    6. Weekdays and weekend batches.
    7. Affordable fees.
    8. Air conditioned classroom.
    9. Wi-Fi enabled training institute.
    10. Best Lab specialities.

Are you located in any of these areas – Adambakkam, Camp Road, Chromepet, Ekkattuthangal, Guindy, kovilambakkam, Madipakkam, Medavakkam, Nanganallur, Navalur, Nungambakkam, OMR, Pallikaranai, Perungudi, Rajakilpakkam, Saidapet, Sholinganallur,Siruseri, St.Thomas Mount, T. Nagar, Tambaram, Tambaram East, Thiruvanmiyur, Thoraipakkam, Velachery, and West Mambalam.

Our Medavakkam office is just few kilometre away from your location. If you need the best PHP MySQL Training in Chennai travelling of extra kilometres is worth it .

Related Search Tags: PHP MySQL Training in Chennai, PHP MySQL  Training Institute in Chennai, PHP MySQL Course in Chennai, PHP MySQL Training, PHP MySQL Training in Chennai, PHP MySQL Training, PHP MySQL course, PHP MySQL courses, PHP MySQL Training in Chennai Medavakkam

Course Features

  • Lectures 1
  • Quizzes 1
  • Duration 50 hours
  • Skill level All level
  • Language English
  • Students 0
  • Assessments Self
Curriculum is empty