Getting Started
  • Course Overview
  • MySQL Installation Guide
  • Introduction & Terminology
  • Getting started with basic commands
  • Script
  • Quiz
Basic DML
  • Projecting required columns through Query
  • Script
  • Insert data into the table
  • Script
  • Inserting multiple records
  • Script
  • Quiz
  • Arranging the data before display
  • Script
  • Filtering Data
  • Script
  • Quiz
  • Updating and Delete
  • Script
  • Quiz
Designing the Tables/Relations
  • Primary Constraints
  • Script
  • Identity Column
  • Script
  • Primary Key
  • Script
  • Need for splitting data into multiple tables
  • Referential Integrity
  • Script
  • Relationship and Cardinality
  • Script
  • Constraints over multiple columns
  • Script
  • Quiz
Query Design
  • Aggregate functions
  • Script
  • Grouping and applying aggregate functions
  • Script
  • Filtering groups
  • Script
  • Memorising queries 2
  • Quiz
  • Joins Introduction
  • Script
  • Inner and Outer Joins
  • Script
  • Subqueries
  • Script
  • Correlated Subqueries
  • Script
  • Quiz
  • Problem Set
Example Social App Schema Design
  • Schema Design - Part 1
  • Schema Design - Part 2
  • Schema Design - Part 3
  • Schema Design - Part 4
  • Social App Schema - Part 5
  • Script
  • Solutions to Problems in the Script
Other essential topics
  • ALTER command
  • Views
  • Index
  • Transactions
  • Quiz
Source
  • Scripts
What's next?
  • Bonus Lecture: OFFER Coupons for my other courses