Data Engineering & Analytics
Data Warehousing Training
Design and build modern data warehouses on Snowflake, Redshift, BigQuery and Azure Synapse.
Overview
Data Warehousing
A data warehouse brings data from many systems together in one place, organized for fast, reliable reporting and analytics.
Modern cloud data warehouses such as Snowflake, Amazon Redshift, Google BigQuery and Azure Synapse have made these skills essential for data and database professionals.
About the course
This course teaches data warehouse concepts and dimensional modeling, then builds a working cloud data warehouse step by step: loading data with ETL/ELT pipelines, optimizing queries and serving reports.
Course at a glance
- Track: Data Engineering & Analytics
- Level: No experience needed
- Format: Live instructor-led, online or on-site
- Includes: Hands-on labs and real-world projects
- Prepares for: Snowflake SnowPro Core
Curriculum
What you’ll learn
01
Data warehouse concepts and architecture
02
Dimensional modeling: facts, dimensions and star schemas
03
SQL for analytics
04
ETL and ELT pipelines
05
Snowflake hands-on
06
Amazon Redshift, Google BigQuery and Azure Synapse compared
07
Performance, cost and security
08
Connecting Power BI and reporting tools
What you need
- No prior IT experience required
- We teach everything from scratch, starting with the basics of Linux, SQL and networking
- A computer with a reliable internet connection
- Commitment to practice between sessions
Who should take this course?
- DBAs moving into data and analytics
- Data analysts and BI developers
- Software developers
- Career changers interested in data
Skills you’ll gain
- Designing star schemas
- Building ETL/ELT pipelines
- Working with Snowflake and cloud warehouses
- Optimizing analytical queries
- Serving data to BI tools
Benefits
- Enhanced career prospects and earning potential
- Hands-on experience with real-world scenarios
- Preparation for industry-recognized certifications
- Improved job performance from day one
- A competitive advantage in the job market
- Ongoing support from experienced instructors
More Data Engineering & Analytics courses
No experience needed
Data Engineering
Design and build reliable data pipelines and warehouses in the cloud.
No experience needed
Data Analytics & Power BI
Turn data into insight with SQL, Excel and interactive Power BI dashboards.
Prepares for: Microsoft Certified: Power BI Data Analyst Associate
Start your journey
Questions about schedules, pricing or corporate packages? Get in touch.