4 Weeks PHP, MySQL training is being delivered from February 4, 2020 - February 27, 2020, US Pacific Time for 16 hours over 4 weeks, 8 sessions, 2 sessions per week, 2 hours per session.

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

4 WEEKS PHP, MySQL TRAINING SCHEDULE

• 4 Weeks | Tuesday, Thursday Every Week
• 5:30 PM - 7:30 PM US Pacific time each day
• February 4, 2020 - February 27, 2020, US Pacific time

Please check your local date & time for the first session

Features & Benefits

• 4 weeks, 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.

COURSE PRE-REQUISITES

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 Practicality
• Power
• 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