PHP and MySQL Training

• Introduction to PHP
• installation of PHP
• understanding the concepts
• learning about the various data types
• script syntax and variable declaration
• working with operators
• Constants
• loop types and decision-making statements

Hands-on Exercise 

• Install PHP development environment
• Create a basic PHP hello world program
• Write a program with for loop
• Use if statement
• Create variables and assign values, use constants

• The various functions in PHP including the in-built and user-defined ones
• 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.

Hands-on Exercise 

• Write a regex to search a string pattern, Use quantifiers ($, { }, ?, * etc)
• Use modifiers and grouping
• Deploy various Regular Expressions in PHP like preg_filter, preg_match, preg_split, and Use escape sequences

• Introduction to Object-Oriented Programming
• Learning about the various functions
• Variables
• Classes and objects
• Deploying Function overriding
• Core OOP concepts – polymorphism, encapsulation, inheritance, and abstraction
• Working with access modifiers
• Scope resolution operator
• Constructors and destructors

Hands-on Exercise 

• Create a class with member functions and variables
• Write constructor and destructor functions
• Instantiate an object of the class
• Implement function overriding
• Use access modifier
• Use scope resolution operator to static members of a class

• Understanding the basics of Model-View-Controller Architecture
• Its significance and deployment
• Introduction to CakePHP – open source rapid development framework for PHP
• Understanding the CakePHP conventions
• Folder structures and important concepts.

• The MVC layers in CakePHP, understanding the flow of data between the View and Controller Layers
• Deploying CakePHP helpers – HTML, cookies, sessions, forms
• Learning to design layouts
• Map URLs, 
• Creation of controller

Hands-on Exercise

• Deploy CakePHP helpers – HTML, cookies, sessions, forms
• Design a layout, Map URLs
• Create a controller

• Creation of basic HTML form
• Deploying CakePHP helpers to come up with various components of forms like radio buttons, input boxes, dropdown links, 
• Form validation using data validation rules
• Understanding creation
• Retrieval and deletion of sessions variables, cookies, and file handling
• Deploying global variables

Hands-on Exercise

• Create a basic HTML form
• Deploy CakePHP helpers to come up with various components of forms like radio buttons, input boxes, dropdown link
• Validate a form using data validation rules, Create, Retrieve and delete sessions variables
• Create cookies
• Deploy global variable

• Understanding MySQL open-source database
• The client and server concepts
• Working with database objects

• Understanding MySQL
• Open-source database capabilities
• MySQL administration
• Data types, tables, and queries
• Installation of MySQL.

Hands-on Exercise 

• Install MySQL
• Configure MySQL to create users and roles to interact with the database

• Understanding how MySQL can be deployed for data manipulation and coming up with advanced queries
• learning to deploy MySQL Constraints
• MySQL ALTER TABLE Command
• working with MySQL IN Operator, MySQL Sorting, MySQL Joins
• understanding MySQL Sequences, MySQL Injections.

Hands-on Exercise

• Deploy MySQL Constraints
• Use MySQL ALTER TABLE Command to change a table’s structure
• Use MySQL IN Operator
• MySQL Sorting, MySQL Joins
• Use MySQL Injections and Sequences

• Deploying SQL for data manipulation
• Searching, adding, removing, modifying, and deleting data, querying recurring data.

Hands-on Exercise

• Deploy SQL for searching, adding, removing
• modifying and deleting data
• The query for recurring data

• Working with advanced concepts of joining tables, grouping, and aggregating functions and expressions.

Hands-on Exercise 

• Join tables
• Use group functions
• Use Aggregate functions and expressions

• Sequence or unit of work done in logical manner
• Understanding the concepts of Transactions
• Studying the ACID properties of Transactions.

Hands-on Exercise 

• Perform a Transaction to perform multiple insert operations using php code
• Commit the transaction if it is successful else rollback and end the transaction

• Working with data to move it from source to destination
• Creation of destination database
• File and table using SQL Import/Export

Hands-on Exercise 

• Create destination database, file and table using SQL Import/Export

• CakePHP database access layers
• Keeping connection with the database
• building queries
• Working with data schemas
• Deploying Find
• Update and Save for working with Table data
• Understanding database.php config to work with databases

Hands-on Exercise 

• Connect with a mysql database using CakePHP
• Create a data schema
• Deploy Find
• Update and Save for working with Table data
• Manipulate database.php config for different effects on database operations using php