Data Warehousing with Snowflake and Redshift Training Course
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
- Explain what a data warehouse is and how it supports analytics.
- Set up and configure warehouses on Snowflake and Amazon Redshift.
- Tune storage, queries and overall warehouse speed.
- Write SQL that manages and queries warehouse data.
- Connect a warehouse to BI tools for deeper reporting.
- Apply sound practice to keep a warehouse secure and well maintained.
- Design warehouse solutions that scale with analytical demand.
Prerequisites
- A basic grasp of databases and data analysis
- Introductory SQL skills
- No Snowflake or Redshift experience needed
- A wish to build and run data warehouses
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
- Duration: 3 Days
- 4.5 Ratings
Building Scalable Data Pipelines with Apache Airflow Training Course
- Duration: 3 Days
- 4.5 Ratings
Data Warehousing with Snowflake and Redshift Training Course
- Duration: 3 Days
- 4.5 Ratings
Real-Time Data Processing with Kafka Training Course