Course Description
<p>Data engineering is the practice of designing and building systems for collecting, storing, and analyzing data at scale. It is a broad field with applications in just about every industry. Organizations have the ability to collect massive amounts of data, and they need the right people and technology to ensure it is in a highly usable state by the time it reaches data scientists and analysts.</p>
Curriculum
- Data Structures in Python
- Functional Python, Git, Bash
- Object Oriented Programming
- Python Projects
- SQL Single Table Queries
- SQL Relational Queries
- Coercing Data with Advanced SQL
- Data Modeling with OLTPs vs OLAPs
- ETL in Snowflake
- Intro to DBT
- DBT Pipelines
- Review and Data Dashboards
- HTML, CSS, and Scraping
- Intro to Flask
- Model - View - Controller
- The Adapter Pattern
- MVC with the Adapter Pattern
- Reviewing MVC with Adapters
- Docker Containers
- Building Docker Images
- Deploying Websites with AWS
- Working with RDS and advanced bash
- ETL with RDS, S3, and Redshift
- Performing ETL in Airflow
