Galaxy Computer Education
& Training Institute

PHP MySQL Course in Abu Dhabi

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. Our Introduction to SQL using MySQL course is designed for students new to writing SQL queries using MySQL.

PHY MySQL Course Outline

1: GETTING STARTED WITH PHP
  • What is PHP
  • Install PHP
  • PHP Example
  • PHP Echo
  • PHP Print
  • PHP Variable
  • PHP $ and $$
  • PHP Constants
  • PHP Magic Constants
  • PHP Data Types
  • PHP Operators
  • PHP Comments
02: CONTROL STATMENT
  • PHP If else
  • PHP Switch
  • PHP For Loop
  • PHP While Loop
  • PHP Do While Loop
  • PHP Break
  • PHP Programs
  • 20 PHP Program
03: PHP FUCTIONS
  • PHP Functions
  • Parameterized Function
  • PHP Call By Value
  • PHP Call By Reference
  • PHP Default Arguments
  • PHP Variable Arguments
  • PHP Recursive Function

04: PHP ARRAYS

  • PHP Array
  • PHP Indexed Array
  • PHP Associative Array
  • Multidimensional Array
  • PHP Array Functions

PHP Strings

  • PHP String
  • PHP String Functions

PHP Math

  • PHP Math Functions

PHP Form

  • PHP Form: Get Post

PHP Include

  • PHP include & require

State Management

  • PHP CookiePHP Session

PHP File

  • PHP File Handling
  • PHP Open File
  • PHP Read File
  • PHP Write File
  • PHP Append File
  • PHP Delete File

Upload Download

  • PHP File Upload
  • PHP Download File

PHP MySQLi

  • MySQLi CONNECT
  • MySQLi CREATE DB
  • MySQLi CREATE Table
  • MySQLi INSERT
  • MySQLi UPDATE
  • MySQLi DELETE
  • MySQLi SELECT
  • MySQLi Order by

MySQL Course Contents

  • What is MySQL
  • MySQL History
  • MySQL Features
  • MySQL Data Types
  • Install MySQL

MySQL Database

  • Create Database
  • Select Database
  • Drop Database

Table & Views

  • CREATE Table
  • ALTER Table
  • TRUNCATE Table
  • DROP Table
  • MySQL Views

MySQL Queries

  • MySQL Queries
  • INSERT Record
  • UPDATE Record
  • DELETE Record
  • SELECT Record

MySQL Clauses

  • MySQL WHERE
  • MySQL DISTINCT
  • MySQL FROM
  • MySQL ORDER BY
  • MySQL GROUP BY
  • MySQL HAVING

MySQL Conditions

  • MySQL AND
  • MySQL OR
  • MySQL AND OR
  • MySQL LIKE
  • MySQL IN
  • MySQL NOT
  • MySQL IS NULL
  • MySQL IS NOT NULL
  • MySQL BETWEEN

MySQL Join

  • MySQL JOIN

Aggregate Functions

  • MySQL count()
  • MySQL sum()
  • MySQL avg()
  • MySQL min()
  • MySQL max()
  • MySQL first()
  • MySQL last()

Why to Choose Galaxy Computer Education and Training Institute?

  • Affordable Fee
  • Flexible Timing
  • Quality Education
  • Hands on Experience
  • Online Training
  • In-Person Teaching
  • Individual Attention
  • Education for all levels
  • 25 years of excellence
  • Ministry of UAE approved certification

Who Can Benefit from This Training Course

    • Computer Programmer
    • Website Developer
    • Website Designer
    • Database Engineer
    • Digital Marketer¬†

Enquire About the Course

Qualified Trainers

Passionate Dedicated & Highly Qualified Trainers with Industry Experience

Flexible Timing

We Provide flexible Timings for working Professionals and Open 7 days in a week, between 9 am to pm.

Affordable Fees

We Provide High Quality Training with affordable Fees