Course Outline
I. Advanced Architecture and Optimization
Advanced Snowflake Architecture (2 hours)
- Inside Snowflake: MPP and its Advantages
- Data Storage: Micro-partitioning and Compression
- Clusters and their Management
Data Management and Security
- Time Travel and Fail-safe: Practical Applications
- Access Management and Data Security
- Monitoring and Auditing
Advanced SQL Features and Analysis
- Advanced SQL Queries: Window, Recursive
- Using UDFs and Stored Procedures
- Predictive and Statistical Analysis
Practical Workshops and Case Studies
- Solving Real Business Problems
- Query Optimization and Cost Management
II. Integration, Automation, and Advanced Solutions
Integration with External Systems (2 hours)
- Integration with ETL/ELT tools
- Connections with Big Data systems (e.g., Hadoop, Spark)
- Utilizing Snowflake APIs
Automation and Orchestration (2 hours)
- Process Automation with Snowpipe
- Orchestration using External Tools (e.g., Airflow)
- Practical Automation Examples
Advanced Data Processing (2 hours)
- Streaming Data Processing
- Machine Learning and AI with Snowflake
- Working with Large Data Sets
Workshops and Q&A Session (2 hours)
- Practical Application of Acquired Knowledge
- Problem Solving and Challenges
- Discussion and Experience Sharing
Requirements
Basic Knowledge of Snowflake, Experience in SQL, Basics of Data Processing, Understanding of Data Security, Experience with Other Cloud Technologies, Understanding of Data Analysis, Programming Skills, Practical Experience with Snowflake
Audience:
- Data Analysts
- Data Engineers
- Database Administrators (DBAs)
- Big Data Engineers
- Cloud Solutions Architects
- Developers and Programmers
- Business Intelligence (BI) Specialists
- IT Project Managers
Testimonials (6)
Dokładnie krok po kroku analizowane zagadnienia i w każdym możliwym momencie powrót do nich.
Kamila Kos - Cargotec Poland Sp. z o.o.
Course - Google Sheets for Excel Users
how the trainor shows his knowledge in the subject he's teachign
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Course - Data Vault: Building a Scalable Data Warehouse
Clear explanations with good examples so i could relate to my own line of work.
Elaine Vermeulen - Sandoz BV
Course - Alteryx for Developers
I enjoyed the exercises session the most as I get to understand how to apply. Would definitely enjoyed it more if there are more combination exercises :)
Joan Ng
Course - Data Preparation with Alteryx
Use cases were awesome! and Ray involved each and every one of us in each use case.
Zara - Trench Ltd
Course - Alteryx for Data Analysis
team work