Ultimate Guide to 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.

Part 1: Working with Database

  1. Database Design
  2. Building of Database
  3. Create Table
  4. Change Table Structure
  5. Drop vs Truncate Table
  6. Using Database
  7. Database Normalization

Part 2: Working with Data

  1. SQL Statements
  2. Insert Data
  3. Update Data
  4. Delete Data
  5. Select Data from One Table
  6. Select Data from Two Tables

Part 3: Miscellaneous

  1. History and Versions
  2. Introduction to MySQL
  3. MySQL vs MariaDB
  4. Data Types (String, Numerical, Date)
  5. Primary Key
  6. Foreign Key
  7. NULL
  8. LIKE
  9. Database Indexing