"The structure, the practice exams, the instructor — all top tier. Passed first try."
Course Outline
What the programme covers, module by module.
Module 1: Introduction to Snowflake
- Cloud Data Warehousing
- Snowflake Platform Overview
- Snowflake Architecture
- Features and Benefits
- Industry Applications
Module 2: Snowflake Architecture
- Virtual Warehouses
- Databases
- Schemas
- Storage Layer
- Compute Layer
Module 3: Getting Started with Snowflake
- Account Setup
- User Interface
- Worksheets
- Object Management
- Environment Configuration
Module 4: SQL in Snowflake
- SQL Fundamentals
- DDL Commands
- DML Commands
- Query Development
- Query Optimization
Module 5: Database Objects
- Databases
- Schemas
- Tables
- Views
- Sequences
Module 6: Data Loading
- Bulk Data Loading
- Data Import Methods
- File Formats
- External Stages
- Data Validation
Module 7: Data Transformation
- Data Cleansing
- Data Aggregation
- Data Filtering
- Joins
- Transformation Workflows
Module 8: Data Modeling
- Dimensional Modeling
- Fact Tables
- Dimension Tables
- Star Schema
- Snowflake Schema
Module 9: Snowflake Performance Optimization
- Query Performance
- Clustering
- Caching
- Warehouse Sizing
- Performance Monitoring
Module 10: Data Sharing
- Secure Data Sharing
- Data Exchange Concepts
- Consumer Access
- Provider Access
- Collaboration Features
Module 11: Security and Access Control
- Authentication
- Role-Based Access Control
- User Management
- Data Encryption
- Security Best Practices
Module 12: Data Governance
- Metadata Management
- Data Lineage
- Data Quality
- Governance Policies
- Compliance Best Practices
Module 13: Semi-Structured Data
- JSON Data
- XML Data
- PARQUET Files
- Data Parsing
- Querying Semi-Structured Data
Module 14: Snowpipe
- Continuous Data Loading
- Automated Ingestion
- Pipeline Configuration
- Monitoring
- Error Handling
Module 15: Tasks and Streams
- Streams
- Tasks
- Change Tracking
- Workflow Automation
- Scheduling
Module 16: Integration with Data Tools
- ETL Integration
- Business Intelligence Integration
- Apache Spark Integration
- API Integration
- Cloud Storage Integration
Module 17: Monitoring and Troubleshooting
- Query History
- Warehouse Monitoring
- Usage Reports
- Error Diagnosis
- Troubleshooting Techniques
Module 18: Performance Tuning
- Query Tuning
- Warehouse Optimization
- Resource Management
- Cost Optimization
- Best Practices
Module 19: Cloud Deployment
- Multi-Cloud Architecture
- Deployment Strategies
- Backup and Recovery
- Disaster Recovery
- Operational Management
Module 20: DevOps for Snowflake
- Version Control
- CI/CD Concepts
- Deployment Automation
- Environment Management
- Release Best Practices
Module 21: Enterprise Best Practices
- Data Warehouse Design
- Documentation
- Operational Excellence
- Security Management
- Production Readiness
Module 22: Snowflake Data Platform Project
- Cloud Data Warehouse Development
- Data Loading Pipeline
- Data Transformation
- Performance Optimization
- Final Project Presentation
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Course Overview
This course provides comprehensive knowledge of the Snowflake Data Platform, covering Snowflake architecture, cloud data warehousing, data loading, SQL, data modeling, data sharing, security, performance optimization, automation, and integration with modern data engineering tools. Participants will gain hands-on experience building scalable, secure, and high-performance cloud data solutions using Snowflake.