Download and Learn Become a Data Architect Udacity Nanodegree Course 2023 for free with google drive download link.
Learn how to plan, design and implement enterprise data infrastructure solutions and create the blueprints for your organization’s data success.
What You’ll Learn in Become a Data Architect Nanodegree
Estimated 4 months to complete
In this program, you’ll plan, design and implement enterprise data infrastructure solutions and create the blueprints for an organization’s data management system. You’ll create a relational database with PostGreSQL, design an Online Analytical Processing (OLAP) data model to build a cloud based data warehouse, and design scalable data lake architecture that meets the needs of Big Data. Finally, you’ll learn how to apply the principles of data governance to an organization’s data management system.
Become a Data Architect Intro Video:
Intermediate Python and SQL skills, and basic familiarity with ETL/Data Pipelines.
The Data Architect Nanodegree program is designed for students with intermediate Python and SQL skills, and basic familiarity with ETL/Data Pipelines. Additional details include:
- Familiarity with Relational Database Management Systems or foundational database skills
- Intermediate Python
- Intermediate SQL
- Familiarity with batch processing and stream processing frameworks
- Operating systems, including UNIX, Linux, and MS Windows
- Basics of ETL/Data Pipelines
Data Architecture Foundations
Learn about the principles of data architecture. You will begin by learning the characteristics of good data architecture and how to apply them. Next you will move on to data modeling. You will learn to design a data model, normalize data, and create a professional ERD. Finally, you will take everything you learned and create a physical database using PostGreSQL.
Project – Designing an HR Database
In this project, you will design, build, and populate a database for the Human Resources (HR) Department at the imaginary Tech ABC Corp, a video game company. This project will start with a request from the HR Manager. From there, you will need to design a database using the foundational principles of data architecture that is best suited to the department’s needs. You will go through the steps of database architecture, creating database proposals, database entity relationship diagrams, and finally creating the database itself. This project is a scaled-down simulation of the kind of real-world assignments data architects work on every day.
Designing Data Systems
Learn to design enterprise data architecture. You will build a cloud based data warehouse with Snowflake. You will evaluate various data assets of an organization and characteristics of these data sources, design a staging area for ingesting varieties of data coming from source systems, and design an Operational Data Store (ODS). Finally, you will learn to design OLAP dimensional data models, design ELT data processing that is capable of moving data from an ODS to a data warehouse, and write SQL queries for the purpose of building reports.
Project – Design a Data Warehouse for Reporting and OLAP
In this project, you will design end to end data architecture, build ingestion of data from Yelp and Climatic source systems, design Operational Data Store and Data warehouse systems, and transform data from staging to ODS and finally from ODS to data warehouse system. Yelp source carries a list of businesses, restaurants, its reviews and ratings. Climatic data source keeps track of temperature and precipitation data. Both of these websites are independent sources and not related to
each other. The final objective of this project is to write appropriate SQL to find the impact of weather on restaurant ratings.
Big Data Systems
Learn about how to help organizations with massive amounts of data, including identification of Big Data problems and how to design Big Data solutions. You will learn about the internal architecture of many of the Big Data tools such as HDFS, MapReduce, Hive and Spark, and how these tools work internally to provide distributed storage, distributed processing capabilities, fault tolerance and scalability. Next you will learn how to evaluate NoSQL databases, their use cases and dive deep into creating and updating a NOSQL database with Amazon DynamoDB. Finally, you will learn how to implement Data Lake design patterns and how to enable transactional capabilities in a Data Lake.
Project – Design an Enterprise Data Lake System
In this project, you will act as a Big Data Architect, and work on a real world use case faced by a Medical Data Processing Company. The project requires you to analyze the current architecture of the company, understand technical and business requirements and propose a new Data Lake based solution to both technical and executive audiences. For technical audiences, you will develop a design document outlining your solution with rationale, and for the executive audience you will record a short presentation pitching your solution. This is a real world scenario where you will act as an expert data infrastructure consultant to the company and solve the challenges the company is facing today. You will also hone your presentation skills and learn to articulate complex technical terminologies as easy to understand and value driven objectives to company leadership.
Learn how to design a data governance solution that meets your company’s needs. First, you will learn about the different types of metadata, and how to build a Metadata Management System, Enterprise Data Model, and Enterprise Data Catalog. Next you will learn how to perform data profiling using various techniques including data quality dimensions, how to identify remediation options for data quality issues, and how to measure and monitor data quality using data quality scores, thresholds, dashboards, exception and trend reports. Finally, you will learn the concepts of Master Data and golden record, different types of Master Data Management Architectures, as well as the golden record creation and master data governance processes.
Project – Data Governance at SneakerPark
In this project, you will be implementing data governance solutions for an online shoe reseller SneakerPark to better manage their data now and in the future. First, you will create an Enterprise Data Model that provides a holistic view of all the data in their systems. Next you will document the metadata in an Enterprise Data Catalog and profile the data in their systems to identify data quality issues, suggest remediation strategies for each of these issues, and design a data quality dashboard. Finally, you will sketch out a proposed MDM implementation architecture, define a set of matching rules for the creation of customer and item master data, and define the data governance roles and responsibilities that are necessary to oversee this data governance initiative.
According to Glassdoor, the average Data Architect salary is over $108,000 a year.
Become a Data Architect Nanodegree Free Download Link: