MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language.
Level-1. MySQL QUICK START
- Introduction to MySQL
- Download and Install MySQL DBMS
- Sample MySQL Database
- Load Sample Database
Level-2. MySQL Data Manipulation
- SeLECT, SELECT DISTINCT
- ORDER BY, WHERE, AND, OR, IN
- BETWEEN, LIKE, LIMIT, IS NULL
Level-3. Other Commands
- Create Database
- Create Table
- Insert Into
- Update
- Delete
- Alter Table
Level-4. Tables & Column Aliases
- Joins
- Inner join, Left Join, Right Join, Self-Join, Cross Join
- Group By, Having, Roll UP, Sub Query
Level-5. Derived tables
- Exists
- Unions
- Minus
- Intersect
Level-6 .
- On Delete Cascade
- On Update Cascade
- Replace