php and MySQL Training in Fayetteville, AR for Beginners | MySQL with php P...

Event Information

Share this event

Date and Time

Location

Location

Entirety Technology

Fayetteville, AR 72701

View Map

Refund Policy

Refund Policy

No Refunds

Event description

Description

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

Date and Time

Location

Entirety Technology

Fayetteville, AR 72701

View Map

Refund Policy

No Refunds

Save This Event

Event Saved