Do these basics and get going for Data Engineering !!
🔵 SQL
-- Aggregations with GROUP BY
-- Joins (INNER, LEFT, FULL OUTER)
-- Window functions
-- Common table expressions
🔵 Data Modeling
-- Normalization and 3rd Normal Form
-- Fact, Dimension, and Aggregate Tables
-- Efficient Table Designs (Cumulative)
🔵 Python
-- Loops, If Statements
-- Complex Data Types (MAP, ARRAY, STRUCT)
🔵 Data Quality
-- Data Checks
-- Write-Audit-Publish Pattern
🔵 Distributed Compute
-- MapReduce
-- Partitioning, Skew, Spilling to Disk
Post #366
1.11K
- 👍 4
- ❤ 1