Live chat by BoldChat

Training on PHP and MySQL/SQL

PHP Training 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 attendees everything they need to successfully build data-driven Web sites using MySQL and PHP.

Accelebrate also offers an Advanced PHP training class.

Course Details:

Database Applications and the Web

  • The Web
  • Three-Tier Architectures

The PHP Scripting Language

  • Introducing PHP
  • Conditions and Branches
  • Loops
  • Functions
  • Working with Types
  • User-Defined Functions
  • A Working Example

Arrays, Strings, and Advanced Data Manipulation in PHP

  • Arrays
  • strings
  • Regular Expressions
  • Dates and Times
  • Integers and Floats

Introduction to Object-Oriented Programming with PHP 5

  • Classes and Objects
  • Inheritance
  • Throwing and Catching Exceptions

SQL and MySQL

  • Database Basics
  • MySQL Command Interpreter
  • Managing Databases and Tables
  • Inserting, Updating, and Deleting Data
  • Querying with SQL SELECT
  • Join Queries

Querying Web Databases

  • Querying a MySQL Database Using PHP
  • Processing User Input
  • MySQL Function Reference

Writing to Web Databases

  • Database Inserts, Updates,and Deletes
  • Issues in Writing Data to Databases

Sessions

  • Introducing Session Management
  • PHP Session Management
  • Case Study: Using Sessions in Validation
  • When to Use Sessions
  • PHP Session API and Configuration

Authentication and Security

  • HTTP Authentication
  • HTTP Authentication with PHP
  • Form-Based Authentication
  • Protecting Data on the Web

Errors, Debugging, and Deployment

  • Errors
  • Common Programming Errors
  • Custom Error Handlers

Advanced Features of Object-Oriented Programming in PHP 5

  • Working with Class Hierarchies
  • Class Type Hints
  • Abstract Classes and Interfaces

Advanced SQL

  • Advanced Querying
  • Manipulating Data and Databases
  • Functions
  • Automating Querying
  • Table Types

Practical Application

  • Creating a PHP & MySQL Application
Request a Quote

Featured Projects

Technical Expertise

Awards

Our Partners

Customer Talk

  • upSage Pastel has streamlined our financial operations. We have achieved stability with the system now and are satisfied with your support.up

    -Principal
    Institute of Social Works

  • upI would like to thanks and congratulate to you and your team who has performed very nice and swift action to fulfil this project in less time and efficient way.up

    -CEO
    Capital Markets and Securities Authority (CMSA)

  • upI have been impressed with your level of technical ability and the ease with which we can work together. I will certainly be recommending Web Technologies to others who need fast and well delivered applications.up

    -Executive Director
    Tanzania Education Authority (TEA)

  • upWe are very happy with the service Web Technologies provides. They are contactable twenty four hours a day, seven days a week and their response times are excellent, which keeps our down time to a minimum.up

    -Johannes Kahwa
    It Manager, Social Security Regulatory Authority ( SSRA)

  • upWeb Technologies have been overseeing the development of our University Website , Software and networks for over 5 years. Work is always completed to a high standards, on time and to budget. We have been very appreciative of the patient, friendly and reliable service.up

    -Elibariki Mushi (Head of ICT)
    Kampala International University (KIU)

Be Social with us

Terms of Service | Terms of Use | Privacy Policy | Connectivity

Articles | FAQ | Sitemap | Inquiry | Client Speaks | Contact | Blog | Partnership