Data with Baraa · 53 min · beginner · English

SQL NULL Functions | COALESCE, ISNULL, NULLIF, IS (NOT) NULL | #SQL Course 18

Data with Baraa · 36 min · beginner · English

SQL CASE WHEN Statement (Visually Explained) | #SQL Course 20

Data with Baraa · 14 min · beginner · English

10 SQL Projects for your Data Analyst Portfolio/Resume! Must DO

Different angle: concrete SQL portfolio project ideas to showcase on GitHub and in applications.

Luke Barousse · 16 min · beginner · English

How to Write a PERFECT Data Analyst Resume (To Get a Job!)

Packaging skills and projects into a credible, quantified resume that lands interviews.

Database Star · 9 min · intermediate · English

How to Limit Rows in SQL | LIMIT vs TOP vs FETCH FIRST

Hands-on dialect gotcha: LIMIT (MySQL/Postgres) vs TOP (SQL Server) vs FETCH FIRST across engines.

Studytonight with Abhishek · 11 min · intermediate · English

SIMPLY EXPLAINED: MYSQL vs POSTGRESQL vs SQL SERVER

Compares the three engines the role targets — strengths, use cases, and where they differ.

Interview Kickstart · 12 min · intermediate · English

Database Engineer Interview Questions and Answers | How To Ace Your Interview Successfully

Different angle: spoken Q&A on normalization, indexing, and performance tuning to practice answering verbally.

Interview Pen · 22 min · intermediate · English

Databases in system design: SQL vs NoSQL, ACID vs BASE, Indexing, Sharding & Partitioning

Articulates ACID, indexing, and SQL-vs-NoSQL design tradeoffs the way a design interview probes them.

BeardedDev · 16 min · advanced · English

GAPS and ISLANDS in SQL Server

Different angle: the gaps-and-islands / consecutive-sequence pattern that trips up most candidates, solved with window functions.

Apna College · 28 min · intermediate · English

Top SQL interview Questions and Answers | Most Asked SQL Questions for Job interview

Walks the recurring SQL interview problem types (ranking, top-N, joins, aggregation) and how to map a question to the right tool.

Amlan Mohanty · 33 min · intermediate · English

Build SQL Data Analyst Portfolio Project Step-by-Step Guide with Real Zepto Data

Second portfolio project on real Zepto data — end-to-end SQL analysis to showcase.

Data with Baraa · 51 min · intermediate · English

SQL Exploratory Data Analysis (EDA) Project | Full Hands-On Portfolio Project

Full hands-on, portfolio-ready SQL EDA project to document and publish.

WsCube Tech · 60 min · intermediate · English

SQL For Data Analysis Full Portfolio Project with Practical [1Hour] | End-to-End SQL Project 2024

Hands-on portfolio project: load data and answer real business questions with advanced SQL (joins, aggregations, CTEs/window functions).

Database Star · 16 min · intermediate · English

eCommerce Database Design: Diagram & Explanation

Worked example applying the design process to a real e-commerce domain schema.

Jan Marshal · 23 min · intermediate · English

From Idea to Production-Ready Database Design (No More Mistakes!)

End-to-end workflow from domain requirements to a normalized, constrained, production-ready schema.

freeCodeCamp.org · 60 min · intermediate · English

SQL Server Stored Procedures & Triggers: The Ultimate Guide

Hands-on guide to packaging logic in the database with stored procedures and triggers (T-SQL), with audit-log style examples.

codebasics · 8 min · beginner · English

Difference Between SQL Views vs Materialized Views | Frequently Asked SQL Interview Question

Clear side-by-side of regular views vs materialized views: storage, freshness, and when to cache query logic.

Database Star · 15 min · intermediate · English

Understanding Explain and Explain Analyze in PostgreSQL

Walks through EXPLAIN vs EXPLAIN ANALYZE on Postgres and how to read the plan tree to diagnose slow queries.

Hussein Nasser · 24 min · intermediate · English

what is a database index?

Conceptual deep-dive on how indexes shrink the search space and the read/write trade-off, from a respected database-engineering educator.

Studytonight with Abhishek · 12 min · intermediate · English

SQL Transaction Isolation Levels Explained Simply

Optional deep dive: isolation levels, dirty/non-repeatable/phantom reads under concurrency

edureka! · 20 min · beginner · English

Transaction SQL tutorial | SQL Commit and Rollback | ACID Property in SQL | Edureka Rewind

Transactions, COMMIT/ROLLBACK and the four ACID properties

Knowledge 360 · 9 min · intermediate · English

PostgreSQL Upsert Using INSERT ON CONFLICT statement

Optional conflict-handling upsert via INSERT ... ON CONFLICT DO UPDATE

Data with Baraa · 25 min · beginner · English

SQL DML Commands (Visually Explained) | INSERT, UPDATE, DELETE | #SQL Course 6

Visual core DML: inserting, updating and safely deleting rows

Kishan Mashru · 18 min · beginner · English

SQL DDL Commands - CREATE, ALTER, DROP TABLE - DEMO - Using ORACLE

Optional hands-on demo executing DDL statements with data types in Oracle

Data with Baraa · 22 min · beginner · English

SQL DDL Commands (Visually Explained) | CREATE, ALTER, DROP | #SQL Course 5

Animated walkthrough of CREATE/ALTER/DROP TABLE and choosing data types

