Corporate SnowPro Core Training Course

1. Key features of the Snowflake Data Cloud

1. Scalability and performance
2. Cloud-agnostic platform
3. Data sharing capabilities
4. Automatic scaling and elastic compute

2. Key Snowflake tools and user interfaces

1. Snowflake Web Interface
2. Command Line Interface (CLI)
3. Third-party integration and connectors
4. API usage and automation

3. Snowflake’s catalog and objects

1. Databases, schemas, and tables
2. Views and stored procedures
3. User-defined functions
4. Materialized views

4. Snowflake storage concepts

1. Data storage architecture
2. File storage formats and compression
3. Data replication and failover mechanisms
4. Data warehousing and data lake integration

1. Security principles

1. Encryption and key management
2. Network policies and firewall configurations
3. Role-based access control
4. Compliance and certifications

2. Entities and roles used in Snowflake

1. User and role management
2. Hierarchical role structure
3. Role privileges and grants
4. Managing service accounts

3. Data governance capabilities in Snowflake

1. Data masking and tokenization
2. Audit logging and monitoring
3. Data classification and metadata management
4. Regulatory compliance features

1. Use of the Query Profile

1. Understanding query execution plans
2. Analyzing query performance statistics
3. Identifying bottlenecks and optimization points
4. Query history and analysis tools

2. Virtual warehouse configurations

1. Size and scaling options
2. Warehouse performance tuning
3. Multi-cluster warehouses
4. Cost management and optimization

3. Virtual warehouse performance tools

1. Performance monitoring dashboards
2. Auto-suspend and auto-resume settings
3. Resource monitoring and allocation
4. Query acceleration features

4. Optimize query performance

1. Indexing and partitioning strategies
2. Query rewriting and optimization techniques
3. Caching mechanisms
4. Data clustering and sorting

1. Concepts and best practices for loading data

1. Data ingestion methods
2. File format considerations
3. Data validation and quality checks
4. Bulk loading vs incremental loading

2. Commands used to load data

1. COPY INTO command
2. INSERT and UPDATE commands
3. Staging and data pipelines
4. Automating data loads

3. Concepts and best practices for unloading data

1. Data extraction strategies
2. File format and compression options
3. Ensuring data consistency
4. Performance considerations

4. Commands used to unload data

1. COPY INTO LOCATION command
2. Exporting data to external storage
3. Automating data unloads
4. Data unloading for analytics and reporting

1. Working with standard data

1. Data type conversions
2. Aggregation and summarization
3. Joining and merging datasets
4. Data cleaning and preprocessing

2. Working with semi-structured data

1. JSON, XML, and AVRO handling
2. Flattening and parsing techniques
3. Schema inference and evolution
4. Data integration and ETL processes

3. Working with unstructured data

1. Blob storage and binary data handling
2. Text analytics and processing
3. Integration with AI/ML tools
4. Data extraction and transformation

1. Continuous Data Protection with Snowflake

1. Time travel and data recovery
2. Fail-safe and disaster recovery
3. Data retention policies
4. Backup and restore procedures

2. Snowflake data-sharing capabilities

1. Secure data sharing options
2. Cross-account data sharing
3. Data marketplace and public shares
4. Managing and monitoring shared data