Programming in Snowflake Masterclass Hands-On

Overview

IMPORTANT:

This course requires an INTERMEDIATE level and it may NOT be for you if you just recently started with Snowflake, relational databases, with SQL and/or Python programming. It occasionally deals with advanced notions about security, software and data engineering, REST APIs etc, that are not explained here.

Check the minimum Requirements for this course, and the "What is NOT Included in This Course" section below, before buying this course.

Syllabus

• Introduction to Snowflake
Overview of Snowflake's Architecture
Key Features and Benefits
Setting up your Snowflake Environment
• Intermediate SQL in Snowflake
Advanced Query Techniques
Window Functions
Common Table Expressions (CTEs)
Working with Semi-structured Data
• Data Engineering with Snowflake
Loading and Unloading Data
Use of Snowpipe for Continuous Data Loading
Query Performance Optimization
• Snowflake Security and Governance
Role-based Access Control
Data Encryption Best Practices
Setting up Virtual Private Snowflake (VPS)
• Programming with Snowflake APIs
Introduction to REST APIs in Snowflake
Working with Snowflake Connector for Python
Automating Workflows with Snowflake Tasks
• Advanced Topics in Snowflake
Handling Time Travel and Zero Copy Cloning
Using Streams for Change Data Capture
Implementing Data Sharing
• Integrating Snowflake with Other Tools
Connecting Snowflake with BI Tools
Data Integration with ETL/ELT Solutions
• Capstone Project
Design and Implement a Full Data Pipeline in Snowflake
Include Security, Monitoring, and Optimization Features
• Course Review and Additional Resources
Recap of Key Learnings
Additional Readings and Tools
Community and Support Networks

---

Taught by

Cristian Scutaru

---

Subjects

Business