4 Weekends PHP, MySQL training is being delivered from April 18, 2020 - May 10, 2020, US Pacific Time for 16 hours over 4 weekends, 8 sessions, 2 sessions per weekend, 2 hours per session.

• All published ticket prices are in US Dollars.
• This course will be taught in the English language.

4 Weekends pHp, mySql Training Schedule

• April 18, 2020 - May 10, 2020, US Pacific Time
• 4 Weekends | 2 hours on Saturday, 2 hours on Sunday every weekend | US Pacific Time
• 8:30 AM - 10:30 AM US Pacific time each of those days.
• Please click here to add your location and find your local date and time for the 1st session to be held on April 18, 2020 at 8:30 AM US Pacific Time

Features and Benefits

• 4 weekends, 8 sessions, 16 hours of total training
• Training materials, instructor handouts and access to useful resources on the cloud provided
• Practical Hands-on Lab exercises provided
• Actual code and scripts provided
• Real-life Scenarios

Course Objectives

• Understanding the high-level Architecture required for Web Page design.
• Handle the Web page development & support activities in real-time
• Working on a CMS system using WordPress, Joomla, etc.
• Work with any RDBMS.

Pre-requisite Skills

Basic knowledge of :

• Computer System
• Any Programming Language desired but not required
• HTML knowledge preferred but not essential

Who can take this course?

Any professional who is interested in learning web development using PHP.

Course Outline

1. An Introduction to PHP

• History
• Versions and Differences between them
• Installation and configuring Apache and PHP

2. PHP Basics

• Default syntax
• Styles of PHP tags
• Comments in PHP
• Output functions in PHP
• Datatypes in PHP
• Configuration Settings
• Error Types

3. Variable in PHP

• Variable Declarations
• Variable Scope
• PHP’s Superglobal Variables
• Variable Variables

4. Constants in PHP

• Magic Constants
• Standard Pre-defined Constants
• Core Pre-defined Languages
• User-defined Constants

5. Control Structures

• Execution Control Statements
• Conditional Statements
• Looping Statements with Realtime Examples

6. Functions

• Creating Functions
• Passing Arguments by Value
• Passing Arguments by Reference
• Recursive Functions

7. Arrays

• What is an Array?
• How to create an Array
• Array Functions
• Traversing Arrays

8. Include Functions

• Include, Include_once
• Require, Require_once

9. Regular Expressions

• Validating Textboxes, Emails, Phone Number, Etc
• Creating Custom Regular Expressions

10. Object-Oriented Programming in PHP

• Classes, Objects, Fields, Properties, _set(),
• Constants, Methods
• Encapsulation
• Inheritance and types
• Polymorphism
• Constructor and Destructor
• Static Class Members, Instance of Keyword,
• Helper Functions
• Object Cloning and Copy
• Reflections

11. PHP with MySQL

• What is MySQL
• Integration with MySQL
• MySQL Functions
• Gmail Data Grid options
• SQL Injection
• Uploading and downloading images in Database
• Registration and Login forms with validations
• Paging, Sorting

12. Strings and Regular Expressions

• Declarations styles of String Variables
• Heredoc style
• String Functions
• Regular Expression Syntax(POSIX)
• PHP’s Regular Expression Functions(POSIX Extended)

13. Working with the Files and Operating System

• File Functions
• Open, Create and Delete files
• Create Directories and Manipulate them
• Information about Hard Disk
• Directory Functions
• Calculating File, Directory and Disk Sizes

14. Error and Exception Handling

• Error Logging
• Configuration Directives
• PHP’s Exception Class
• Throw New Exception
• Custom Exceptions

15. Date and Time Functions

• Date and Time Functions

16. Authentication

• HTTP Authentication
• PHP Authentication
• Authentication Methodologies

17. Cookies

• Why Cookies?
• Types of Cookies
• How to Create and Access Cookies
• 18. Sessions
• Session Variables
• Creating and Destroying a Session
• Retrieving and Setting the Session ID
• Encoding and Decoding Session Data
• Auto-Login
• Recently Viewed Document Index

19. Web Services

• Why Web Services
• RSS Syntax
• SOAP
• How to Access Web Services

20. XML Integration

• What is XML
• Create an XML file from PHP with Database records
• Reading Information from XML File

21. MySQL Concepts

• Introduction
• Storage Engines
• Functions
• Operators
• Constraints
• DDL commands
• DML Commands
• DCL Command
• TCL Commands
• Views
• Joins
• Cursors
• Indexing
• Stored Procedures
• Mysql with PHP Programming
• Mysql with SQL Server (Optional)

22. Special Delivery

• Protocols
• HTTP Headers and types
• Sending Mails using PHP
• Email with Attachment
• File Uploading and Downloading using Headers
• Implementing Chating Applications using PHP and Ajax
• SMS Gateways and sending SMS to Mobiles
• Payments gateways and How to Integrate them

23. With Complete

• MVC Architecture
• DRUPAL
• JOOMLA
• Word Press
• AJAX
• CSS
• JQUERY