Library/SQL Ultimate Course

Published

Start Reading Chapter 1

TechnologySQLYouTube Playlist CourseBeginner

16 hrs 20 mins

55 Chapters

SQL Ultimate Course

By Data with Baraa

Master database management from the ground up with this comprehensive guide to SQL. Learn essential querying techniques, advanced table joins, and powerful data manipulation functions using SQL Server and SSMS.

Table of Contents

SQL Ultimate Course

Table of Contents

How I Would Learn SQL (If I Could Start Over in 2025) | #SQL Course 1

What is SQL (Visually Explained) | #SQL Course 2

Install SQL Server & SSMS 2026 | Create Your First Database (Beginner Guide) | #SQL Course 3

SQL SELECT Queries (Visually Explained) for Beginners | All Essential Clauses | #SQL Course 4

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

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

SQL WHERE Conditions (Visually Explained) | AND, OR, NOT, LIKE, BETWEEN, IN | #SQL Course 7

SQL Joins Basics (Visually Explained) | INNER, LEFT, RIGHT, FULL | #SQL Course 8

Advanced SQL Joins (Visually Explained) | ANTI, CROSS | #SQL Course 9

Joining Multiple Tables in SQL (Visually Explained) | 3+ Table Joins | #SQL Course 10

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

SQL Functions (Visually Explained) | In 5 Minutes | #SQL Course 12

SQL String Functions (Visually Explained) | A Detailed Guide | #SQL Course 13

SQL Number Functions (Visually Explained) | ROUND, ABS | #SQL Course 14

SQL Date & Time Functions | DATEPART, DATENAME, DATETRUNC, EOMONTH | #SQL Course 15

SQL Date & Time Functions (Visually Explained) | FORMAT, CONVERT, CAST | #SQL Course 16

SQL Date & Time Functions (Visually Explained) | DATEADD, DATEDIFF, ISDATE | #SQL Course 17

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

SQL NULL vs Empty String vs Blank Space (Visually Explained) | #SQL Course 19

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

SQL Aggregate Functions | COUNT, SUM, AVG, MAX, MIN | #SQL Course 21

SQL Window Functions Basics (Visually Explained) | PARTITION BY, ORDER BY, FRAME | #SQL Course 22

SQL Aggregate Window Functions | COUNT, AVG, SUM, MAX, MIN | #SQL Course 23

SQL Ranking Window Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE | #SQL Course 24

SQL Value Window Functions | LEAD, LAG, FIRST_VALUE, LAST_VALUE | #SQL Course 25

5 SQL Techniques You Need in Every Project (Visually Explained) | #SQL Course 26

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

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

SQL Views (Visually Explained) | 6 Top Use Cases | #SQL Course 29

SQL CTAS | How to Create SQL Tables From a Query | #SQL Course 30

SQL Temp Tables (Visually Explained) | #SQL Course 31

SQL Subquery vs CTE vs Views vs CTAS vs TEMP | #SQL Course 32

SQL Indexes (Visually Explained) | Clustered vs Nonclustered | #SQL Course 35

SQL Columnstore Index (Visually Explained) | Columnstore vs Rowstore | #SQL Course 36

SQL Unique & Filtered Indexes (Visually Explained) | #SQL Course 37

How to Choose the Right Index (Visually Explained) | #SQL Course 38

SQL Index Maintenance | 5 Things to Do after Creating Indexes | SQL Statistics | #SQL Course 39

SQL Execution Plans (Visually Explained) | SQL Hints | #SQL Course 40

My Indexing Strategy for Every SQL Project | Indexing Best Practices | #SQL Course 41

SQL Table Partitioning (Visually Explained) | Optimize Big Table Performance | #SQL Course 42

30 SQL Tips and Tricks From 18 Years of Experience | #SQL Course 43

SQL Stored Procedure (Visually Explained) | Comprehensive Guide | #SQL Course 33

SQL Triggers (Visually Explained) | Audit Logs Use Case | #SQL Course 34

How I Use ChatGPT & GitHub Copilot in My Projects | #SQL Course 44

Intro To SQL Project | Data Engineer Portfolio Project | #SQL Project 1

Data Warehouse Basics Visually Explained | Data Engineer Portfolio Project | #SQL Project 2

ETL Process Visually Explained | Data Engineer Portfolio Project | #SQL Project 3

Notion Project Plan & Set Up Your Environment | Data Engineer Portfolio Project | #SQL Project 4

Design Data Architecture for Your Data Warehouse | Data Engineer Portfolio Project | #SQL Project 5

Project Setup: Git, Naming & Database Creation | Data Engineer Portfolio Project | #SQL Project 6

Build The Bronze Layer: Data Ingestion | Data Engineer Portfolio Project | #SQL Project 7

Build The Silver Layer: Cleanse & Transform Data | Data Engineer Portfolio Project | #SQL Project 8

Building The Gold Layer: Star Schema Modeling | Data Engineer Portfolio Project | #SQL Project 9

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

SQL Data Analyst Portfolio Project | Like I Do in My Real Projects