SQL for Beginners: Learn SQL using MySQL and Database Design

Course Introduction

Comprehensive Course Introduction to SQL, MySQL, and Database Concepts 07:09

• Lecture
  Your Journey from Beginner to SQL Expert with 40+ Years Experience 01:58
• Lecture
  Complete SQL Course Roadmap: Breakdown of Sections, Topics, and Learning Path 05:11

MySQL & Workbench: Complete Installation, Setup, and First SQL Queries 01:18:23

• Lecture
  Syllabus Explanation 03:42
• Lecture
  Section Introduction: Databases, SQL, MySQL, and DBMS Explained in Detail 01:02
• Lecture
  Databases, SQL, and MySQL: Understanding the Core Concepts and Relationships 04:36
• Lecture
  Deep Dive into Relational Database Management Systems (RDBMS) and MySQL 02:44
• Lecture
  Step-by-Step MySQL Installation Guide for Windows: Server and Workbench Setup 21:47
• Lecture
  Comprehensive MySQL Installation Guide for Mac: Server and Workbench Setup 13:30
• Lecture
  Complete MySQL Installation Guide for Linux (Ubuntu): Server and Workbench 12:10
• Lecture
  MySQL Workbench Interface: Navigating, Configuring, and Query Execution 12:32
• Lecture
  Creating Your First Database: Hands-On SQL Query Execution and Database Usage 06:20

Mastering Database Structure with Data Definition Language in MySQL 36:26

