Section Introduction: Databases, SQL, MySQL, and DBMS Explained in Detail

Databases, SQL, and MySQL: Understanding the Core Concepts and Relationships

Deep Dive into Relational Database Management Systems (RDBMS) and MySQL

Step-by-Step MySQL Installation Guide for Windows: Server and Workbench Setup

Comprehensive MySQL Installation Guide for Mac: Server and Workbench Setup

Complete MySQL Installation Guide for Linux (Ubuntu): Server and Workbench

MySQL Workbench Interface: Navigating, Configuring, and Query Execution

Creating Your First Database: Hands-On SQL Query Execution and Database Usage

Introduction to Data Definition Language (DDL) and Data Manipulation Language (D

Comprehensive Guide to MySQL Data Types: Integers, Floats, Decimals, and More

Understanding Primary and Foreign Keys: The Key to Relational Database Design

Step-by-Step Guide: Creating the Coffee Store Database and Tables in MySQL

Modifying Tables: Adding and Removing Columns in your Database using ALTER

Deleting Tables: Using the DROP command to Remove Tables from your Database

Efficiently Deleting All Data in a Table with the TRUNCATE TABLE Command

Introduction to Advanced Table Alteration Techniques in MySQL

Hands-On: Creating a Dedicated MySQL Practice Database for Testing

Adding and Removing Primary Keys in MySQL Tables: A Step-by-Step Guide

Foreign Keys in MySQL: Adding, Removing, and Understanding Relationships

Implementing Unique Constraints on MySQL Table Columns for Data Integrity

How to Rename Columns in MySQL Tables: Best Practices and Techniques

Modifying Column Data Types in MySQL: A Comprehensive Tutorial

Alter Table Exercises: Apply Your Knowledge with Six Practical Challenges

Comprehensive Solutions and Explanations for Alter Table Challenges

SQL Data Manipulation Language (DML) Fundamentals: Section Introduction

Inserting Data into SQL Database Tables: Comprehensive Practical Guide

Comprehensive Guide to Updating Existing Data in SQL Database Tables

Deleting Data from SQL Tables: Single, Multiple, and All Rows Deletion

Populating the Coffee Store Database: A Complete Data Insertion Guide

Introduction to Retrieving Data: SELECT Statement Fundamentals in SQL

Mastering the SELECT Statement: Retrieving Data from SQL Database Tables

Filtering Data with WHERE Clauses: Enhancing SQL Query Precision

Using Inequality Operators in SQL WHERE Clauses: A Comprehensive Guide

Handling NULL Values in SQL: IS NULL and IS NOT NULL in WHERE Clauses

Practice Retrieving, and Filtering Data - Exercise Set 1 for Section 6

Solutions and Explanations: Exercise Set 1 for Section 6 on Filtering

Filtering Data with IN and NOT IN Operators in SQL WHERE Clauses

Using the BETWEEN Operator for Range Queries in SQL: Dates, Numbers, Strings

Pattern Matching with LIKE in SQL: Wildcards for Flexible Data Filtering

Sorting Query Results with ORDER BY in SQL: Ascending and Descending

Practice Using IN, NOT IN, Between and Like Operators - Exercise Set 2

Solutions and Explanations: Exercise Set 2 for Section 6 on Filtering

Selecting DISTINCT Values in SQL: Removing Duplicate Data from Results

Controlling Result Set Size with LIMIT and OFFSET in SQL Queries

Improving Readability with Column Name Aliases in SQL Queries

Practice Using Distinct, Limit and Aliases - Exercise Set 3 for Section 6

Comprehensive Review and Solutions - Exercise Set 3 for Section 6

Introduction to the Comprehensive World of Selecting Data from Multiple Tables

Understanding SQL JOINs: How to Retrieve Data from Multiple Tables in MySQL

Mastering INNER JOINs: The Ultimate Guide to Retrieving Matching Data in MySQL

LEFT JOIN in MySQL: How to Retrieve All Data from the Left Table Effectively

RIGHT JOIN in MySQL: Guide to Retrieving All Data from the Right Table in Querie

Advanced SQL: Mastering Joins Across Three or More Tables in MySQL Database

Applying JOIN Knowledge in MySQL with Practical Database Queries

Step-by-Step Solutions: Mastering JOIN Queries in MySQL Exercise Walkthrough

Visualizing Databases: Create Entity Relationship Diagrams in MySQL Workbench

Introduction to Database Design Concepts and Principles

Database Normalization Explained: Organizing Data for Efficiency

First Normal Form (1NF): Rules for Eliminating Data Duplication

Second Normal Form: Ensuring Data Dependency on the Primary Key

Third Normal Form (3NF): Optimizing Data Relationships in Detail

Understanding Relationships Between Tables in Relational Databases

One-to-One Relationships: Definition, Examples, and Diagrams

One-to-Many Relationships: Most Common Database Links Explained

Many-to-Many Relationships: Using Junction Tables Effectively

Using Constraints: Not Null, Unique, Primary & Foreign Key, Check

Project Kickoff: Building a Cinema Booking System Database in MySQL

Cinema Booking Database ERD: Understanding Tables and Relationships

Implementing the Films Table: Primary Key, Unique Constraints, and Data Types

Constructing the Customers Table: Designing Fields for Optimal Data Capture

Creating the Rooms Table: Defining the Physical Spaces in the Cinema

Building the Screenings Table: Foreign Keys, Relationships, and Data Types

Designing the Seats Table: Managing Seat Rows, Numbers, and Room Allocation

Creating the Bookings Table: Linking Customers, Screenings, and Reservations

Building the Reserved Seats Junction Table: Many-to-Many Relationships

Populating the Database: Inserting Data into all Seven Tables in Correct Order

Introduction to SQL Aggregate Functions: COUNT, SUM, MIN, MAX, AVG and More

Understanding Aggregate Functions: Perform Calculations and Return Single Values

Using the COUNT Function: Count Rows and Handle NULL Values in SQL Queries

Mastering the SUM Function: Calculate Totals of Numeric Columns in Your Database

Using MIN and MAX Functions: Find Lowest and Highest Values in a SQL Column

Calculate Data Averages: Using the AVG Aggregate Function with WHERE Clauses

Practice Aggregate Functions: Hands-On Exercises for COUNT, SUM, MIN, and MAX

Step-by-Step Solutions for Aggregate Function Exercises: COUNT, joins, Dates

Mastering the GROUP BY Clause: Aggregate Data by One or More Columns in SQL

Filtering Grouped Data with the HAVING Clause: A WHERE Clause Alternative

Advanced Exercises: Combining GROUP BY, HAVING, and WHERE Clauses in SQL

Comprehensive Solutions and Explanations for Advanced SQL Exercises (GROUP BY)

Introduction to Subqueries: Enhance SQL Skills

Comprehensive Guide to Subqueries Types in MySQL

Mastering Non-Correlated Subqueries in WHERE Clauses

Using Non-Correlated Subqueries with FROM for Max/Avg

Deep Dive into Correlated Subqueries in MySQL

Subquery Practice: Exercises for Non-Correlated Types

Complete Solutions for Subquery Exercises: Step-by-Step

Introduction to MySQL Functions: String and Date

Understanding MySQL Functions: Parameters and Values

Mastering String Concatenation with the CONCAT Function

Extracting Substrings: A Detailed Guide to the SUBSTRING Function

String Case Conversion: Using UPPER and LOWER Functions

String Functions Practice: Exercises in MySQL

String Functions Practice: Exercises in MySQL

Simplifying Date Queries: Working with the DATE Function

Extracting Month Data with the MONTH Function in MySQL

Using the YEAR Function for Efficient Year-Based Filtering

Date and Time Functions: Hands-On Practice Exercises

Date and Time Functions: Exercise Walkthrough

Kickstart Your SQL Prowess with our Practical Challenge Section Introduction

SQL Challenge: Retrieving Films with a Duration Exceeding Two Hours

SQL Solution and Query Walkthrough for Two Hour Plus Film Retrieval

Advanced SQL Challenge: Identifying the Film with the Most Screenings

SQL Solution: Multi-Level Subqueries for Maximum Screenings Identification

SQL Challenge: Analyzing May 2022 Bookings for the film "Jigsaw"

SQL Solution: Subqueries and Joins to Count Bookings for Specific Criteria

Top Customer Identification Challenge: Finding the Five Biggest Bookers

SQL Solution: Aggregation, Sorting, and Limiting to Find Top Customers

SQL Challenge: Discover the Most Frequently Screened Film in a Specific Room

SQL Solution: Finding Most Screened Film with Joins, Filtering and Aggregation

SQL Bookings Analysis: Count Customers with Reservations using DISTINCT

SQL Solution: Determining the Number of Customers Who Have Made a Booking

Examining Database Normalization Trade-offs for Performance Optimization

Source code

Old Course Information

Bonus Lecture and Information

Course Slides