★★★★★
"The structure, the practice exams, the instructor — all top tier. Passed first try."
AS
Aarti SharmaSenior Project Manager · TCS
— The journey
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
— 01.2 · Is it right for you?
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Who it's for
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
What's included
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Who it's for
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
What's included
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings