This is the only guide you will need to crack any data engineering interview rounds including DSA, Data Modeling, SQL, System Design and more in any FAANG or similar product companies.
Amber for finding best student accommodation: https://amberstudent.com/partners/jash-radia-1734957030
Book 1:1 mentoring sessions: https://topmate.io/jash_radia
LinkedIn: https://www.linkedin.com/in/jashradia/
Instagram: https://www.instagram.com/jash.radia/
Resources mentioned in the video:
DSA:
Cracking the coding interview: https://github.com/AatmikJain/ComputerScienceBooks/blob/master/Cracking%20the%20Coding%20Interview.pdf
Leetcode 150 DSA: https://leetcode.com/studyplan/top-interview-150/
Data Modeling and SQL:
Dimensional data modeling: https://www.holistics.io/books/setup-analytics/kimball-s-dimensional-data-modeling/
Data warehouse toolkit: https://github.com/letthedataconfess/Data-Engineering-Books/blob/main/Book-5Kimball_The-Data-Warehouse-Toolkit-3rd-Edition-5.pdf
SQL tutorial: https://www.w3schools.com/sql/
Leetcode 50 SQL: https://leetcode.com/studyplan/top-sql-50/
System design:
Certifications video: https://www.youtube.com/watch?v=wbmB_bydA14
Roadmap video: https://www.youtube.com/watch?v=IGraly_Lvvg
AWS open data: https://aws.amazon.com/opendata/
AWS architecture center: https://aws.amazon.com/architecture/
RRK (only examples shown in video):
Spark debugging: https://docs.databricks.com/en/optimizations/spark-ui-guide/index.html
Snowflake clustering: https://docs.snowflake.com/en/user-guide/tables-clustering-keys
0:00 Interview Process Overview
2:56 DSA
7:00 Amber Student Accommodation
8:06 Data Modeling and SQL
11:43 System Design
15:18 Role Related Knowledge