Introduction and Installation
  • Installing MySQL
  • Database Creation
  • Table Creation with SELECT and INSERT
  • MySQL Data Types
  • Creating an Auto Incrementing Primary Key
MySQL Basic Statements
  • Describe Table
  • Loading sql Files into MySQL
  • Introduction to SELECT Query
  • SELECT Query Demo
MySQL Advanced Statements
  • MySQL Update Query
  • Mathematical Operations
  • DISTINCT, COUNT and GROUP BY Clauses
  • Table Relationships
  • Introduction to Joins
MySQL Advanaced Statements Part 2
  • The Delete Query
  • Types of Joins
  • Joins Demo
  • Creating and Using Views
  • Setting up a Many to Many Relationship
  • Demo of Many to Many Relationship