Master data engineering and AI like a big tech engineer

Real Time Formula 1 Analytics

Big Bag Data

Chess.com Analytics

Trading Strategy for Crypto Currency - Analytics Engineering Capstone Submission

BetFlow - Real Time Sports Betting App

Showcase of student projects

Capstone Projects

Our students have gone on to work at companies like Meta, Airbnb and Amazon. As well as achieve 100% raises!

Fast Track Your Career

Immediate free cloud access to Databricks, AWS, Snowflake, Astronomer, and more!

Free Cloud Access with tons of hands on exercises

Weekly Guest Speaker Sessions

Why Choose DataExpert.io Academy?

In this bonus lecture, we dive into one of the hottest topics in tech right now: "Will data engineering be replaced by AI and large language models?" We explore where Large Language Models (LLMs) like GPT-4 are poised to have the most significant impact, identify areas ripe for disruption, and discern the domains where LLMs have a long way to go before they can replace human ingenuity. But most importantly, discover how you can use these insights to harness the power of LLMs and elevate your career as a data engineer.

LLM-Driven Data Engineering Day 1 Lecture

academy/2/course/65/large-language-models-day-1-lecture-transcript.json

In this bonus LLM lab, you will learn how to extend your LLMs capabilities beyond text generation. This includes tasks like sending emails, crafting LinkedIn posts, and exploring the role of agents in aiding you in your technical work such as when bugs arise in your pipeline or database.

LLM-Driven Data Engineering Day 2 Lab

academy/2/course/66/large-language-models-day-2-lab-transcript.json

In this LLM presentation, we explore building applications with LLMs, emphasizing LangChain as a versatile integration point for different LLMs and addressing privacy and security concerns.

LLM-Driven Data Engineering Day 2 Lecture

academy/2/course/67/large-language-models-day-2-lecture-transcript.json

Explore the dynamic world of data engineering in this insightful video. Zach shares a wealth of experiences and insights, addressing key challenges faced in the field.

Data Pipeline Maintenance: Navigating the Complexities of Data Engineering Day 1 Lecture

academy/5/course/686/data-pipeline-maintenance-day-1-lecture-yt-transcript.json

In this hands-on lab session, we embark on a practical journey of growth accounting. The video guides you through the step-by-step process, illustrating how to create a partition column, calculate active dates, and adeptly track state transitions.

Applying Analytical Patterns: Mastering Growth Accounting and Retention Analysis Day 1 Lab

academy/5/course/671/applying-analytical-patterns-day-1-lab-yt-transcript.json

In this presentation, Zach explores a range of topics related to Advanced SQL Analytical Patterns. The discussion covers the application of recursive CTEs, count case when, grouping sets, cross join unnest, cube, rollup, and window functions.

Applying Analytical Patterns: Recursive CTEs and Window Functions Day 2 Lecture

academy/5/course/672/applying-analytical-patterns-day-2-lecture-yt-transcript.json

In this video will be building a cumulative table design (https://github.com/EcZachly/cumulative-table-design) with complex data types STRUCT and ARRAY. 
We will take the table player_seasons and create a new table called players that holds onto an historical record of all NBA players and the seasons that they played! 

Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lab

academy/5/course/659/dimensional_data_modeling_day_1_lab/dimensional_data_modeling_day_1_lab.json

In this video we build an slowly changing dimension type 2 model on top of the players table we built in the first lab! 

Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lab

academy/5/course/661/dimensional-data-modeling-day-2-lab-yt-transcript.json

In this lab, we build a network of NBA players and see who they play against/with the most and for which teams!

SQL

Data Engineer Interview Skills

LLM-Driven Data Engineering Day 1 Lecture

LLM-Driven Data Engineering Day 2 Lab

LLM-Driven Data Engineering Day 2 Lecture

DataExpert

Data Pipeline Maintenance: Navigating the Complexities of Data Engineering Day 1 Lecture

Applying Analytical Patterns: Mastering Growth Accounting and Retention Analysis Day 1 Lab

Applying Analytical Patterns: Recursive CTEs and Window Functions Day 2 Lecture

Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lab

Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lab

Dimensional Data Modeling: Graph Data Modeling Day 3 Lab

Full Stack Test

Test Loom