Snowflake SnowPro Core Cert Prep

Course details

The SnowPro Core Certification demonstrates your ability to apply core technical concepts, skills, and expertise when implementing and migrating to Snowflake. A SnowPro Core Certified professional has a proven understanding of the Snowflake platform, along with the knowledge required to design, develop, and manage secure, scalable Snowflake solutions to drive more productive and efficient business objectives.

Join instructor and Snowflake expert Adam Morton as he guides you through the six domains of the official exam: Snowflake cloud data platform features and architecture, account access and security, performance concepts, data loading and unloading, data transformations, and data protection and data sharing.

Concepts

Introduction

Course orientation
Signing up for the Snowflake trial
Snowsight web UI orientation

Domain 1.0 - Snowflake Cloud Data Platform Features and Architecture

Domain 1.0 - Introduction
The Snowflake data cloud
IaaS vs. PaaS vs. SaaS
Snowflake editions
Commercial options
Phased release process
Snowflake architecture
Data sharing
Tools and interfaces
Partner ecosystem
Domain 1.0 - Part 1 recap
Snowflake table types
Snowflake view types
Snowflake stage types
Extensibility
Data types
Non-relational data
Domain 1.0 - Part 2 recap
Row- vs. column-oriented databases
Micro-partitions
Data clustering
Storage layer
Domain 1.0 - Part 3 recap

Domain 2.0 - Account Access and Security

Domain 2.0 - Introduction
Managing Snowflake accounts
Access control
Security features
Data security
Object tagging
Secure views
Domain 2.0 - Recap

Domain 3.0 - Performance Concepts

Domain 3.0 - Introduction
Virtual warehouse
Configuring a virtual warehouse
Caching
Managing virtual warehouses
Query profile
Data spilling
Micro-partition pruning
Search optimization service
Domain 3.0 - Recap

Domain 4.0 - Data Loading and Unloading

Domain 4.0 - Introduction
Stages
File formats
Key commands
Bulk vs. continuous loading
Best practices for data loading
Load options
Unloading data
Streams and tasks
Domain 4.0 - Recap

Domain 5.0 - Data Transformations

Domain 5.0 - Introduction
Estimating functions
Table sampling
Stored procedures
User-defined functions
Working with semi-structured data
Working with unstructured data
Domain 5.0 - Recap

Domain 6.0 - Data Protection and Data Sharing

Domain 6.0 - Introduction
Infrastructure protection
High availability
Data encryption
Data protection
Cloning
Time travel
Fail safe
Underlying storage concepts
Domain 6.0 - Part 1 recap
Secure data shares
Data marketplace
Data exchange
Domain 6.0 - Part 2 recap

The Snowflake SnowPro Core Certification

About the exam

Conclusion

Course summary