Udemy - Data Engineering Interview Prep - SQL, Spark and System Design

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Inside the DE Interview The Map
• 1 - Module 1 Check.html (21.1 KB)
• 1 - What Companies Actually Test.mp4 (19.6 MB)
• 2 - Reading the Job Description Like an Interviewer.mp4 (25.9 MB)
• 3 - The 4-Week Prep Plan + How to Use This Course.mp4 (15.9 MB)
10 - PySpark Round II Shuffles, Skew and Performance
• 10 - Module 10 Check.html (21.3 KB)
• 32 - The Shuffle Root of All Spark Questions.mp4 (22.3 MB)
• 33 - Broadcast Joins, Partitioning and Bucketing.mp4 (21.5 MB)
• 34 - Data Skew, AQE and Catalyst.mp4 (19.8 MB)
• 35 - Caching and Persistence When They Backfire.mp4 (22.1 MB)
11 - Pipeline Design ETL ELT That Survives Production
• 11 - Module 11 Check.html (21.1 KB)
• 36 - ETL vs ELT and Where Each Wins.mp4 (17.5 MB)
• 37 - Idempotency, Incremental Loads and Backfills.mp4 (27.1 MB)
• 38 - Orchestration and Dependency Design (Airflow).mp4 (22.5 MB)
• 39 - Handling Late and Duplicate Data.mp4 (25.2 MB)
12 - Streaming and Real-Time The Kafka Conversation
• 12 - Module 12 Check.html (21.2 KB)
• 40 - Batch vs Streaming and When Real-Time Matters.mp4 (18.3 MB)
• 41 - Kafka Mental Model Topics, Partitions, Offsets.mp4 (26.9 MB)
• 42 - Exactly-Once, Windowing and Watermarks.mp4 (25.8 MB)
• 43 - Change Data Capture (CDC) Patterns.mp4 (28.1 MB)
13 - File Formats and Storage Parquet, Delta and Iceberg
• 13 - Module 13 Check.html (21.2 KB)
• 44 - Row vs Columnar and Why Parquet Wins.mp4 (31.7 MB)
• 45 - Compression, Partitioning and the Small-Files Problem.mp4 (27.2 MB)
• 46 - Delta and Iceberg Table Formats in Interviews.mp4 (32.4 MB)
14 - Distributed Systems Fundamentals for Data Engineers
• 14 - Module 14 Check.html (21.2 KB)
• 47 - Partitioning, Replication and Sharding.mp4 (27.7 MB)
• 48 - CAP, Consistency Models and Trade-offs.mp4 (36.1 MB)
• 49 - MapReduce, Shuffle and the Lineage of Spark.mp4 (27.4 MB)
15 - Data Quality, Testing and Reliability
• 15 - Module 15 Check.html (21.0 KB)
• 50 - DQ Dimensions and the Checks That Matter.mp4 (31.2 MB)
• 51 - Data Contracts, SLAs and Observability.mp4 (26.5 MB)
• 52 - Testing Pipelines (Unit Integration Data).mp4 (29.2 MB)
16 - Cloud Platforms Snowflake and Databricks Questions
• 16 - Module 16 Check.html (21.1 KB)
• 53 - Snowflake Architecture Interview Answers.mp4 (28.3 MB)
• 54 - Databricks and the Lakehouse Explained.mp4 (29.9 MB)
• 55 - Cost and Performance Levers They Ask About.mp4 (34.2 MB)
17 - System Design for DEs I The Framework
• 17 - Module 17 Check.html (20.8 KB)
• 56 - The Data-System-Design Framework.mp4 (18.2 MB)
• 57 - Designing a Batch Analytics Pipeline.mp4 (24.8 MB)
• 58 - Estimating Scale, Throughput and Storage.mp4 (27.1 MB)
18 - System Design II Real Prompts, Solved
• 18 - Module 18 Check.html (21.2 KB)
• 59 - Design a Warehouse for an E-commerce Company.mp4 (31.6 MB)
• 60 - Design a Real-Time Metrics Pipeline.mp4 (24.2 MB)
• 61 - Design a Lakehouse Ingestion Layer.mp4 (27.0 MB)
19 - The Coding DSA Round Data Engineers Still Face
• 19 - Module 19 Check.html (20.9 KB)
• 62 - What DE Coding Rounds Actually Look Like.mp4 (18.0 MB)
• 63 - Arrays, Hashmaps and Strings (the 80%).mp4 (27.8 MB)
• 64 - Complexity and Talking Through Your Code.mp4 (27.8 MB)
2 - SQL Round I Joins, Aggregations & the Trap Questions
• 2 - Module 2 Check.html (21.2 KB)
• 4 - The Join Family and the LEFT-JOIN-NULL Trap.mp4 (21.5 MB)
• 5 - GROUP BY, HAVING and Aggregation Gotchas.mp4 (21.5 MB)
• 6 - Set Operations and Three-Valued NULL Logic.mp4 (23.4 MB)
20 - Take-Homes and Live SQL Tests
• 20 - Module 20 Check.html (21.0 KB)
• 65 - Anatomy of a Take-Home and How to Scope It.mp4 (17.2 MB)
• 66 - Live SQL Test Strategy (Think Aloud, Edge Cases).mp4 (23.0 MB)
• 67 - Presenting Your Solution Like a Senior.mp4 (24.1 MB)
21 - The Behavioral and Project Deep-Dive Round
• 21 - Module 21 Check.html (21.1 KB)
• 68 - STAR Method and Structuring Your Stories.mp4 (16.8 MB)
• 69 - The Project Deep-Dive Defending Decisions.mp4 (18.4 MB)
• 70 - Conflict, Ownership and Senior Signals.mp4 (14.2 MB)
• 71 - Questions to Ask Them (and Red Flags).mp4 (14.9 MB)
22 - Capstone The Full Mock Interview Gauntlet
• 22 - Module 22 Check.html (21.5 KB)
• 72 - The SQL + Window Screen (Timed, Solved).mp4 (23.8 MB)
• 73 - The Spark + Pipeline-Design Loop.mp4 (26.5 MB)
3 - SQL Round II Window Functions (the #1 Filter)
• 10 - Top-N-per-Group the Classic Question, Solved Three Ways.mp4 (24.8 MB)
• 3 - Module 3 Check.html (21.0 KB)
• 7 - ROW_NUMBER vs RANK vs DENSE_RANK.mp4 (21.6 MB)
• 8 - Running Totals and Moving Averages ROWS vs RANGE.mp4 (20.9 MB)
• 9 - LAG, LEAD and Period-over-Period Analysis.mp4 (18.0 MB)
4 - SQL Round III Advanced Patterns Interviewers Love
• 11 - CTEs vs Subqueries vs Temp Tables (and Recursive CTEs).mp4 (22.8 MB)
• 12 - Gaps and Islands One Pattern, Twenty Questions.mp4 (20.8 MB)
• 13 - Pivoting, Unpivoting and Conditional Aggregation.mp4 (18.3 MB)
• 14 - Date-Time Gymnastics and Sessionization.mp4 (24.4 MB)
• 4 - Module 4 Check.html (21.3 KB)
5 - SQL Round IV Why Is This Slow Optimization
• 15 - Reading an Execution Plan.mp4 (19.1 MB)
• 16 - Partition Pruning and Predicate Pushdown.mp4 (23.2 MB)
• 17 - The Anti-Patterns That Tank Performance.mp4 (32.3 MB)
• 5 - Module 5 Check.html (21.2 KB)
6 - Data Modeling Dimensional Design at the Whiteboard
• 18 - OLTP vs OLAP and Why Models Differ.mp4 (16.5 MB)