PHP & MySQL Course

Apply now for our PHP & MySQL Course



  • Handle forms, i.e. gather data from files, save data to a files
  • Restrict users to access some pages of your website.
  • Add, delete, modify elements within your database
  • Arrays, Strings, and Advanced Data Manipulation
  • Query a MySQL Database Using PHP


Course Details and Pricing


Instructor Led Learning


  Duration: 10 Days

  Registration Open Now!

Onsite Training


  Duration: 10 Days

  Registration Open Now!

Call us : 0861 111 460

Course overview

PHP & MySQL has become one of the most popular full-featured open-source languages. It is capable of managing huge database-driven online environments. This web development course will enable to create complex Web Database Applications.

Web developers all over the world us PHP as a general-purpose scripting language. PHP was originally created to help coders maintain personal home pages. Today, however, it is far more than just a set of utilities.






PHP MySQL training courses cape town

Is this course for you?

This course is aimed at developers and designers who need to learn php & mysql coding conventions and techniques. Anyone wanting to learn the power behind PHP and MySQL.

Benefits to you

Reduce the cost while increasing the efficiency of the websites or web applications.
Does not have to rewrite every line of HTML in a programming language.
Its interoperability with multiple operating systems and servers.


PHP Courses Cape Town Training, Web Design training

Job Opportunities

Job Title: PHP Developer

Responsibilities:
The PHP Developer is responsible for the design and implementation of a wide variety of Web-based products using PHP, JavaScript, MySQL and AJAX.

3 Steps to become a PHP Developer

01

Take a
course

02

Write an
Exam

03

Get
Certified

What you will learn
PHP & MySQL Training Course

  • Lesson 1: Database Applications and the Web
  • Lesson 2: The PHP Scripting Language
  • Lesson 3: Arrays, Strings, and Advanced Data Manipulation
  • Lesson 4: Introduction to Object-Oriented Programming
  • Lesson 5: SQL and MySQL
  • Lesson 6: Querying Web Databases
  • Lesson 7: PEAR
  • Lesson 8: Writing to Web Databases
  • Lesson 9: Validation with PHP and JavaScript
  • Lesson 10: Sessions
  • Lesson 11: Authentication and Security
  • Lesson 12: Errors, Debugging, and Deployment
  • Lesson 13: Reporting
  • Lesson 14: Advanced Features of Object-Oriented Programming
  • Lesson 15: Advanced SQL
  • Lesson 16: Hugh and Dave's Online Wines: A Case Study
  • Lesson 17: Managing Customers
  • Lesson 18: The Shopping Cart
  • Lesson 19: Ordering and Shipping at the Online Winestore
  • Lesson 20: earching and Authentication in the Online Winestore

Full course outline
PHP & MySQL Training Course

PHP and MYSQL

Chapter 1: Database Applications and the Web

  • The Web
  • Three-Tier Architectures

Chapter 2: The PHP Scripting Language

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

Chapter 3: Arrays, Strings, and Advanced Data Manipulation in PHP

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

Chapter 4: Introduction to Object-Oriented Programming with PHP 5

  • Classes and Objects
  • Inheritance
  • Throwing and Catching Exceptions

Chapter 5: SQL and MySQL

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

Chapter 6: Querying Web Databases

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

Chapter 7: Writing to Web Databases

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

Chapter 8: Sessions

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

Chapter 9: Authentication and Security

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

Chapter 10: Errors, Debugging, and Deployment

  • Errors
  • Common Programming Errors
  • Custom Error Handlers

Chapter 11: Advanced Features of Object-Oriented Programming in PHP 5

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

Chapter 12: Advanced SQL

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

Chapter 13: Practical Application

  • Creating a PHP & MySQL Application

Are you ready to become a php developer?