MySql & PHP Training Course Mussafah, 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.
Objective:
PHP is a widely used programming language which works on the principal of server side scripting to produce dynamic Web pages. It can be easily integrated with HTML and SQL to produce these dynamic web pages, and is often used to process the contents of a Web page form as it is more secure and reliable than JavaScript. You will learn how PHP can be combined with MySQL to create a very powerful online database engine. This free online PHP programming course will be of great interest to IT and Web development professionals who would like to learn more about using PHP and MySQL to integrate database functions into Websites, and to learners who would like to learn more about the functionality of PHP and MySQL.
Course Outline:
- 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
Control Statement
- PHP If else
- PHP Switch
- PHP For Loop
- PHP While Loop
- PHP Do While Loop
- PHP Break
PHP Functions
- PHP Functions
- Parameterized Function
- PHP Call By Value
- PHP Call By Reference
- PHP Default Arguments
- PHP Variable Arguments
- PHP Recursive Function
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 Cookie
- PHP 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 Mail
- PHP Mail
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()