Skills you'll learn:
Data architecture fluencyData staging
Designing Data Systems
Course
In this course, students will learn about the major components in architecting an enterprise data system by actually designing a staging area, operational data store, and data warehouse. Students will learn the importance of creating business requirements and data artifacts that define the data in a "Single Version of Truth." From ingesting data into a staging database, moving the data to the operational data store where data is transformed, to ultimately accessing the data warehouse. Students will learn how the data warehouse helps eliminate data silos and bring data from across the enterprise into one central system, which can be governed and accessible by anyone in the enterprise to understand and analyze intelligent insights to address business challenges and opportunities.
In this course, students will learn about the major components in architecting an enterprise data system by actually designing a staging area, operational data store, and data warehouse. Students will learn the importance of creating business requirements and data artifacts that define the data in a "Single Version of Truth." From ingesting data into a staging database, moving the data to the operational data store where data is transformed, to ultimately accessing the data warehouse. Students will learn how the data warehouse helps eliminate data silos and bring data from across the enterprise into one central system, which can be governed and accessible by anyone in the enterprise to understand and analyze intelligent insights to address business challenges and opportunities.
Advanced
4 weeks
Last Updated November 15, 2024
Prerequisites:
JSONRelational database basicsIntermediate SQL
Advanced
4 weeks
Last Updated November 15, 2024
Skills you'll learn:
Data architecture fluency • Data staging • Data ingestion • Star schemas
Prerequisites:
JSON • Relational database basics • Intermediate SQL
Course Lessons
Lesson 1
Foundations of Designing Data Systems
In this lesson, we will take a 30000-foot view of Designing Data Systems. We will meet the instructor and hear about the components of the course, including the final project.
Lesson 2
Data Architecture
In this lesson, we will look at the importance of, benefits of, and artifacts of Designing Data Systems using Data Architecture. We will also introduce Snowflake, the software we will be using.
Lesson 3
Staging Data
In this lesson, we will take a look at the important step of Staging Data. We will look at the theory behind it, study the steps involved, and then actually do it in Snowflake.
Lesson 4
Operational Data Store
In this lesson, we will look at what an ODS is and how it is an important step in building a data warehouse. We will also take a look at how to manage, cleanse, and transform the data.
Lesson 5
Data Warehouse
In this lesson, we will take a look at the final step of building a data warehouse. We will also look at reporting, the primary reason for a data warehouse.
Lesson 6 • Project
Project: Design a Data Warehouse for Reporting and OLAP
In a real data warehouse, students will use actual YELP and climate datasets in order to analyze the effects the weather has on customer reviews of restaurants.
Taught By The Best
Shankar Korrapolu
CEO at OK2
Shankar Korrapolu is the co-founder and CEO of startup OK2, a cross-platform mobile gaming engine that builds games cheaper and faster without compromising quality. For over 30 years he has offered his data processing services to organizations in investment banking, pharma, government and education sectors.
The Udacity Difference
Combine technology training for employees with industry experts, mentors, and projects, for critical thinking that pushes innovation. Our proven upskilling system goes after success—relentlessly.
Demonstrate proficiency with practical projects
Projects are based on real-world scenarios and challenges, allowing you to apply the skills you learn to practical situations, while giving you real hands-on experience.
Gain proven experience
Retain knowledge longer
Apply new skills immediately
Top-tier services to ensure learner success
Reviewers provide timely and constructive feedback on your project submissions, highlighting areas of improvement and offering practical tips to enhance your work.
Get help from subject matter experts
Learn industry best practices
Gain valuable insights and improve your skills
Enroll in Designing Data Systems. Choose the plan that works for you
All Access monthly
Unlimited access to our top-rated courses
Personalized Career Services
Cancel Anytime
Real-world projects
Personalized project reviews
Program certificates
Best Value
All Access bundle1
All the same great benefits as our monthly plan
The most cost-effective way to develop the skills you want
- 1Discount applies to the first 4 months of membership, after which plans are converted to month-to-month.