We may earn an affiliate commission when you visit our partners.
Nicholas DeGiacomo,
Shrinath Parikh,
Rostislav Rabotnik,
Vijaya Nelavelli,
Shankar Korrapolu,
and
Ben Larson
Enroll in our online tech course for data systems training. Learn Enterprise Data Warehouse Architecture and build a cloud-based warehouse with Snowflake.
Prerequisite details
Read more
Enroll in our online tech course for data systems training. Learn Enterprise Data Warehouse Architecture and build a cloud-based warehouse with Snowflake.
Prerequisite details
Read more
Enroll in our online tech course for data systems training. Learn Enterprise Data Warehouse Architecture and build a cloud-based warehouse with Snowflake.
Prerequisite details
To optimize your success in this program, we've created a list of prerequisites and recommendations to help you prepare for the curriculum. Prior to enrolling, you should have the following knowledge:
- JSON
- Relational database basics
- Intermediate SQL
You will also need to be able to communicate fluently and professionally in written and spoken English.
Register for this course and see more details by visiting:
OpenCourser.com/course/1oj35w/designing
Two deals to help you save
We found two deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Use code at checkout.
Valid for a limited time only
Bootcamp level quality
Complete hands-on projects and get personalized feedback with Udacity.
Take
40%
off
UDACITY40
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off
What's inside
Syllabus
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.
Read more
Syllabus
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.
Read more
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.
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.
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.
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.
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.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Explores modern technologies foundational to designing a data warehouse system
Uses the Snowflake software as a vehicle to apply architectural concepts
Well-suited for learners seeking practical knowledge in designing data warehouses
Taught by industry experts with deep experience in data architecture
Covers topics essential for success in today's data-driven business environment
Provides hands-on practice, giving learners real-world experience in designing data warehouses
Save this course
Save Designing Data Systems to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Designing Data Systems with these
activities:
Review the Book 'Snowflake: The Data Warehouse Built for the Cloud'
Show steps
This book provides an in-depth understanding of Snowflake's architecture, features, and best practices.
View
The Datapreneurs: The Promise of AI and the...
on Amazon
Show steps
-
Read the book and take notes on key concepts
-
Summarize the main ideas of each chapter
-
Identify areas where you can apply the concepts to your own work
Attend a Snowflake Workshop
Show steps
Attending a Snowflake workshop led by experienced instructors can greatly enhance your understanding and accelerate your learning.
Browse courses on
Snowflake
Show steps
-
Check the Snowflake website for upcoming workshops
-
Register for a workshop that aligns with your learning goals
-
Attend the workshop and actively participate in the exercises and discussions
-
Follow up with the workshop instructors or other attendees to continue learning and build your network
Snowflake Tutorials
Show steps
Following along with the guided tutorials will help you gain practical experience in using Snowflake and solidify your understanding of the platform.
Browse courses on
Snowflake
Show steps
-
Start by signing up for a free tier Snowflake account
-
Follow the Step-by-Step Tutorial for Creating a Data Warehouse
-
Explore the other Snowflake tutorial resources and complete any that are relevant to your learning goals
Four other activities
Expand to see all activities and additional details
Show all seven activities
Snowflake SQL Practice
Show steps
Regular practice with Snowflake SQL will help you improve your proficiency and become more comfortable writing queries.
Browse courses on
SQL
Show steps
-
Use the Snowflake documentation or online resources to find practice exercises
-
Write queries to retrieve, filter, and aggregate data
-
Create tables, views, and other database objects
-
Share your queries with others and ask for feedback
-
Participate in online forums and discussions related to Snowflake SQL
Build a Mini Data Warehouse using Snowflake
Show steps
Building your own data warehouse using Snowflake will give you hands-on experience and a deeper understanding of its capabilities.
Browse courses on
Data Warehousing
Show steps
-
Use the Snowflake documentation or other resources to research best practices for data warehouse design
-
Gather data from various sources
-
Create a Snowflake database and load the data
-
Design and implement data models
-
Create queries and reports to analyze the data
Write a Blog Post on a Snowflake Topic
Show steps
Writing a blog post on a Snowflake topic will help you solidify your understanding and share your knowledge with others.
Browse courses on
Snowflake
Show steps
-
Choose a topic that you are knowledgeable about and that would be of interest to other learners
-
Research the topic thoroughly using Snowflake documentation and other resources
-
Write a well-structured blog post that clearly explains the topic
-
Publish your blog post on a platform like Medium or your own website
-
Promote your blog post on social media and other channels
Contribute to the Snowflake Open Source Community
Show steps
Contributing to Snowflake's open source projects will give you practical experience, expand your knowledge, and build your credibility in the Snowflake community.
Browse courses on
Snowflake
Show steps
-
Explore the Snowflake GitHub repositories and identify a project to contribute to
-
Read the documentation and understand the project's goals
-
Clone the repository and make changes locally
-
Submit a pull request with your contributions
-
Collaborate with other community members and maintain your contributions over time
Review the Book 'Snowflake: The Data Warehouse Built for the Cloud'
Show steps
This book provides an in-depth understanding of Snowflake's architecture, features, and best practices.
View
The Datapreneurs: The Promise of AI and the...
on Amazon
Show steps
Show steps
Show steps
- Read the book and take notes on key concepts
- Summarize the main ideas of each chapter
- Identify areas where you can apply the concepts to your own work
Attend a Snowflake Workshop
Show steps
Attending a Snowflake workshop led by experienced instructors can greatly enhance your understanding and accelerate your learning.
Browse courses on
Snowflake
Show steps
Show steps
Show steps
- Check the Snowflake website for upcoming workshops
- Register for a workshop that aligns with your learning goals
- Attend the workshop and actively participate in the exercises and discussions
- Follow up with the workshop instructors or other attendees to continue learning and build your network
Snowflake Tutorials
Show steps
Following along with the guided tutorials will help you gain practical experience in using Snowflake and solidify your understanding of the platform.
Browse courses on
Snowflake
Show steps
Show steps
Show steps
- Start by signing up for a free tier Snowflake account
- Follow the Step-by-Step Tutorial for Creating a Data Warehouse
- Explore the other Snowflake tutorial resources and complete any that are relevant to your learning goals
Four other activities
Expand to see all activities and additional details
Show all seven activities
Snowflake SQL Practice
Show steps
Regular practice with Snowflake SQL will help you improve your proficiency and become more comfortable writing queries.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Use the Snowflake documentation or online resources to find practice exercises
- Write queries to retrieve, filter, and aggregate data
- Create tables, views, and other database objects
- Share your queries with others and ask for feedback
- Participate in online forums and discussions related to Snowflake SQL
Build a Mini Data Warehouse using Snowflake
Show steps
Building your own data warehouse using Snowflake will give you hands-on experience and a deeper understanding of its capabilities.
Browse courses on
Data Warehousing
Show steps
Show steps
Show steps
- Use the Snowflake documentation or other resources to research best practices for data warehouse design
- Gather data from various sources
- Create a Snowflake database and load the data
- Design and implement data models
- Create queries and reports to analyze the data
Write a Blog Post on a Snowflake Topic
Show steps
Writing a blog post on a Snowflake topic will help you solidify your understanding and share your knowledge with others.
Browse courses on
Snowflake
Show steps
Show steps
Show steps
- Choose a topic that you are knowledgeable about and that would be of interest to other learners
- Research the topic thoroughly using Snowflake documentation and other resources
- Write a well-structured blog post that clearly explains the topic
- Publish your blog post on a platform like Medium or your own website
- Promote your blog post on social media and other channels
Contribute to the Snowflake Open Source Community
Show steps
Contributing to Snowflake's open source projects will give you practical experience, expand your knowledge, and build your credibility in the Snowflake community.
Browse courses on
Snowflake
Show steps
Show steps
Show steps
- Explore the Snowflake GitHub repositories and identify a project to contribute to
- Read the documentation and understand the project's goals
- Clone the repository and make changes locally
- Submit a pull request with your contributions
- Collaborate with other community members and maintain your contributions over time
Career center
Learners who complete Designing Data Systems will develop knowledge and skills
that may be useful to these careers:
Data Architect
Data Architect
Data Architects work on a team with the primary role of maintaining a consistent architecture across data systems for an organization. Designing Data Systems is an optimal course for someone interested in this role because it introduces the concept of enterprise data warehousing, which is essential in the development and implementation of data architecture.
Database Administrator
Database Administrator
Database Administrators are tasked with developing, implementing, and maintaining the organization's database management system. Designing Data Systems will help prepare someone for this role by providing in-depth instruction on data warehousing with Snowflake, an industry-leading platform.
Data Scientist
Data Scientist
Successful Data Scientists must be proficient in data analysis techniques and tools. Designing Data Systems can help someone break into this career by providing a solid foundation in SQL and data architecture, as well as cloud-based data management.
Business Analyst
Business Analyst
Business Analysts examine an organization's business processes to gather insights for decision-making. Taking Designing Data Systems can help someone prepare for this role by teaching them about data staging, a critical step in understanding the flow and lineage of business data.
Data Governance Analyst
Data Governance Analyst
Data Governance Analysts develop and implement data governance policies and standards across an organization. Designing Data Systems may be helpful for someone pursuing this career path by providing an overview of data architecture and its importance in managing and governing data assets.
ETL Developer
ETL Developer
ETL Developers design and develop the systems that extract, transform, and load data from various sources into a data warehouse. Taking Designing Data Systems may be useful for someone interested in this role because it provides instruction on data staging, transformation, and management.
Data Integration Architect
Data Integration Architect
Data Integration Architects manage the integration of data from multiple sources into a single, cohesive system. Designing Data Systems may be helpful for someone working towards this role because it provides instruction in the fundamental concepts of data architecture, data warehousing, and cloud-based data management.
Information Architect
Information Architect
Information Architects design and manage the organization's information system. Designing Data Systems can help someone interested in this role by providing instruction in data architecture, data staging, and data management.
Lead Data Engineer
Lead Data Engineer
Lead Data Engineers provide technical direction and leadership to a team of data engineers. Designing Data Systems may be helpful for someone seeking this role as it provides instruction in data architecture and data warehousing, which are key areas of responsibility for Lead Data Engineers.
Data Engineer
Data Engineer
Data Engineers design, implement, and maintain the data systems that collect, store, and analyze data. Designing Data Systems can help someone who wants to become a Data Engineer by providing instruction in data architecture, data warehousing, and cloud-based data management.
Database Designer
Database Designer
Database Designers design and maintain the database systems used by an organization. Designing Data Systems may be helpful for someone pursuing this career because it provides instruction in data architecture and data management, which are key responsibilities of Database Designers.
Data Analyst
Data Analyst
Data Analysts collect, analyze, and interpret data to provide insights for decision-making. Designing Data Systems can help someone interested in this role by providing instruction in data architecture and data management, which are key areas of responsibility for Data Analysts.
Systems Analyst
Systems Analyst
Systems Analysts design, implement, and maintain computer systems. Designing Data Systems may be helpful for someone interested in this role because it provides instruction in data architecture and data management, which are key areas of responsibility for Systems Analysts.
Software Developer
Software Developer
Software Developers design, develop, and test software applications. Designing Data Systems may be helpful for someone interested in this role because it provides instruction in data architecture and data management, which are key areas of responsibility for Software Developers.
Project Manager
Project Manager
Project Managers plan, execute, and close projects. Designing Data Systems may be helpful for someone interested in this role because it provides instruction in data architecture and data management, which are key areas of responsibility for Project Managers.
For more career information including salaries, visit:
OpenCourser.com/course/1oj35w/designing
Reading list
We've selected six books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Designing Data Systems.
Widely considered *the* book on Hadoop, an open-source software framework for distributed storage and processing of big data using the MapReduce programming model. covers all aspects of Hadoop, from installation to administration to development.
A classic book on data warehouse design that covers the dimensional modeling approach. must-read for anyone who wants to learn more about data warehousing.
A comprehensive guide to dimensional modeling, a key concept in data warehouse design. Even if you don't read it cover-to-cover, it recommended reference text for someone who wants to learn more about data warehousing.
A technical book that explores how to use MapReduce, the programming model popularized by Apache Hadoop, for processing large amounts of data. valuable resource for anyone interested in learning how to use MapReduce for data warehousing.
Save
A thought-provoking book that explores the ethical and social implications of data science. It must-read for anyone working with data, including those in the field of data warehousing.
An introductory book on data warehousing that covers the fundamentals of data warehousing. It good starting point for anyone who is new to data warehousing.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/1oj35w/designing
Share
Similar courses
Here are nine courses similar to
Designing Data Systems.
Data Warehousing with Oracle: Design a Database
OpenCourser.com/course/zjp7jr/data
Data Warehousing with Oracle: Design a Database
Warehousing Data with Oracle Autonomous Data Warehouse Cloud
OpenCourser.com/course/n6tkl4/warehousing
Warehousing Data with Oracle Autonomous Data Warehouse...
Managing an Enterprise Snowflake Data Platform
OpenCourser.com/course/hjls12/managing
Managing an Enterprise Snowflake Data Platform
Automate Validation using the Data Validation Tool (DVT)
OpenCourser.com/course/7wb6xh/automate
Automate Validation using the Data Validation Tool (DVT)
Azure Data Factory : Implement SCD Type 1
OpenCourser.com/course/xnf0wc/azure
Azure Data Factory : Implement SCD Type 1
Data Warehousing and BI Analytics
OpenCourser.com/course/s7dwgx/data
Data Warehousing and BI Analytics
Data Warehousing and Business Intelligence
OpenCourser.com/course/lc6exk/data
Data Warehousing and Business Intelligence
Advanced Data Modeling
OpenCourser.com/course/31zr78/advanced
Advanced Data Modeling
Optimizing a Data Warehouse on the Microsoft SQL Server Platform
OpenCourser.com/course/ur4qhy/optimizing
Optimizing a Data Warehouse on the Microsoft SQL Server...
Effort
4 weeks
Level
Advanced
Via
Udacity
Instructors
Nicholas DeGiacomo
Shrinath Parikh
Rostislav Rabotnik
Vijaya Nelavelli
Shankar Korrapolu
Ben Larson
Language
English
Good to know
Explores modern technologies foundational to designing a data warehouse system
Uses the Snowflake software as a vehicle to apply architectural concepts
Well-suited for learners seeking practical knowledge in designing data warehouses
Taught by industry experts with deep experience in data architecture
Covers topics essential for success in today's data-driven business environment
Provides hands-on practice, giving learners real-world experience in designing data warehouses
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser