$319.89 – $425.98

4 Weeks PHP, MySQL Training in Barcelona | Introduction to PHP and MySQL tr...

Event Information

Share this event

Date and Time

Location

Location

TruVs

Barcelona

Spain

View Map

Refund Policy

Refund Policy

Refunds up to 1 day before event

Eventbrite's fee is nonrefundable.

Event description

Description

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


Share with friends

Date and Time

Location

TruVs

Barcelona

Spain

View Map

Refund Policy

Refunds up to 1 day before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved