SQL for Data Engineers: From Zero to Data Warehouse
Published 10/2026
Created by Harish Kollana
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All Levels | Genre: eLearning | Language: English + subtitle | Duration: 74 Lectures ( 6h 22m ) | Size: 1.6 GB
Learn T-SQL from your first SELECT to a Bronze-Silver-Gold warehouse, with 3 real data engineering projects.
What you’ll learn
⚡ Write SQL queries to filter, sort, group, join and combine data from multiple tables in SQL Server.
⚡ Clean and transform raw data using text, number, date, NULL and CASE functions.
⚡ Analyze trends and rankings with aggregate and window functions, subqueries and CTEs.
⚡ Build and optimize a data warehouse with views, stored procedures, indexes, partitions and a Medallion architecture.
Requirements
❗ None. Comfort using a Windows PC and installing software is enough. A Mac user needs a Windows VM or Azure SQL / Docker to run SQL Server.
Description
This course contains the use of artificial intelligence.
SQL is the most requested skill in data engineering, data analytics and business intelligence job postings. This course takes you from "what is a database?" to building a production-style data warehouse, one small lesson at a time.
You start with the foundations: data, databases, DBMS, tables and the five types of SQL commands. Then you write real queries with SELECT, WHERE, GROUP BY, HAVING and ORDER BY, and learn why SQL executes in a different order than you write it. You create and change tables with DDL, load and fix data with INSERT, UPDATE and DELETE, and combine tables with INNER, LEFT, RIGHT and FULL joins plus UNION, INTERSECT and EXCEPT.
Next you clean messy text, numbers and dates, handle NULLs, and write CASE logic. You master aggregate and window functions: running totals, moving averages, ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG and LEAD. You structure complex logic with subqueries, CTEs and recursive CTEs, and package it as views, temp tables, stored procedures and triggers with error handling.
Finally you make queries fast with indexes, execution plans and partitioning, learn 30 pro tips, and use AI as a SQL co-pilot. Three capstones tie it together: a source data audit, a sales analytics layer, and a Medallion (Bronze, Silver, Gold) warehouse with SCD Type 1 and Type 2 dimensions.
Every lesson is visual and animated, every query is runnable, and interview questions are called out along the way.
Who this course is for
⭐ Anyone Who wants to be in Data Domain
https://www.uploadcloud.pro/q33joidc4a9i/SQL_for_Data_Engineers_From_Zero_to_Data_Warehouse.part2.rar.html
https://www.uploadcloud.pro/0lr1kdc6csuf/SQL_for_Data_Engineers_From_Zero_to_Data_Warehouse.part1.rar.html
https://rapidgator.net/file/7b127106910f99f1d5e155c27ad19d45/SQL_for_Data_Engineers_From_Zero_to_Data_Warehouse.part2.rar.html