• Lecture
  Introduction to Data Definition Language (DDL) and Data Manipulation Language (D 02:50
• Lecture
  Comprehensive Guide to MySQL Data Types: Integers, Floats, Decimals, and More 10:12
• Lecture
  Understanding Primary and Foreign Keys: The Key to Relational Database Design 07:12
• Lecture
  Step-by-Step Guide: Creating the Coffee Store Database and Tables in MySQL 11:35
• Lecture
  Modifying Tables: Adding and Removing Columns in your Database using ALTER 04:37

Installation and Setup 01:49

• Lecture
  Efficiently Deleting All Data in a Table with the TRUNCATE TABLE Command 01:49

Mastering the ALTER TABLE Command in MySQL: Comprehensive Guide 37:48

• Lecture
  Introduction to Advanced Table Alteration Techniques in MySQL 01:12
• Lecture
  Hands-On: Creating a Dedicated MySQL Practice Database for Testing 04:35
• Lecture
  Adding and Removing Primary Keys in MySQL Tables: A Step-by-Step Guide 05:36
• Lecture
  Foreign Keys in MySQL: Adding, Removing, and Understanding Relationships 06:10
• Lecture
  Implementing Unique Constraints on MySQL Table Columns for Data Integrity 03:07
• Lecture
  How to Rename Columns in MySQL Tables: Best Practices and Techniques 03:23
• Lecture
  Modifying Column Data Types in MySQL: A Comprehensive Tutorial 05:16
• Lecture
  Alter Table Exercises: Apply Your Knowledge with Six Practical Challenges 01:30
• Lecture
  Section Introduction 00:41
• Lecture
  Comprehensive Solutions and Explanations for Alter Table Challenges 06:18

Mastering SQL Data Manipulation: Insert, Update, and Delete Operations 17:56

• Lecture
  SQL Data Manipulation Language (DML) Fundamentals: Section Introduction 00:53
• Lecture
  Inserting Data into SQL Database Tables: Comprehensive Practical Guide 07:15
• Lecture
  Comprehensive Guide to Updating Existing Data in SQL Database Tables 04:45
• Lecture
  Deleting Data from SQL Tables: Single, Multiple, and All Rows Deletion 02:51
• Lecture
  Populating the Coffee Store Database: A Complete Data Insertion Guide 02:12

Mastering SELECT Queries: Filtering, Sorting, and Refining Data Retrieval 01:06:40

• Lecture
  Introduction to Retrieving Data: SELECT Statement Fundamentals in SQL 02:17
• Lecture
  Mastering the SELECT Statement: Retrieving Data from SQL Database Tables 01:34
• Lecture
  Filtering Data with WHERE Clauses: Enhancing SQL Query Precision 04:24
• Lecture
  Databases, SQL and MySQL 03:08
• Lecture
  Using Inequality Operators in SQL WHERE Clauses: A Comprehensive Guide 04:59
• Lecture
  Handling NULL Values in SQL: IS NULL and IS NOT NULL in WHERE Clauses 02:18
• Lecture
  Practice Retrieving, and Filtering Data - Exercise Set 1 for Section 6 00:54
• Lecture
  Solutions and Explanations: Exercise Set 1 for Section 6 on Filtering 03:12
• Lecture
  Filtering Data with IN and NOT IN Operators in SQL WHERE Clauses 03:10
• Lecture
  Using the BETWEEN Operator for Range Queries in SQL: Dates, Numbers, Strings 04:40
• Lecture
  Pattern Matching with LIKE in SQL: Wildcards for Flexible Data Filtering 05:27
• Lecture
  Sorting Query Results with ORDER BY in SQL: Ascending and Descending 06:01
• Lecture
  Practice Using IN, NOT IN, Between and Like Operators - Exercise Set 2 00:47
• Lecture
  Solutions and Explanations: Exercise Set 2 for Section 6 on Filtering 04:57
• Lecture
  Selecting DISTINCT Values in SQL: Removing Duplicate Data from Results 04:29
• Lecture
  Relational Database Management System 02:18
• Lecture
  Controlling Result Set Size with LIMIT and OFFSET in SQL Queries 05:17
• Lecture
  Improving Readability with Column Name Aliases in SQL Queries 02:33
• Lecture
  Practice Using Distinct, Limit and Aliases - Exercise Set 3 for Section 6 00:57
• Lecture
  Comprehensive Review and Solutions - Exercise Set 3 for Section 6 03:18

Mastering Multi-Table Queries with MySQL: Comprehensive Guide to All JOIN Types 49:33

• Lecture
  Introduction to the Comprehensive World of Selecting Data from Multiple Tables 01:08
• Lecture
  Understanding SQL JOINs: How to Retrieve Data from Multiple Tables in MySQL 03:39
• Lecture
  Mastering INNER JOINs: The Ultimate Guide to Retrieving Matching Data in MySQL 08:40
• Lecture
  LEFT JOIN in MySQL: How to Retrieve All Data from the Left Table Effectively 06:14
• Lecture
  RIGHT JOIN in MySQL: Guide to Retrieving All Data from the Right Table in Querie 03:12
• Lecture
  Advanced SQL: Mastering Joins Across Three or More Tables in MySQL Database 04:12
• Lecture
  MySQL Installation for Windows 15:00
• Lecture
  Applying JOIN Knowledge in MySQL with Practical Database Queries 00:58
• Lecture
  Step-by-Step Solutions: Mastering JOIN Queries in MySQL Exercise Walkthrough 03:18
• Lecture
  Visualizing Databases: Create Entity Relationship Diagrams in MySQL Workbench 03:12

Database Design Fundamentals and Normalization Techniques 49:39

• Lecture
  Introduction to Database Design Concepts and Principles 01:31
• Lecture
  Database Normalization Explained: Organizing Data for Efficiency 05:43
• Lecture
  First Normal Form (1NF): Rules for Eliminating Data Duplication 03:22
• Lecture
  Second Normal Form: Ensuring Data Dependency on the Primary Key 05:47
• Lecture
  Third Normal Form (3NF): Optimizing Data Relationships in Detail 08:14
• Lecture
  Understanding Relationships Between Tables in Relational Databases 00:57
• Lecture
  One-to-One Relationships: Definition, Examples, and Diagrams 02:55
• Lecture
  MySQL Installation for Mac 12:17
• Lecture
  One-to-Many Relationships: Most Common Database Links Explained 01:53
• Lecture
  Many-to-Many Relationships: Using Junction Tables Effectively 03:55
• Lecture
  Using Constraints: Not Null, Unique, Primary & Foreign Key, Check 03:05

Build a Full Cinema Booking System Database: Design & Implementation 50:10

• Lecture
  Project Kickoff: Building a Cinema Booking System Database in MySQL 01:06
• Lecture
  Cinema Booking Database ERD: Understanding Tables and Relationships 07:14
• Lecture
  Implementing the Films Table: Primary Key, Unique Constraints, and Data Types 04:00
• Lecture
  Constructing the Customers Table: Designing Fields for Optimal Data Capture 03:14
• Lecture
  Creating the Rooms Table: Defining the Physical Spaces in the Cinema 02:30
• Lecture
  Building the Screenings Table: Foreign Keys, Relationships, and Data Types 04:04
• Lecture
  Designing the Seats Table: Managing Seat Rows, Numbers, and Room Allocation 03:53
• Lecture
  MySQL Installation for Linux 11:07
• Lecture
  Creating the Bookings Table: Linking Customers, Screenings, and Reservations 03:39
• Lecture
  Building the Reserved Seats Junction Table: Many-to-Many Relationships 04:05
• Lecture
  Populating the Database: Inserting Data into all Seven Tables in Correct Order 05:18

Mastering SQL Aggregate Functions: COUNT, SUM, MIN, MAX, AVG, GROUP BY, HAVING 49:59

• Lecture
  Introduction to SQL Aggregate Functions: COUNT, SUM, MIN, MAX, AVG and More 00:52
• Lecture
  Understanding Aggregate Functions: Perform Calculations and Return Single Values 02:22
• Lecture
  Using the COUNT Function: Count Rows and Handle NULL Values in SQL Queries 02:30
• Lecture
  Mastering the SUM Function: Calculate Totals of Numeric Columns in Your Database 02:29
• Lecture
  Using MIN and MAX Functions: Find Lowest and Highest Values in a SQL Column 02:17
• Lecture
  Calculate Data Averages: Using the AVG Aggregate Function with WHERE Clauses 01:36
• Lecture
  Practice Aggregate Functions: Hands-On Exercises for COUNT, SUM, MIN, and MAX 00:54
• Lecture
  MySQL Workbench Overview 13:13
• Lecture
  Step-by-Step Solutions for Aggregate Function Exercises: COUNT, joins, Dates 04:02
• Lecture
  Mastering the GROUP BY Clause: Aggregate Data by One or More Columns in SQL 06:56
• Lecture
  Filtering Grouped Data with the HAVING Clause: A WHERE Clause Alternative 03:49
• Lecture
  Advanced Exercises: Combining GROUP BY, HAVING, and WHERE Clauses in SQL 01:17
• Lecture
  Comprehensive Solutions and Explanations for Advanced SQL Exercises (GROUP BY) 07:42

Mastering SQL Subqueries for Advanced Database Operations 31:08

• Lecture
  Introduction to Subqueries: Enhance SQL Skills 00:42
• Lecture
  Comprehensive Guide to Subqueries Types in MySQL 04:04
• Lecture
  Mastering Non-Correlated Subqueries in WHERE Clauses 05:02
• Lecture
  Using Non-Correlated Subqueries with FROM for Max/Avg 04:52
• Lecture
  Deep Dive into Correlated Subqueries in MySQL 04:31
• Lecture
  Create Database 03:23
• Lecture
  Subquery Practice: Exercises for Non-Correlated Types 01:18
• Lecture
  Complete Solutions for Subquery Exercises: Step-by-Step 07:16

Essential MySQL String and Date Functions for Data Handling 31:27

• Lecture
  Introduction to MySQL Functions: String and Date 01:01
• Lecture
  Understanding MySQL Functions: Parameters and Values 01:55
• Lecture
  Mastering String Concatenation with the CONCAT Function 05:46
• Lecture
  Extracting Substrings: A Detailed Guide to the SUBSTRING Function 08:25
• Lecture
  String Case Conversion: Using UPPER and LOWER Functions 03:03
• Lecture
  String Functions Practice: Exercises in MySQL 01:19
• Lecture
  String Functions Practice: Exercises in MySQL 09:58

Data Definition Language 10:50

• Lecture
  Extracting Month Data with the MONTH Function in MySQL 04:55
• Lecture
  Using the YEAR Function for Efficient Year-Based Filtering 02:20
• Lecture
  Date and Time Functions: Hands-On Practice Exercises 00:45
• Lecture
  Date and Time Functions: Exercise Walkthrough 02:50

Mastering SQL Challenges: Joins, Subqueries, and Functions 35:11

• Lecture
  Kickstart Your SQL Prowess with our Practical Challenge Section Introduction 00:57
• Lecture
  SQL Challenge: Retrieving Films with a Duration Exceeding Two Hours 00:28
• Lecture
  SQL Solution and Query Walkthrough for Two Hour Plus Film Retrieval 01:31
• Lecture
  Advanced SQL Challenge: Identifying the Film with the Most Screenings 01:30
• Lecture
  SQL Solution: Multi-Level Subqueries for Maximum Screenings Identification 06:17
• Lecture
  Section Introduction 01:32
• Lecture
  SQL Challenge: Analyzing May 2022 Bookings for the film "Jigsaw" 00:25
• Lecture
  SQL Solution: Subqueries and Joins to Count Bookings for Specific Criteria 04:47
• Lecture
  Top Customer Identification Challenge: Finding the Five Biggest Bookers 00:25
• Lecture
  SQL Solution: Aggregation, Sorting, and Limiting to Find Top Customers 03:00
• Lecture
  SQL Challenge: Discover the Most Frequently Screened Film in a Specific Room 00:31
• Lecture
  SQL Solution: Finding Most Screened Film with Joins, Filtering and Aggregation 06:18
• Lecture
  SQL Bookings Analysis: Count Customers with Reservations using DISTINCT 00:33
• Lecture
  SQL Solution: Determining the Number of Customers Who Have Made a Booking 02:50
• Lecture
  Examining Database Normalization Trade-offs for Performance Optimization 04:07

Extra Information - Source code, and other stuff 32:45

• Lecture
  Source code 02:39
• Lecture
  Old Course Information 00:36
• Lecture
  Bonus Lecture and Information 04:49
• Lecture
  Course Slides 00:05
• Lecture
  Data Types 06:34
• Lecture
  Primary and Foreign Keys 02:53
• Lecture
  Creating the Coffee Store Database 08:54
• Lecture
  Modifying Tables: Adding and Removing Columns 03:08
• Lecture
  Deleting Tables 01:28
• Lecture
  Truncating Tables 01:39

More On Alter Table 38:37

• Lecture
  Section Introduction 01:25
• Lecture
  Creating Our Test Database 05:30
• Lecture
  Add and Remove Primary Key 05:25
• Lecture
  Add and Remove Foreign Key 04:56
• Lecture
  Add Unique Constraint 03:25
• Lecture
  Change Column Name 03:15
• Lecture
  Change Column Data Type 04:44
• Lecture
  Exercise 1 01:30
• Lecture
  Solution 1 08:27

Data Manipulation Language 18:01

• Lecture
  Section Introduction 00:50
• Lecture
  Inserting Data Into Tables 05:37
• Lecture
  Updating Data in Tables 06:07
• Lecture
  Deleting Data from Tables 02:49
• Lecture
  Completing the Coffee Store Database 02:38

Selecting from a Table 58:09

• Lecture
  Section Introduction 01:14
• Lecture
  Select Statement 01:46
• Lecture
  Where Clause 04:53
• Lecture
  Using Inequality Symbols 03:03
• Lecture
  Null Values 03:10
• Lecture
  Exercise 1 01:06
• Lecture
  Solution 1 03:55
• Lecture
  In, Not In 03:44
• Lecture
  Between 04:04
• Lecture
  Like 04:52
• Lecture
  Order By 06:19
• Lecture
  Exercise 2 00:55
• Lecture
  Solution 2 04:23
• Lecture
  Distinct 05:11
• Lecture
  Limit 02:56
• Lecture
  Column Name Alias 02:03
• Lecture
  Exercise 3 00:50
• Lecture
  Solution 3 03:45

Selecting From Multiple Tables 33:23

• Lecture
  Section Introduction 01:08
• Lecture
  What Are Joins? 03:08
• Lecture
  Inner Join 08:55
• Lecture
  Left Join 05:23
• Lecture
  Right Join 03:15
• Lecture
  Joining more than Two Tables 04:33
• Lecture
  Exercise 1 01:06
• Lecture
  Solution 1 05:55

Database Design 39:41

• Lecture
  Section Introduction 01:23
• Lecture
  Normalization - What is it? 05:23
• Lecture
  1st Normal Form (1NF) 03:30
• Lecture
  2nd Normal Form (2NF) 06:27
• Lecture
  3rd Normal Form (3NF) 09:30
• Lecture
  Relationships 01:05
• Lecture
  Relationships - One to One 02:30
• Lecture
  Relationships - One to Many 02:00
• Lecture
  Relationships - Many to Many 04:00
• Lecture
  Constraints 03:53

Creating a Cinema Booking System Database 41:11

• Lecture
  Section Introduction 01:11
• Lecture
  Database Schema Overview 07:26
• Lecture
  Create Films Table 04:55
• Lecture
  Create Customers Table 02:53
• Lecture
  Create Rooms Table 02:19
• Lecture
  Create Screenings Table 04:45
• Lecture
  Create Seats Table 03:53
• Lecture
  Create Bookings Table 03:52
• Lecture
  Create Reserved_Seat Table 04:35
• Lecture
  Insert the Data 05:22

Aggregate Functions 33:39

• Lecture
  Section Introduction 00:41
• Lecture
  What are Aggregate Functions 02:30
• Lecture
  Count 02:38
• Lecture
  Sum 02:36
• Lecture
  Min and Max 02:39
• Lecture
  Average 02:09
• Lecture
  Exercise 1 00:46
• Lecture
  Solution 1 04:09
• Lecture
  Grouping Data 08:52
• Lecture
  Having Clause 01:44
• Lecture
  Exercise 2 00:44
• Lecture
  Solution 2 04:11

Subqueries 28:40

• Lecture
  Section Introduction 00:32
• Lecture
  What Are Subqueries 04:11
• Lecture
  Non-Correlated Subqueries: Part 1 05:11
• Lecture
  Non-Correlated Subqueries: Part 2 05:47
• Lecture
  Correlated Subqueries 04:41
• Lecture
  Exercise 1 01:19
• Lecture
  Solution 1 06:59

MySQL Functions - String Functions and Date Functions 53:19

• Lecture
  Section Introduction 01:08
• Lecture
  What Are MySQL Functions? 01:46
• Lecture
  Concatenation 06:49
• Lecture
  Substrings 08:09
• Lecture
  Upper and Lower Case 03:50
• Lecture
  Exercise 1 01:12
• Lecture
  Solution 1 09:52
• Lecture
  Date Function 07:30
• Lecture
  Month Function 04:37
• Lecture
  Year Function 03:11
• Lecture
  Exercise 2 01:07
• Lecture
  Solution 2 04:08

Challenges 30:34

• Lecture
  Section Introduction 00:56
• Lecture
  Challenge One 00:27
• Lecture
  Solution One 01:51
• Lecture
  Challenge Two 00:22
• Lecture
  Solution Two 04:34
• Lecture
  Challenge Three 00:26
• Lecture
  Solution Three 03:31
• Lecture
  Challenge Four 00:26
• Lecture
  Solution Four 04:08
• Lecture
  Challenge Five 00:37
• Lecture
  Solution Five 07:20
• Lecture
  Challenge Six 00:38
• Lecture
  Solution Six 03:55
• Lecture
  Bonus - Please Watch! 00:48
• Lecture
  Check out Our Other 42 Udemy Courses! 00:35