Design data models, build data warehouses and data lakes, automate data pipelines, and manage massive datasets.
- Create user-friendly Relational and NoSQL data models
- Create scalable and efficient data warehouses
- Work efficiently with massive datasets
- Build and interact with a cloud-based data lake
- Automate and monitor data pipelines
- Develop proficiency in Spark, Airflow, and AWS tools
Create Relational and NoSQL data models to fit the diverse needs of data consumers. Use ETL to build databases in PostgreSQL and Apache Cassandra.
- Introduction to Data Modeling
- Relational Data Models
- NoSQL Data Models
Create cloud-based data warehouses. Sharpen data warehousing skills, deepen understanding of data infrastructure, and be introduced to data engineering on the cloud using Amazon Web Services (AWS)
.
- Introduction to Data Warehouses
- ELT and Data Warehouse Technology in the Cloud
- AWS Data Technologies
- Implementing Data Warehouses on AWS
Build a data lake on AWS and a data catalog following the principles of data lakehouse architecture. Learn about the big data ecosystem and the power of Apache Spark for data wrangling and transformation. Work with AWS data tools and services to extract, load, process, query, and transform semi-structured data in data lakes.
- Big Data Ecosystem, Data Lakes, & Spark
- Spark Essentials
- Using Spark & Data Lakes in the AWS Cloud
- Ingesting & organizing data in lakehouse architecture on AWS
Dive into the concept of data pipelines.
- Focus on applying the data pipeline concepts learn through Apache Airflow - concepts covered including data validation, DAGs, and Airflow.
- Venture into AWS quality concepts like copying S3 data, connections and hooks, and Redshift Serverless.
- Explore data quality through data lineage, data pipeline schedules, and data partitioning.
- Put data pipelines into production by extending Airflow with plugins, implementing task boundaries, and refactoring DAGs.
- Data Pipelines
- Airflow & AWS
- Data Quality
- Production Data Pipelines
Program Syllabus, more information about this program can be found by visiting Udacity Data Engineering ND.