BISTEC Hearts Academy | Data Engineer Track | Month 2 | SQL & Data Modeling

Welcome to Month 2 of the BISTEC Hearts Academy Data Engineer Track. In this session, we cover advanced SQL and dimensional data modeling, including CTEs, window functions, Kimball methodology, star and snowflake schemas, and Slowly Changing Dimension patterns using PostgreSQL. This training is part of the BISTEC Hearts Academy role-based engineering curriculum. Track: Data Engineer Month: 2 Duration: ~4 hours Audience: Data engineers building SQL and modeling skills Topics covered: Common Table Expressions (CTEs) and recursive CTEs Window functions (ROW_NUMBER, RANK, LAG, LEAD) Kimball dimensional modeling methodology Star schema vs snowflake schema design Slowly Changing Dimensions (SCD Type 1, 2, 3) Date dimension design and generation Surrogate key strategy #BISTEC #HeartsAcademy #DataEngineer #SQL #DataModeling #Kimball #StarSchema #SCD #PostgreSQL #DataEngineering