Course Introduction
  • Welcome to the Course
  • Syllabus Explanation
Installation and Setup
  • Section Introduction
  • Databases, SQL and MySQL
  • Relational Database Management System
  • MySQL Installation for Windows
  • MySQL Installation for Mac
  • MySQL Installation for Linux
  • MySQL Workbench Overview
  • Create Database
Data Definition Language
  • Section Introduction
  • Data Types
  • Primary and Foreign Keys
  • Creating the Coffee Store Database
  • Modifying Tables: Adding and Removing Columns
  • Deleting Tables
  • Truncating Tables
More On Alter Table
  • Section Introduction
  • Creating Our Test Database
  • Add and Remove Primary Key
  • Add and Remove Foreign Key
  • Add Unique Constraint
  • Change Column Name
  • Change Column Data Type
  • Exercise 1
  • Solution 1
Data Manipulation Language
  • Section Introduction
  • Inserting Data Into Tables
  • Updating Data in Tables
  • Deleting Data from Tables
  • Completing the Coffee Store Database
Selecting from a Table
  • Section Introduction
  • Select Statement
  • Where Clause
  • Using Inequality Symbols
  • Null Values
  • Exercise 1
  • Solution 1
  • In, Not In
  • Between
  • Like
  • Order By
  • Exercise 2
  • Solution 2
  • Distinct
  • Limit
  • Column Name Alias
  • Exercise 3
  • Solution 3
Selecting From Multiple Tables
  • Section Introduction
  • What Are Joins?
  • Inner Join
  • Left Join
  • Right Join
  • Joining more than Two Tables
  • Exercise 1
  • Solution 1
Database Design
  • Section Introduction
  • Normalization - What is it?
  • 1st Normal Form (1NF)
  • 2nd Normal Form (2NF)
  • 3rd Normal Form (3NF)
  • Relationships
  • Relationships - One to One
  • Relationships - One to Many
  • Relationships - Many to Many
  • Constraints
Creating a Cinema Booking System Database
  • Section Introduction
  • Database Schema Overview
  • Create Films Table
  • Create Customers Table
  • Create Rooms Table
  • Create Screenings Table
  • Create Seats Table
  • Create Bookings Table
  • Create Reserved_Seat Table
  • Insert the Data
Aggregate Functions
  • Section Introduction
  • What are Aggregate Functions
  • Count
  • Sum
  • Min and Max
  • Average
  • Exercise 1
  • Solution 1
  • Grouping Data
  • Having Clause
  • Exercise 2
  • Solution 2
Subqueries