CodeBaobab
SQL, data models, and reliable pipelines

Data Engineer

Prepare for SQL, Python, data modeling, pipeline design, and production troubleshooting interviews.

By the end

Build trustworthy datasets, explain how pipelines recover, and defend design choices with evidence.

Data Engineering Interview Lab
Suggested next course

Python for Data Work

Turn Python records into trustworthy, analysis-ready tables with NumPy and pandas.

Start with Python for Data Work
Jump to a phase 4 phases

SQL and Python foundations

13 courses · 1 practice activities

View phaseHide phase

Query related tables, transform records, and explain the correctness and cost of your code.

Learn the concepts

  1. AI & Machine LearningSuggested nextPython for Data Work
  2. SQL & DataFiltering Rows
  3. SQL & DataGrouping and Aggregation
  4. SQL & DataJoining Tables
  5. SQL & DataSubqueries, CTEs and Set Operations
  6. SQL & DataNumbers and Dates
  7. SQL & DataDuplicates, Median and Mode
  8. SQL & DataWindow Functions I: Ranking and Top-N
  9. SQL & DataWindow Functions II: Running Values
  10. Algorithms · OptionalBig-O Notation
  11. Algorithms · OptionalArrays
  12. Algorithms · OptionalStrings
  13. Algorithms · OptionalHash Tables and Sets

Put it into practice

Data models and reliable loads

4 courses

View phaseHide phase

Define the grain, preserve history, and make changes safe to replay.

Learn the concepts

  1. SQL & DataChanging Data
  2. SQL & DataData Modeling and Warehouses
  3. SQL & DataReliable Batch and Incremental Pipelines
  4. SQL & DataStorage and Query Performance

Distributed processing and operations

3 courses · 1 practice activities

AI-assisted Coding included
View phaseHide phase

Read Spark plans, coordinate jobs, and handle delayed events without losing correctness.

Learn the concepts

  1. SQL & DataDistributed Processing with PySpark
  2. SQL & DataOrchestration and Data Quality
  3. SQL & DataStreaming and Event Time

Put it into practice

Migrations and interview practice

1 courses · 1 practice activities

View phaseHide phase

Reconcile systems, demonstrate bugs with tests, and explain a complete data architecture.

Learn the concepts

  1. SQL & DataData Migrations and Reconciliation

Put it into practice