{"repo":"Flor91/Data-engineering-nanodegree","free":true,"listed":false,"github":"https://github.com/Flor91/Data-engineering-nanodegree","clone":"git clone https://github.com/Flor91/Data-engineering-nanodegree.git","description":"Projects done in the Data Engineering Nanodegree by Udacity.com","language":"Jupyter Notebook","stars":274,"topics":["udacity-nanodegree","udacity-course","data-engineering","data-modeling","postgres","cassandra","aws","dimensional-model"],"license":"MIT","category":"data-pipelines","readme_excerpt":"Data-engineering-nanodegree Projects done in the Data Engineering Nanodegree by Udacity.com Course 1: Data Modeling Introduction to Data Modeling ➔ Understand the purpose of data modeling ➔ Identify the strengths and weaknesses of different types of databases and data storage techniques ➔ Create a table in Postgres and Apache Cassandra Relational Data Models ➔ Understand when to use a relational database ➔ Understand the difference between OLAP and OLTP databases ➔ Create normalized data tables ➔ Implement denormalized schemas (e.g. STAR, Snowflake) NoSQL Data Models ➔ Understand when to use NoSQL databases and how they differ from relational databases ➔ Select the appropriate primary key and clustering columns for a given use case ➔ Create a NoSQL database in Apache Cassandra Project: Data Modeling with Postgres and Apache Cassandra Course 2: Cloud Data Warehouses Introduction to the Data Warehouses ➔ Understand Data Warehousing architecture ➔ Run an ETL process to denormalize a database (3NF to Star) ➔ Create an OLAP cube from facts and dimensions ➔ Compare columnar vs. row oriented approaches Introduction to the Cloud with AWS ➔ Understand cloud computing ➔ Create an AWS account and understand their services ➔ Set up Amazon S3, IAM, VPC, EC2, RDS PostgreSQL Implementing Data Warehouses on AWS ➔ Identify components of the Redshift architecture ➔ Run ETL process to extract data from S3 into Redshift ➔ Set up AWS infrastructure using Infrastructure as Code (IaC) ➔ Design an o","default_branch":null,"files":null,"tree":[],"storefront":"/r/Flor91","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Flor91/Data-engineering-nanodegree/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}