Corporate SnowPro Core Training Course

1. Key features of the Snowflake Data Cloud

• Scalability and performance
• Cloud-agnostic platform
• Data sharing capabilities
• Automatic scaling and elastic compute

2. Key Snowflake tools and user interfaces

• Snowflake Web Interface
• Command Line Interface (CLI)
• Third-party integration and connectors
• API usage and automation

3. Snowflake’s catalog and objects

• Databases, schemas, and tables
• Views and stored procedures
• User-defined functions
• Materialized views

4. Snowflake storage concepts

• Data storage architecture
• File storage formats and compression
• Data replication and failover mechanisms
• Data warehousing and data lake integration

1. Security principles

• Encryption and key management
• Network policies and firewall configurations
• Role-based access control
• Compliance and certifications

2. Entities and roles used in Snowflake

• User and role management
• Hierarchical role structure
• Role privileges and grants
• Managing service accounts

3. Data governance capabilities in Snowflake

• Data masking and tokenization
• Audit logging and monitoring
• Data classification and metadata management
• Regulatory compliance features

1. Use of the Query Profile

• Understanding query execution plans
• Analyzing query performance statistics
• Identifying bottlenecks and optimization points
• Query history and analysis tools

2. Virtual warehouse configurations

• Size and scaling options
• Warehouse performance tuning
• Multi-cluster warehouses
• Cost management and optimization

3. Virtual warehouse performance tools

• Performance monitoring dashboards
• Auto-suspend and auto-resume settings
• Resource monitoring and allocation
• Query acceleration features

4. Optimize query performance

• Indexing and partitioning strategies
• Query rewriting and optimization techniques
• Caching mechanisms
• Data clustering and sorting

1. Concepts and best practices for loading data

• Data ingestion methods
• File format considerations
• Data validation and quality checks
• Bulk loading vs incremental loading

2. Commands used to load data

• COPY INTO command
• INSERT and UPDATE commands
• Staging and data pipelines
• Automating data loads

3. Concepts and best practices for unloading data

• Data extraction strategies
• File format and compression options
• Ensuring data consistency
• Performance considerations

4. Commands used to unload data

• COPY INTO LOCATION command
• Exporting data to external storage
• Automating data unloads
• Data unloading for analytics and reporting

1. Working with standard data

• Data type conversions
• Aggregation and summarization
• Joining and merging datasets
• Data cleaning and preprocessing

2. Working with semi-structured data

• JSON, XML, and AVRO handling
• Flattening and parsing techniques
• Schema inference and evolution
• Data integration and ETL processes

3. Working with unstructured data

• Blob storage and binary data handling
• Text analytics and processing
• Integration with AI/ML tools
• Data extraction and transformation

1. Continuous Data Protection with Snowflake

• Time travel and data recovery
• Fail-safe and disaster recovery
• Data retention policies
• Backup and restore procedures

2. Snowflake data-sharing capabilities

• Secure data sharing options
• Cross-account data sharing
• Data marketplace and public shares
• Managing and monitoring shared data