Programming Studyๆ—ฅๆœฌ่ชž

Disclosure: We earn a commission from Udemy when you buy a course through links on this page.

SQL for Data Engineers: From Zero to Data Warehouse

SQL for Data Engineers: From Zero to Data Warehouse

Udemy ยท English

About this course

Language
English
Category
Provider
Udemy
Data updated

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.

Courses in the same category