MySQL

Course Description

MySQL is a fast, easy to use relational database. It is currently the most popular open-source database. It is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.MySQL is used for many small and big businesses. It is developed, marketed and supported by MySQL AB, a Swedish company. It is written in C and C++.

MySQL

Modes of Training Available.

Online Training
Classroom Training

Course Outline MySQL

MySQL

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()
MySQL Comments
MySQL Cursor
MySQL Functions
MySQL Literals(Constants)
MySQL Date & Time
MySQL Procedure
MySQL Trigger

Enquire Now