Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Introduction to Snowflake

Course Summary

The Introduction to Snowflake training course is designed to demonstrate insight into use cases and management of Snowflake data warehouses.

The course begins with examining the key concepts of data warehousing and Snowflake architecture. Next, it describes how to create a Snowflake database with efficient data storage. The course concludes with an analysis of how to create queries in Snowflake.

Purpose
 Learn how to utilize and manage Snowflake databases.
Audience
 Data engineers, administrators, and developers who need to learn how to use the AWS Snowflake warehousing system.
Role
Data Engineer - Software Developer - Web Developer
Skill Level
Introduction
Style
Workshops
Duration
2 Days
Related Technologies
Databases | Data Engineering | Snowflake

 

Productivity Objectives
  • Discuss the Snowflake architecture and what makes it unique compared to traditional data warehouses
  • Describe why a data warehouse is important and how it differs from a transactional database
  • Apply a data model with Snowflake
  • Demonstrate how to write efficient queries
  • Describe benchmarks for data processing compared to other data warehouses

What You'll Learn:

In the Introduction to Snowflake training course, you'll learn:
  • Key Concepts
    • General data warehousing concepts
      • Multi-node database architecture
      • Shared disk database architecture
      • Shared-nothing database architecture
      • Massive Parallel processing
      • Replication
      • Failover
    • Snowflake Architecture
      • VPCs
      • Database Storage (cloud)
      • Query Processing - Multiple virtual warehouses
      • Cloud Services - Infrastructure manager, Optimizer, Security
  • Setting Up Your First Snowflake db
    • Connecting to Snowflake
      • Web-based GUI
      • SnowSQL(Python)
      • Command-line
      • Connectors - ODBC, JDBC, Spark, Node, GO, PYTHON
    • Data Loading
      • Bulk Loading/Unloading from - CSV/JSON/Avro/ORC/Parquet/XML, S3 data sources, compressed file
      • Using snowpipe for micro-batch loading
    • Database Replication and Failovers
      • Replicating and syncing multiple DBs across different regions
      • Configuring database failover
    • Working with Data
      • Update/Merge/Delete
      • Create/Clone
      • Schema setup and ideal architecture
  • Efficient Data Storage in Snowflake
    • Understanding Micro-partitions vs Static partitions
    • Query Pruning
    • Data Clustering of micro-partitions
    • Clustering Keys
    • Clustered Tables
    • Automatic Clustering
    • Working with Temp tables and Transient tables
    • Views vs Secure views
  • Efficient Querying in Snowflake
    • Basics of querying in Snowflake
      • Subqueries
      • Common Table Expressions
      • Windowed functions
    • Advanced querying
      • Querying staged files
      • Hierarchical data
      • Persisted Query Results
      • Query Profile to analyze queries
      • Sequences
      • Estimating with HyperLogLog (HLL)
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.