Lecture 45: What are JOINS in SQL? Types of SQL JOINS

SQL Tutorial: Learn SQL with MySQL Database

Section 1: Introduction

What is SQL? (1:42)
Who should learn SQL? (1:09)
Quiz 1: Introduction

Section 2: Setup a Testing Environment

Download & Install MySQL 8.0.32 Database Server on Windows 11 (12:23)
Download & Install MySQL 8.0.32 Database Server on Windows 10 (12:37)
Download & Install MySQL 8.0.32 on macOS 12 Monterey (12:23)
Install MySQL 8.0.32 on Linux Ubuntu 22.04LTS (13:03)
How to add a new database user and add privileges (7:14)
Quiz 2: Setup a Testing Environment

Section 3: An Overview of SQL

Lecture 7: What is DBMS and RDBMS? (3:02)
Lecture 8: Difference between Database Engine, Database Server and Database Software (2:31)
Lecture 9: What is a database? How to create and use a database? (5:53)
Lecture 10: What is a database table? How to create and use a database table? (8:44)
Lecture 11: How to add the data rows to a database table? (7:19)
Lecture 12: Understand Keywords, Identifiers, Constants and Clauses (2:56)
Lecture 13: Learn about SQL Statements (1:30)
Lecture 14: Data Definition Language(DDL) and Data Manipulation Language(DML)? (2:34)
Quiz 3: An Overview of SQL

Section 4: Important SQL Clauses (Data Manipulation Language)

Lecture 15: Create example databases, tables and data rows (10:50)
Lecture 16: Learn about SQL SELECT Clause (5:33)
Lecture 17: SQL SELECT DISTINCT Statement (5:16)
Lecture 18: Learn about SQL FROM Clause (3:10)
Lecture 19: Learn about SQL WHERE Clause (4:56)
Quiz 4: Important SQL Clauses

Section 5: Conditions and Operators (Data Manipulation Language)

Lecture 20: SQL True Condition (4:18)
Lecture 21: SQL False Condition (4:42)
Lecture 22: SQL AND Operator (5:59)
Lecture 23: SQL OR Operator (6:58)
Lecture 24: SQL IN Operator (5:09)
Lecture 25: SQL EXISTS Condition (7:49)
Lecture 26: SQL NOT IN or NOT EXISTS? Conditions (4:48)
Lecture 27: SQL Comparison Operators (4:17)
Lecture 28: SQL LIKE Operator (5:40)
Lecture 29: SQL BETWEEN Operator (4:35)
Lecture 30: SQL Numeric Operators (4:14)
Lecture 31: SQL Concatenation Operator (2:22)
Lecture 32: SQL Temporal Operator (1:59)
Quiz 5: Conditions and Operators

Section 6: Data grouping, sorting, select and dates (Data Manipulation Language)

Lecture 33: Learn about SQL GROUP BY Clause (7:34)
Lecture 34: Learn about SQL HAVING Clause (5:45)
Lecture 35: Learn about SQL ORDER BY Clause (4:53)
Lecture 36: SQL LIMIT or TOP Clause (2:55)
Lecture 37: SQL Wildcards (4:56)
Lecture 38: SQL Aliases (6:05)
Lecture 39: SQL Dates (4:07)
Quiz 6: Data grouping, sorting, select and dates

Section 7: Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)

Lecture 40: Add the data rows in a table using INSERT INTO Statement (6:04)
Lecture 41: SQL INSERT INTO SELECT Statement (6:10)
Lecture 42: Update data rows using UPDATE Statement (7:10)
Lecture 43: Delete data rows using DELETE Statement (3:38)
Lecture 44: What is SQL Injection and How to secure a database? (5:49)
Quiz 7: Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)

Section 8: SQL JOINS (Data Manipulation Language)

Lecture 45: What are JOINS in SQL? Types of SQL JOINS (5:01)
Lecture 46: Learn about INNER JOIN in SQL (10:32)
Lecture 47: Learn about LEFT OUTER JOIN in SQL (7:31)
Lecture 48: Learn about RIGHT OUTER JOIN in SQL (7:32)
Lecture 49: Learn about FULL OUTER JOIN in SQL (3:52)
Lecture 50: Learn about CROSS JOIN in SQL (4:29)
Lecture 51: SQL UNION Operator (4:31)
Lecture 52: SQL VIEWS (8:12)
Lecture 53: Derived Tables or Inline Views (5:22)
Quiz 8: SQL JOINS (Data Manipulation Language)

Section 9: SQL Functions

Lecture 54: Functions in SQL and Types of SQL functions (1:17)
Lecture 55: SQL COUNT() Function (5:44)
Lecture 56: SQL FIRST() Function (2:26)
Lecture 57: SQL LAST() Function (2:47)
Lecture 58: SQL SUM() Function (2:52)
Lecture 59: SQL MIN() Function (3:27)
Lecture 60: SQL MAX() Function (3:14)
Lecture 61: SQL AVG() Function (3:12)
Lecture 62: SQL UCASE() Function (2:27)
Lecture 63: SQL LCASE() Function (2:13)
Lecture 64: SQL MID() Function (2:51)
Lecture 65: SQL LEN() Function (2:25)
Lecture 66: SQL ROUND() Function (3:23)
Lecture 67: SQL FORMAT() Function (2:48)
Lecture 68: SQL SUBSTRING() Function (3:05)
Lecture 69: SQL COALESCE() Function (2:43)
Lecture 70: SQL CHAR_LENGTH() Function (2:45)
Lecture 71: SQL CAST() Function (3:41)
Lecture 72: SQL CASE() Function (6:25)
Lecture 73: SQL NULLIF() Function (6:12)
Quiz 9: SQL Functions

