Inner Join Explained (with Animation) - DataSkool

Inner Join Explained (with Animation) - DataSkool

Complete SQL Course – From Zero to Data Pro Inner Join Explained (with Animation)

Complete SQL Course – From Zero to Data Pro

0% Completed

Module 1 – Introduction to Databases & SQL

Introduction to Databases

Video - 00:2:00 mins

What is SQL & How Databases Work

Video - 00:1:58 mins

SQL Basic Concepts

Video - 00:1:58 mins

Setting Up Google Colab for SQL

Video - 00:3:00 mins

How to study this course

Video - 00:00:00 mins

Practice: SELECT & FROM Statements

Video - 00:9:56 mins

Working with Text Data Type

Video - 00:1:3 mins

Working with (Date)Data Type

Video - 00:00:36 mins

Filtering Data Using WHERE Conditions

Video - 00:2:59 mins

Quiz 1 – SQL Basics

Module 2 – SQL Data Aggregation

Introduction to Aggregate Functions

Video - 00:5:49 mins

Using Aliases in SQL

Video - 00:1:34 mins

Data Aggregation with Group By

Video - 00:5:17 mins

AVG() Function Practice

Video - 00:2:14 mins

How to Search on SQL Functions on W3Schools Website

Video - 00:2:30 mins

Using HAVING for Groups Filtering

Video - 00:8:49 mins

CASE WHEN Statement (Advanced SQL)

Video - 00:8:39 mins

Practice: CASE WHEN & Aggregation

Video - 00:4:9 mins

Combined Practice: CASE WHEN + WHERE + Aggregation

Video - 00:4:56 mins

Case When Deep Analysis

Video - 00:3:3 mins

How to solve quizzes and Graduation Project in this course

Quiz 2 – SQL Aggregation

Module 3 – Subqueries & Joins

Introduction to Subqueries

Video - 00:7:00 mins

Subquery Practice

Video - 00:10:24 mins

Introduction to Joins

Video - 00:2:16 mins

SQL Databases types introduction

Video - 00:2:37 mins

Introduction to SQL Server Management Studio (SSMS)

Video - 00:5:29 mins

Setup Microsoft SQL Server on your Computer

Video - 00:1:22 mins

Importing Databases into SSMS

Video - 00:1:49 mins

Inner Join Explained (with Animation)

Video - 00:1:30 mins

Practice on inner join

Video - 00:5:17 mins

Join Types Overview

Video - 00:2:13 mins

Left Join Explained (with Animation)

Video - 00:1:26 mins

Practice on Left join

Video - 00:4:59 mins

Right Join Explained (with Animation)

Video - 00:1:1 mins

Practice on Right Join

Video - 00:2:8 mins

Full Outer Join Practice

Video - 00:1:46 mins

Self Join Explained (with Animation)

Video - 00:3:16 mins

Practice on Self Join Interview question [Part 1]

Video - 00:5:20 mins

Practice on Self Join Interview question [Part 2]

Video - 00:3:20 mins

cross join (Use Case 1) practice

Video - 00:2:48 mins

cross join (Use Case 2) practice

Video - 00:3:41 mins

Video - 00:3:38 mins

The difference between Union and Union All

Video - 00:1:50 mins

Quiz 3 – Subqueries & Joins

Module 4 – Advanced SQL: Window Functions

introduction to window functions

Video - 00:13:17 mins

Nth Rank using Row_Number()

Video - 00:4:10 mins

Row_Number() with partition by and order by

Video - 00:4:7 mins

CTE Commen table Expresion

Video - 00:2:53 mins

Quiz 4 – Window Functions

Module 5 – Database Management (DDL & DML)

How to create tables in the Database [Method 1]

Video - 00:8:38 mins

How to create tables in Database [Method 2]

Video - 00:6:58 mins

How to Modify the table structure (adding, deleting, renaming cols ..etc)

Video - 00:2:35 mins

How to insert data into a table [Method 1]

Video - 00:3:38 mins

How to insert data into tables [Method 2]

Video - 00:1:54 mins

How to delete rows from a table

Video - 00:1:3 mins

How to update the values inside a table

Video - 00:2:9 mins

SQL Graduation Project

Announcements Reviews Live Classes Gradebook Certificate Course Info

Scroll to Top