PHP Certification Training

Live Online & Classroom Certification Training

PHP is one of the most popular web programming languages in the world today. PHP, together with MySQL, forms a lethal combination for database driven applications. Our course on PHP teaches all the aspects of PHP programming including flow control, arrays, HTML Forms, etc. and also nicely explains RDBMS concepts in MySQL, like joins, cursors, trigger and bit of stored procedures.

(4.7) 191 Learners
Instructed by SPRINGPEOPLE
INDIA

No Public/Open-house class on the topic scheduled at the moment!

Course Description

Overview

MySQL and PHP are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open source database. Together these two technologies provide you with a powerful platform for building database-driven Web applications.

This hands-on MySQL and PHP training course teaches participants everything they need to successfully build data-driven Web sites using MySQL and PHP.

Objective

The objective of PHP training course is to train participants in becoming proficient PHP\/MySQL web developers.

At the end of the PHP training course, participants will have basic understanding of the web technology and be able to architect, write, debug and run complete web applications using PHP and MySQL.

Suggested Audience:

Programmers and Developers who would like to gain the knowledge in developing dynamic web pages.

Duration - 3 Days

Prerequisites

All participants must be fluent in HTML. The course can be customized to any level of programming and relational database familiarity.

Course Curriculum

Expand All
  • How PHP Works
  • The php.ini File
  • Basic PHP Syntax - PHP Tags - tPHP Statements and Whitespace - tComments - tPHP Functions - tHello World! -
  • Variables - Variable Types - tVariable Names (Identifiers) - tType Strength - tHello Variables! - tVariable Scope - tSuperglobals - tConstants - tVariable-Testing and Manipulation Functions -
  • PHP Operators
  • Creating Dynamic Pages - Single Quotes vs. Double Quotes - tHello World! -
  • Conclusion
  • Conditional Processing - If Conditions -
  • If Conditions
  • Loops - while - tdo...while - tfor - tbreak and continue -
  • Conclusion
  • Enumerated Arrays - Initializing Arrays - tAppending to an Array - tReading from Arrays - tLooping through Arrays -
  • Associative Arrays - Initializing Associative Arrays - tReading from Associative Arrays - tLooping through Associative Arrays - tSuperglobal Arrays -
  • Two-dimensional Arrays - Reading from Two-dimensional Arrays - tLooping through Two-dimensional Arrays -
  • Array Manipulation Functions
  • Conclusion
  • HTML Forms - How HTML Forms Work - tA Sample HTML Form - tForm Variables -
  • Conclusion
  • Formatting Strings - Concatenation - tString Manipulation Functions - tExamples of String Functions -
  • Magic Quotes - magic_quotes_gpc - tmagic_quotes_runtime - tRecommendation on Magic Quotes - tConclusion -
  • Conclusion
  • Including Files - require - trequire_once - tauto_prepend_file and auto_append_file -
  • User Functions - Defining and Calling Functions - tDefault Values - tVariable Scope - tBy Reference vs. By Value -
  • Form Processing - Code Organization -
  • Code Organization
  • Conclusion
  • Introduction to the Northwind Database
  • Some Basics - Comments - tWhitespace and Semi-colons - tCase Sensitivity -
  • SELECTing All Columns in All Rows
  • SELECTing Specific Columns
  • Sorting Recordstt - Sorting By a Single Column - tSorting By Multiple Columns - tSorting By Column Position - tAscending and Descending Sortst -
  • The WHERE Clause and Operator Symbolst - Checking for Equality - tChecking for Inequality - tChecking for Greater or Less Than - tChecking for NULL - tWHERE and ORDER BY -
  • The WHERE Clause and Operator Words
  • The BETWEEN Operator - tThe IN Operator - tThe LIKE Operator - tThe NOT Operator -
  • Checking Multiple Conditions - AND - tOR - tOrder of Evaluation -
  • Conclusion
  • Subqueries
  • Joins - Table Aliases - tMulti-table Joins -
  • Outer Joins
  • Unions - UNION ALL - tUNION Rules -
  • Conclusion
  • INSERT
  • UPDATE
  • DELETE
  • Conclusion
  • Querying a Database - mysqli() Overview - tmysqli Methods and Properties - tInserting and Updating Records - tmysqli Prepared Statements -
  • Advantages and Disadvantages of PEAR DB - Why use a database abstraction layer? - tWhen not to use a database abstraction layer? -
  • Why use a database abstraction layer?
  • When not to use a database abstraction layer?
  • Using PEAR DB
  • A Database-less Login Form
  • Conclusion
  • Perl-compatible Regular Expression Functions - preg_match() - tpreg_replace() - tRegular Expression Tester -
  • Regular Expression Syntax - Start and End ( ^ $ ) - tNumber of Occurrences ( ? + * {} ) - tCommon Characters ( . d D w W s S ) - tGrouping ( [] ) - tNegation ( ^ ) - tSubpatterns ( () ) - tAlternatives ( ) - tEscape Character ( ) -
  • Form Validation Functions with Regular Expressions
  • Conclusion
  • Sessions - Configuring Sessions - tSession Functions -
  • Conclusion
  • mail() - Shortcomings of mail() -
  • Shortcomings of mail()
  • PHPMailer
  • Conclusion
  • Opening a File - fopen() -
  • Reading from a File - fgets() -
  • Writing to a File - fwrite() -
  • File Locking - flock() -
  • Uploading Files via an HTML Form
  • Getting File Information
  • More File Functions
  • Directory Functions - Getting a Directory Listing -