Section 10: SQL Data Types

Lecture 74: What is data type in SQL? (2:04)
Lecture 75: Integer Numbers in SQL (Exact Values) (3:01)
Lecture 76: Fixed-Point Numbers in SQL (Exact Values) (3:30)
Lecture 77: Floating-Point Numbers in SQL (Approximate Values) (3:12)
Lecture 78: CHAR and VARCHAR in SQL (String Values) (2:47)
Lecture 79: NCHAR and NVARCHAR in SQL (String Values) (1:12)
Lecture 80: CLOB and BLOB in SQL (String Values) (0:57)
Lecture 81: DATE, TIME and TIMESTAMP in SQL (Temporal Values) (1:33)
Quiz 10: SQL Data Types

Section 11: Data Definition Language

Lecture 82: Learn how to create and display databases (4:11)
Lecture 83: Select and use existing database (2:45)
Lecture 84: Remove or delete database from database management system (2:57)
Lecture 85: Learn how to create the database table using right method (3:41)
Lecture 86: Modify or update the database table details (6:10)
Lecture 87: Remove or delete an existing table (2:16)
Lecture 88: Understand Constraints in SQL (1:00)
Lecture 89: NOT NULL Constraint in SQL (8:05)
Lecture 90: UNIQUE Constraint in SQL (6:46)
Lecture 91: PRIMARY KEY Constraint in SQL (3:23)
Lecture 92: FOREIGN KEY Constraint in SQL (10:32)
Lecture 93: CHECK Constraint in SQL (0:55)
Lecture 94: DEFAULT Constraint in SQL (4:19)
Lecture 95: AUTO INCREMENT or SEQUENCE in SQL (4:03)
Quiz 11: Data Definition Language

Section 12: Data Control Language (DCL)

Lecture 96: What is Data Control Language (DCL) (0:57)
Lecture 97: The GRANT statement (14:45)
Lecture 98: The REVOKE statement (6:11)

Section 13: Transaction Control Language (TCL)

Lecture 99: What is Transaction Control Language (TCL) (3:35)
Lecture 100: The COMMIT statement (6:30)
Lecture 101: The ROLLBACK statement (14:29)
Lecture 102: The SAVEPOINT statement (10:09)
Lecture 103: The SET autocommit (5:07)

Section 14: Database Relationships

Lecture 104: Understand Database Relationship in SQL (1:43)
Lecture 105: One-to-One (1:1) Relationship in SQL (8:45)
Lecture 106: One-to-Many (1:M) Relationship in SQL (5:27)
Lecture 107: Many-to-Many (M:M) Relationship in SQL (7:08)
Quiz 12: Database Relationships

Section 15: Database Normalization

Lecture 108: What is Database Normalization in SQL? (2:32)
Lecture 109: First Normal Form (1NF) in database normalization (1:14)
Lecture 110: Second Normal Form (2NF) in database normalization (1:30)
Lecture 111: Third Normal Form (3NF) in database normalization (1:19)
Quiz 13: Database Normalization

Section 16: SQL Database Export and Import

Lecture 112: What is SQL Export and Import? (1:17)
Lecture 113: How to Export the database using SQL statement (8:32)
Lecture 114: How to Import the database using SQL statement (5:16)
Quiz 14: SQL Database Export and Import

Section 17: MySQL Workbench

Lecture 115: What is MySQL Workbench? (5:14)
Lecture 116: Create a new user and connect to database using MySQL Workbench (4:20)
Lecture 117: Create, Alter, Drop database using MySQL Workbench (3:38)
Lecture 118: Create, Alter, Drop table using MySQL Workbench (7:34)
Lecture 119: Insert, Read, Update, Delete data rows using MySQL Workbench (4:19)
Lecture 120: Database Export and Import using MySQL Workbench (8:07)
Quiz 15: MySQL Workbench

Section 18: Uninstall MySQL 8 Database from Windows, MAC & Linux Operating System

Uninstall MySQL 8 database server from Windows 10 operating system (9:10)
Uninstall MySQL 8 database server from Windows 11 operating system (9:13)
Uninstall MySQL 8 database server from MacOS operating system (5:35)
Uninstall MySQL 8 database server from Linux Ubuntu operating system (7:27)

Section 19: Additional Lectures (OLD / Outdated Lectures)

Extra: Download & Install MySQL 8.0.11 on Windows 10 Operating System (16:33)
Extra: Install MySQL 5.7.20 database server on Windows 10 operating system
Extra: Install MySQL 5.7.10 database server on Windows operating system (13:31)
Extra: Install MySQL 5.7.20 database server on Mac operating system (12:32)
Extra: Install MySQL 5.7.10 database server on Mac operating system (12:49)
Extra: Install MySQL 5.7.20 database server on Linux operating system (6:28)
Extra: Install MySQL 5.7.10 database server on Linux operating system (6:58)
Extra: MySQL Command Line Client shortcut for Windows users (6:40)

Section 20: Thank You!

Thank You! (1:20)

Lecture 45: What are JOINS in SQL? Types of SQL JOINS

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock