PHP & MySQL with MVC Frameworks Certification Training

Module 1: PHP Basics and Conditional Logic

⏳ 2 hours

• Topics: PHP setup, variables, data types, decision-making statements, loops, arrays

• Hands-on: Build a basic script that uses conditionals and loops to process data

Module 2: Functions and Error Handling

⏳ 2 hours

• Topics: Defining functions, parameter handling, return values, try/catch for error control

• Hands-on: Create reusable functions and implement exception handling in PHP scripts

Module 3: Object Oriented Programming

⏳ 2 hours

• Topics: Classes, objects, constructors/destructors, inheritance, polymorphism, encapsulation

• Hands-on: Develop a class hierarchy for a simple domain model and instantiate objects

Module 4: MySQL Installation and Basics

⏳ 2 hours

• Topics: Installing MySQL, creating databases and tables, basic SQL (SELECT, INSERT, UPDATE, DELETE)

• Hands-on: Install MySQL locally, create a database schema, and perform CRUD operations

Module 5: Advanced Queries & Data Manipulation

⏳ 2 hours

• Topics: JOINs, subqueries, aggregate functions, prepared statements, transactions

• Hands-on: Use PHP to execute complex SQL queries and handle results securely

Module 6: MVC Basics & Introduction to CakePHP

⏳ 2 hours

• Topics: MVC concepts, CakePHP project structure, conventions over configuration

• Hands-on: Scaffold a new CakePHP application and explore its directory layout

Module 7: CakePHP Controllers, Views & Layouts

⏳ 2 hours

• Topics: Controller actions, view templates, layout inheritance, element usage

• Hands-on: Build CRUD controllers and create corresponding view files

Module 8: Models & Database Interaction in CakePHP

⏳ 2 hours

• Topics: Model definitions, associations (hasOne/hasMany), data validation, ORM queries

• Hands-on: Configure models and perform data retrieval and persistence

Module 9: Dynamic Forms with CakePHP Html Helper

⏳ 2 hours

• Topics: Form helper methods, validation rules, flash messaging

• Hands-on: Create and validate a multi-field form for user input

Module 10: Building Your CakePHP Website

⏳ 2 hours

• Topics: Routing, component integration, deployment considerations

• Hands-on: Complete a mini-website that ties together controllers, views, and models

Get certificate