Data Warehousing with Snowflake and Redshift Training Course

Share this course

Duration

3 Days

Course Overview

Analysts and database staff planning a cloud warehouse spend three days setting one up, filling it and querying it on two leading platforms. Day one covers warehouse concepts and architecture, prepares a Snowflake and an Amazon Redshift environment, and models data with star and snowflake schemas. Day two loads data through ETL and ELT flows, writes faster queries for large datasets and uses analytical SQL functions for reporting. Day three connects the warehouse to Power BI, Tableau or Looker, applies role-based access and encryption, and ends with teams designing a warehouse that can scale for a business case.

Format of Training

  • Trainer-led setup of Snowflake and Redshift accounts, side by side
  • Modeling exercise that turns a sample business into a star schema
  • Query tuning practice on large tables and a live reporting demo
  • Dashboard build in a BI tool and a team design task to close

Course Objectives

  1. Explain what a data warehouse is and how it supports analytics.
  2. Set up and configure warehouses on Snowflake and Amazon Redshift.
  3. Tune storage, queries and overall warehouse speed.
  4. Write SQL that manages and queries warehouse data.
  5. Connect a warehouse to BI tools for deeper reporting.
  6. Apply sound practice to keep a warehouse secure and well maintained.
  7. Design warehouse solutions that scale with analytical demand.

Prerequisites

Course Outline

Day 1: Introduction to Data Warehousing

Session 1: Fundamentals of Data Warehousing

  • What a data warehouse is, its main ideas and why it helps
  • How warehouses are structured and the rules behind good design

Session 2: Getting Started with Snowflake and Redshift

  • A first look at Snowflake and Amazon Redshift
  • Preparing a Snowflake and a Redshift environment

Session 3: Data Modeling for Warehousing

  • Star schema, snowflake schema and normalization
  • Drawing up a data model for a warehouse

Day 2: Managing and Querying Data Warehouses

Session 1: Loading and Transforming Data

  • ETL and ELT flows for bringing data in
  • Loading data into Snowflake and Redshift

Session 2: Query Optimization and Performance Tuning

  • How to write queries that run fast
  • Tuning queries that scan large datasets

Session 3: Advanced Querying and Analytics

  • Analytical SQL functions for finding patterns
  • Demo: building detailed reports in Snowflake and Redshift

Day 3: Integration, Security, and Best Practices

Session 1: Integrating Data Warehouses with BI Tools

  • Linking Snowflake and Redshift to Power BI, Tableau or Looker
  • Building a dashboard on the connected data

Session 2: Security and Maintenance

  • Role-based access control, encryption and compliance
  • Demo: putting security good practice in place

Session 3: Real-World Applications and Scalability

  • Cases from e-commerce, finance and healthcare
  • Group task: designing a warehouse that can scale for a business case

Book This Course

Customise This Course for Your Team

If your organization has already picked Snowflake or Redshift, every lab can run on that platform alone. The dashboard session can use whichever BI tool your analysts open each day. Tell us your platform and reporting tool, and we will set the course up to match.
Need help with the right course to choose?

Explore more opportunities

Introduction to Data Engineering Training Course

ETL Processes for Data Pipelines Training Course

Data Modeling for Analytics Training Course

Building Scalable Data Pipelines with Apache Airflow Training Course

Data Warehousing with Snowflake and Redshift Training Course

Real-Time Data Processing with Kafka Training Course

Data Warehousing with Snowflake and Redshift Training Course