Snowflake SnowPro Core Cert Prep

Develop the skills required to prepare to tackle the Snowflake SnowPro Core certification exam.

Introduction

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

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. The Snowflake SnowPro Core Certification

• About the exam

Conclusion

• Course summary