Certification

SpringPeople works with top industry experts to identify the leading certification bodies on different technologies - which are well respected in the industry and globally accepted as clear evidence of a professional’s “proven” expertise in the technology. As such, these certification are a high value-add to the CVs and can give a massive boost to professionals in their career/professional growth.

Our certification courses are fully aligned to these high-profile certification exams; at the end of the course, participants will have detailed knowledge, be eligible and be fully ready take up these certification exams and pass with flying colours.

 

Resources

Technology Introduction Slides

SpringPeople Corporate Learning Center

Job Trends

About the Instructor

Founded in 2009, SpringPeople is a global premier eLearning marketplace for Online Live, Instructor-led classes in the region. It is a certified training delivery partner of leading technology creators, namely Pivotal, Elastic, Lightbend, EMC, VMware, MuleSoft, RSA, and... Read More


Course Rating and Reviews

4.7

Average Rating
5 Stars
28
4 Stars
12
3 Stars
1
2 Stars
0
1 Star
0

SPRINGPEOPLE SpringPeople Trainer

Mridhul

Devops
Course:
Instructor:
Course Material:
Class Experience:
The trainer was pretty new to the training and the class was not helpful. Not at all recommended. Failed to satisfy my requirements

SPRINGPEOPLE SpringPeople Trainer

Satheesh Viswanathan

Course:
Instructor:
Course Material:
Class Experience:
As the course focuses more towards the certification, the difficulty level of the labs & exercises could have been increased.

SPRINGPEOPLE SpringPeople Trainer

Deepak Kodigepalli

Course:
Instructor:
Course Material:
Class Experience:
Wifi connectivity was a bit slow and were experiencing intermittent disconnects

This class is intended for participants with some prior exposure to the technology and are now looking to build up their expertise on the topic.

On successful completion of the course, participants will be eligible to sit of the related certification exam (see course overview). All participants receive a course completion certificate, demonstrating their expertise on the subject.

Total duration of the online, live instructor led sessions. Sessions are typically delivered as short lectures (2-hrs weekdays/3-hrs weekends) and detailed hands-on guidance.

Expected offline lab work hours that participants will need to complete and submit to the trainer, during and after the instructor-led online sessions.

  1. We are happy to refund full fee paid - no questions asked - should you feel that the training is not up to your expectations.
  2. Our dedicated team of expert training enablement advisors are available on email, phone and chat to assist you with your queries.
  3. All courseware, including session recordings, will always be available to access to you for future reference and rework.

Contact Us

+91-80-6567-9700 (BLR)

training@springpeople.com

Schedule a Call

Related Courses

Recently Viewed