MySQL

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