Real-world projects from industry experts
With real-world projects and immersive content built in partnership with top-tier companies, you’ll master the tech skills companies want.
Introduction to Data Warehousing
Course
Build warehousing skills, gain an understanding of data infrastructure, and build on the cloud using AWS.
Estimated time
1 month
Enroll by
June 7, 2023
Get access to classroom immediately on enrollment
Skills acquired
Data Extraction, OLAP Cubes, Cloud Computing Fluency
What You Will Learn
Cloud Data Warehouses
1 month to completeCreate cloud-based data warehouses. Sharpen your data warehousing skills, deepen your understanding of data infrastructure, and be introduced to data engineering on the cloud using Amazon Web Services (AWS).
Prerequisite knowledge
SQL, Data Modeling Basics, Amazon Web Services Basics, and Python.
Introduction to Data Warehouses
Explain how OLAP may support certain business users better than OLTP and implement ETL for OLAP Transformations with SQL. Describe Data Warehouse Architecture. Describe OLAP cube from facts and dimensions to slice, dice, roll-up, and drill down operations. Implement OLAP cubes from facts and dimensions to slice, dice, roll-up, and drill down. Compare columnar vs. row-oriented approaches and implement columnar vs. row-oriented approaches.
ELT & Data Warehouse Technology in the Cloud
Explain the differences between ETL and ELT. Differentiate scenarios where ELT is preferred over ETL. Implement ETL for OLAP Transformations with SQL. Select appropriate cloud data storage solutions. Select appropriate cloud pipeline solutions. Select appropriate cloud data warehouse solutions.
AWS Data Technologies
Describe AWS data warehouse services and technologies. Create and configure AWS Storage Resources. Create and configure Amazon Redshift resources and implement infrastructure as code for Redshift on AWS.
Implementing Data Warehouses on AWS
Describe Redshift data warehouse architecture. Run ETL process to extract data from AWS S3 into Redshift. Design optimized tables by selecting appropriate distribution styles and sorting keys.
Course Project: Data Warehouse
Act as a data engineer for a streaming music service. Build an ELT pipeline that extracts data from S3, stages it in Redshift, and transform it into a set of dimensional tables for an analytics team to find insights into what songs their users are listening to.
All Our Courses Include
Real-time support
On demand help. Receive instant help with your learning directly in the classroom. Stay on track and get unstuck.
Workspaces
Validate your understanding of concepts learned by checking the output and quality of your code in real-time.
Flexible learning program
Tailor a learning plan that fits your busy life. Learn at your own pace and reach your personal goals on the schedule that works best for you.
Course offerings
Class content
- Real-world projects
- Project reviews
- Project feedback from experienced reviewers
Student services
- Student community
- Real-time support
Succeed with personalized services.
We provide services customized for your needs at every step of your learning journey to ensure your success.
- Experienced Project Reviewers
- Real-Time Support
Get timely feedback on your projects.
- Personalized feedback
- Unlimited submissions and feedback loops
- Practical tips and industry best practices
- Additional suggested resources to improve
1,400+ project reviewers
2.7M projects reviewed
88/100 reviewer rating
1.1 hours avg project review turnaround time
Learn with the best.
Learn with the best.
Matt Swaffer
Solutions ArchitectMatt is a software and solutions architect focusing on data science and analytics for managed business solutions. In addition, Matt is an adjunct lecturer, teaching courses in the computer information systems department at the University of Northern Colorado where he received his PhD in Educational Psychology.
Valerie Scarlata
Curriculum Manager at UdacityValerie is a curriculum manager at Udacity who has developed and taught a broad range of computing curriculum for several colleges and universities. She was a professor and software engineer for over 10 years specializing in web, mobile, voice assistant, and social full-stack application development.
Cloud Data Warehouses
Get started today
Learn
Build warehousing skills, gain an understanding of data infrastructure, and build on the cloud using AWS.
Average Time
On average, successful students take 1 month to complete this program.
Benefits include
- Real-world projects from industry experts
- Real-time support
Program Details
Do I need to apply? What are the admission criteria?
No. This Course accepts all applicants regardless of experience and specific background.
What are the prerequisites for enrollment?
A well-prepared learner has experience in Relational database design, SQL, Basic dimensional modeling, Data Modeling Basics, Amazon Web Services Basics, and Python.
How is this course structured?
This course is comprised of content and curriculum to support one project. We estimate that students can complete the program in one month.
The project will be reviewed by the Udacity reviewer network and platform. Feedback will be provided and if you do not pass the project, you will be asked to resubmit the project until it passes.
How long is this course?
Access to this course runs for the length of time specified in the payment card above. If you do not graduate within that time period, you will continue learning with month to month payments. See the Terms of Use and FAQs for other policies regarding the terms of access to our programs.
Can I switch my start date? Can I get a refund?
Please see the Udacity Program Terms of Use and FAQs for policies on enrollment in our programs.
What software and versions will I need in this course?
There are no software and version requirements to complete this course. All coursework and projects can be completed via Student Workspaces in the Udacity online classroom. Udacity’s full technical requirements are listed here.