Become A Data Engineer
How you can become a data engineer in as little as 60 days (even if you don’t have a CS degree or current experience)
SQL Interview Questions
Learn how to answer SQL questions from real-life interviews from companies like Amazon. Hint: getting the answer right is not the most important factor.
Python Interview Questions
How to best prepare for python interview questions without needing to practice 100+ questions on Leetcode – this is not a book on becoming a software engineer!
AWS Concepts
Learn about storage, compute and the tradeoffs between different AWS services. Is there a way to account for unexpected spikes in incoming data?
Database Modeling
How do we choose between a fact or dim table? When to use 1 vs 5 primary keys? What is a foreign key? What are the most common mistakes when data modeling for companies like Doordash?
System Design
How to ensure the safety of our data while also optimizing for speed and cost. Do we need real time data? How frequent is the data refreshed? Does it vary based on types?
Behavioral Questions
Behavioral questions are often the most overlooked aspect of an interview – and for a good reason. Learn not only what is best to say, but more importantly what not to say.
Samples
Course Sections
Fact Tables
Learn about the different types of fact tables and real-life examples of companies that maintain them.
Dim Tables
Different types of dimension tables have their own benefit. Here we’ll discuss each one and see real life examples of companies which use them.
Database Modeling
Design a star schema from scratch and use your dim and fact knowledge from the previous sections to complete this exercise.
Data storage: S3 Data Lake
Most companies require a data lake. Learn about the fundamentals of storing data, and why how you organize your data matters.
Data Warehouse: AWS Redshift
Practical examples on how to build tables in redshift while optimizing for cost and storage. Figure out how to tune queries to run as quickly and efficiently as possible.
Compute
All companies need to budget for compute and optimize for its usage. These exercises will introduce you to different tools and their tradeoffs.
System Design – Case Studies
A list of case studies surrounding how real companies design infrastructure to support their business and the tradeoffs between the pieces they used and didn’t use. System Design questions like the ones at Uber.
System Design – Questions
Some questions to test out your system design skills! Modeled after real world interview questions. System Design questions like the ones at Lyft.
Product Improvement Via Data Engineering
At the end of the day, the goal of every employee is to add value to the business. 4 case studies on how data engineers contributed to the bottom line.
Algorithms Via Python
Learn about computer science fundamentals without having to overstudy, as many Data Engineers typically do. Some python problems, and of course interviewing tips! More importantly, we will go through how to answer these questions and what a real in person interview might look like. Python Data Engineer Questions just like the ones at Facebook.
Most Common behavioral Question
6 behavioral questions that will be asked during interviews and the different variations of how they could be asked. Find out what to say, how to get the experience needed to answer these questions, and most importantly what not to say.