Become a Data Architect

Colleagues, in the Become a Data Architect you will learn how to plan, design and implement enterprise data infrastructure solutions. Create the blueprints for an organizationÕs data management system.Meet the growing demand for full stack developers and learn to build rich web experiences using a modern architecture and technology stack. 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. Training modules and hands-on projects cover: 1) Data Architecture Foundations - 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: Design and HR Database); 2) Designing Data Systems - 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 & OLAP); 3) Big Data Systems - 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); and 4) Data Governance - learn about the different types of metadata, and how to build a Metadata Management System, Enterprise Data Model, and Enterprise Data Catalog. 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 Sneakerpeak). Intermediate Python and SQL skills and familiarity with ETL/Data Pipelines are needed.

Sign-up today (teams & execs welcome): https://tinyurl.com/2f6fkf6v 

Much career success, Lawrence E. Wilson - Online Learning Central