Snowflake SnowPro Core (COF-C03) Cert Prep

Course details

Explore the comprehensive functionalities of the Snowflake AI Data Cloud and its architecture in this detailed course. Gain crucial skills in account management and data governance, focusing on access control and network rules to ensure robust data security. Study the intricacies of data loading, unloading, and ensuring efficient connectivity. Enhance your querying skills through optimization and transformation techniques, leveraging micro-partition pruning and window functions. Discover strategies for effective data collaboration and sharing, utilizing Snowflake's marketplace and secure data sharing features. Designed for professionals with at least six months of Snowflake experience, this course immerses you in scenarios you might encounter during the SnowPro Core Certification exam. Join Adam Morton in unraveling the complexities of Snowflake, from AI advancements to essential security features. By the end of this course, you'll be prepared for the certification exam by becoming more proficient in the latest Snowflake capabilities.

Concepts

Welcome

Course orientation (must watch first )
Signing up for the Snowflake trial
Snowsight web UI orientation

Snowflake AI Data Cloud Features and Architecture

The Snowflake Data Cloud
IaaS vs. PaaS vs. SaaS
Snowflake editions
Commercial options
Phased release process
Snowflake architecture
Data sharing
Tools and interfaces
Connectors
Data partner ecosystem
Snowflake table types
Snowflake view types
Snowflake stage types
Extensibility
Data types
Non-relational data
Row vs. column orientated databases
Micro-partitions
Data clustering
Storage layer

Account Management and Data Governance

Managing Snowflake accounts
Access control
Security features
Data security
Object tagging
Snowflake Horizon
Network rules

Data Loading, Unloading, and Connectivity

Stages
File formats
Key commands
Bulk vs continuous loading
Best practices for data loading
Load options
Unloading data
Streams and tasks
Snowpipe streaming
Dynamic tables
Openflow

Performance Optimization, Querying, and Transformation

Cost management
Virtual warehouses
Configuring a virtual warehouse
Caching
Managing virtual warehouses
Query profile
Data spilling
Micro-partition pruning
Query acceleration service
Search optimisation service
Window functions
Estimating functions
Table sampling
User-defined functions
Stored procedures
Merge operator
TRY function
Pivot and Unpivot
Common table expressions
Working with semi and unstructured data
Iceberg
dbt projects

Data Collaboration

Underlying storage concepts
Secure data shares
Data marketplace
Data exchange
Native applications
Data clean rooms
Snowflake Cortex services
Infrastructure protection
High availability
Data encryption
Data protection
Cloning
Time travel
Fail safe