php and MySQL Training in Corvallis, OR for Beginners | MySQL with php Programming training | personal home page training | MySQL database training

This Instructor led LIVE php and MySQL training course will be provided for a total duration of 16 hours spread across 3 weeks by our highly professional php and MySQL trainers. 

php stands for Personal Home Page and is a widely popular multi-purpose scripting language that is especially suited for Web development and can be embedded into HTML.

Weekly Class Schedule

This class begins on Sunday evening, September 15, 2019 at 6:30 PM US Pacific time.

Please check your local date and time for the first session

• 16 hours of LIVE training
• 8 sessions | 3 weeks |  3 sessions first two weeks | 2 sessions during 3rd and last week | 2 hours per session
• Sunday, Tuesday and Thusday first 2 weeks
• Sunday and Tuesday during 3rd and last week
• US Pacific time 6:30-8:30 PM each day

Course Objectives

• Knowledge of high-level Architecture required for Web Page design.
• Handle the Web page development and support activities in the real-time
• Work independently and implement advanced concepts.
• Gain in-depth knowledge of various components related to PHP.
• Work with CMS system using WordPress, Joomla, etc.
• Work with any RDBMS operation.
• How to get involved in Development and Support as per Project Requirement.

Who should attend

This class can be taken by software developers, web developers and database professionals.

Prerequisites

• Basic knowledge of computers, websites, any programming language, html

Course Outline          

1. An Introduction to php and MySQL

• History of php and MySQL
• Installation and configuring Apache and PHP

2. php Basics, terms and terminology

3. Default Syntax

• Styles of PHP Tags
• Comments in PHP
• Output functions in PHP
• Datatypes in PHP
• Configuration Settings
• Error Types

4. php Variables

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

5. php Consants

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

6. Control Structures

• Execution Control Statements
• Conditional Statements
• Looping Statements with Real-time Examples

7. Functions

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

8. Arrays

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

9. Include Functions

• Include, Include_once
• Require, Require_once

10. Regular Expressions

• Validating text boxes,emails,phone number,etc
• Creating custom regular expressions

11. php Object-Oriented Programming 

• Classes, Objects, Fields, Properties, _set(), Constants, Methods
• Encapsulation
• Inheritance, types
• Polymorphism
• Constructors, Destructors
• Static Class Members, Keyword Instances, Helper Functions
• Object Cloning and Copy
• Reflections

12. php and 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

13. Strings and Regular Expressions

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

14. 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

15. Error and Exception Handling

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

16. Date and Time Functions

17. Authentication

• HTTP Authentication
• PHP Authentication
• Authentication Methodologies

18. Cookies

• Why Cookies
• Types of Cookies
• How to Create and Access Cookies

19. 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

20. Web Services

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

21. XML Integration

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

22. 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 Sqlserver(Optional)

23. Protocols, HTTP communications, files, 

• 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

24. php and MySQL with different web technologies

• MVC Architecture
• Drupal
• Joomla
• Wordpress
• Ajax
• Css
• Jquery
• Plugins

Refund Policy

• All Sales and purchase of tickets is final. There are no Refunds issued. 
• If a class is rescheduled/cancelled by the organizer, students who have made the payment and registered for the class will be offered a credit towards any future course.

                                                                         Training FAQs