MySQL Syllabus

MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications.

This tutorial will give you quick start with MySQL and make you comfortable with MySQL programming.

MySQL Quick Start

✓ What is MySQL?
✓ Install MySQL Database Server
✓ Download MySQL Sample Database
✓ Load Sample Database

MySQL Data Manipulation

✓ MySQL SELECT
✓ MySQL DISTINCT
✓ MySQL WHERE
✓ MySQL AND
✓ MySQL OR
✓ MySQL LIMIT
✓ MySQL IN
✓ MySQL BETWEEN
✓ MySQL LIKE
✓ MySQL ORDER BY
✓ MySQL UNION
✓ MySQL ALIAS
✓ MySQL INNER JOIN
✓ MySQL LEFT JOIN
✓ MySQL RIGHT JOIN
✓ MySQL SELF JOIN
✓ MySQL GROUPBY
✓ MySQL HAVING
✓ MySQL Subquery
✓ MySQL INSERT Statement
✓ MySQL UPDATE
✓ MySQL DELETE

MySQL Data Defination

✓ Manage Databases
✓ MySQL Table Types
✓ MySQL Data Types
✓ MySQL CREATE TABLE
✓ MySQL Primary Key
✓ MySQL Foreign Key
✓ MySQL Sequence
✓ MySQL ALTER TABLE
✓ MySQL DROP TABLE