# Capstone Project Day 1 Lecture

> In this lecture, Zach shares his experiences with replicating Heroku and working with Postgres, emphasizing the importance of maintaining data integrity while querying. He discusses the significance of starting with dimensions in your capstone projects and the challenges of handling sensitive infor…

- Web page: https://www.dataexpert.io/lesson/capstone-project-day-1-lecture-april2025
- Program: [Analytics Engineering Boot Camp starting April 14th, 2025](https://www.dataexpert.io/program/analytics-engineering-boot-camp-april-2025-5702)
- Access: Requires enrollment in Analytics Engineering Boot Camp starting April 14th, 2025
- Length: 53 min video
- Skills: SQL, Data Modeling, ETL/ELT, Postgres, Kafka
- Academy: DataExpert.io Academy

## About this lesson

In this lecture, Zach shares his experiences with replicating Heroku and working with Postgres, emphasizing the importance of maintaining data integrity while querying. He discusses the significance of starting with dimensions in your capstone projects and the challenges of handling sensitive information in data models. He also touches on the need for real-time updates for student progress and the use of tools like DBT and Astronomer for data orchestration.

## Navigation

- Previous lesson: [Advanced dbt Lab Day 2](https://www.dataexpert.io/lesson/advanced-dbt-lab-day-2-april2025.md)
- Next lesson: [Capstone Project Day 1 Lab](https://www.dataexpert.io/lesson/capstone-project-day-1-lab-april2025.md)