Lucid Software · 10 min · beginner · English

Entity Relationship Diagram (ERD) Tutorial - Part 2

Different angle: primary keys, foreign keys, and bridge tables in the context of ER modeling.

Database Star · 14 min · beginner · English

Primary Key and Foreign Key Constraints in SQL

Primary key and foreign key constraints with referential integrity explained in SQL.

Decomplexify · 28 min · intermediate · English

Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF

Clear, example-driven walkthrough of every normal form and the anomalies each one eliminates.

Decomplexify · 21 min · intermediate · English

Entity Relationship Diagrams

Deeper, methodical ER modeling: turning real-world requirements into entities, relationships, and cardinality.

Lucid Software · 12 min · beginner · English

Entity Relationship Diagram (ERD) Tutorial - Part 1

Core ERD concepts: entities, attributes, and relationships; how to translate requirements into an ER model.

Jess Ramos · 14 min · intermediate · English

How to calculate a RUNNING TOTAL and MOVING AVERAGE in SQL! (Window Frames Explained)

Different angle: ROWS BETWEEN window frames for running totals and moving averages.

Jess Ramos · 13 min · intermediate · English

Lead & Lag Window Functions in SQL (EXAMPLES INCLUDED)

LAG and LEAD for comparing a row to its neighbors; month-over-month / period-over-period analysis.

BeardedDev · 12 min · intermediate · English

SQL Tutorial - Window Functions - Ranking

Different angle: SQL Server ranking functions including NTILE bucketing with practical queries.

Jess Ramos · 16 min · intermediate · English

SQL Rank, Dense Rank, and Row Number Tutorial: Full Guide

Side-by-side comparison of ROW_NUMBER, RANK, and DENSE_RANK and how each handles ties within partitions; core for top-N / Nth-highest per group.

BeardedDev · 14 min · intermediate · English

SQL Tutorial - Window Functions

Different angle: hands-on SQL Server walkthrough of the OVER clause with PARTITION BY and ORDER BY.

Maven Analytics · 17 min · beginner · English

SQL Window Functions | Clearly Explained | PARTITION BY, ORDER BY, ROW_NUMBER, RANK, DENSE_RANK

Clear conceptual intro to OVER, PARTITION BY, ORDER BY by SQL Pocket Guide author Alice Zhao; shows how windows compute across rows without collapsing them.

Data with Baraa · 20 min · intermediate · English

SQL UNION vs UNION ALL: Advanced Set Operations (INTERSECT, EXCEPT)

Different-angle: UNION vs UNION ALL duplicate handling and performance

Data with Baraa · 30 min · intermediate · English

SQL SET Operators (Visually Explained) | UNION, UNION ALL, EXCEPT, INTERSECT | #SQL Course 11

Visual explanation of combining result sets vertically with all set operators

Learn at Knowstar · 14 min · advanced · English

Master Employee Hierarchy in SQL: Recursive CTE Explained with Examples

Different-angle: building an employee-manager org chart with a recursive CTE

BeardedDev · 18 min · advanced · English

SQL: Recursive CTE (Common Table Expression) and Its Usage in Hierarchical Data

Anchor + recursive member pattern for traversing hierarchical data

techTFQ · 25 min · intermediate · English

CTE in SQL (Common Table Expression) | SQL WITH Clause | CTE Query Performance | Advanced SQL

Different-angle: CTE vs subquery and query performance considerations

Data with Baraa · 35 min · intermediate · English

SQL CTE (Common Table Expression) Full Guide | WITH Clause | #SQL Course 28

Refactoring complex queries into readable WITH clauses

techTFQ · 30 min · intermediate · English

Subquery in SQL | Intermediate SQL tutorial | nested subquery

Different-angle: hands-on nested subqueries to break multi-step questions into pieces

Data with Baraa · 38 min · intermediate · English

SQL Subquery (Visually Explained) | Complete Guide with Correlated Subquery | #SQL Course 27

Visual walkthrough of scalar, multi-row, and correlated subqueries with IN/EXISTS usage

Joey Blue · 7 min · intermediate · English

Learn WHERE vs HAVING in SQL | SQL Interview Question

Clearly contrasts filtering rows (WHERE) before grouping vs filtering groups (HAVING) after GROUP BY.

SQL Training Online · 6 min · beginner · English

SQL Group By - SQL Training Online - Quick Tips Ep12

Short different-angle quick tip grouping data with aggregate functions in SQL Server.

Database Star · 16 min · beginner · English

Want to Master SQL GROUP BY? Watch This Now

Deep dive into computing aggregates per category with GROUP BY (and intro to HAVING).

Database Star · 14 min · beginner · English

Master SQL Aggregate Functions! COUNT, SUM, AVG, MAX, MIN | Beginner SQL Tutorial

Walks through COUNT, SUM, AVG, MIN, MAX with hands-on examples; includes GitHub SQL queries.

Data Engineering · 9 min · intermediate · English

SQL Interview - Employee Manager Hierarchy - Self Join

Different angle: classic employee/manager hierarchy self-join with table aliasing, framed as an interview question.

Joey Blue · 15 min · intermediate · English

Special SQL Joins Tutorial - Natural, Cross, and Self: SQL for Beginners

Directly covers CROSS JOIN (Cartesian product) and SELF JOIN, plus NATURAL JOIN, with hands-on examples.