Skip to content

Introduction to Data Warehousing


Build warehousing skills, gain an understanding of data infrastructure, and build on the cloud using AWS.

Enroll Now
  • 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

  1. Cloud Data Warehouses

    1 month to complete

    Create 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.

    1. 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-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.

            • 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.

            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 Architect

              Matt 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 Udacity

              Valerie 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.

              Cloud Data Warehouses

              Enroll Now