This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities.

Throughout the course you will learn to:

• Work with Semi-Structured Data: Query and transform complex data formats like JSON and Parquet, and manage nested structures efficiently.
• Enable Secure Data Sharing: Configure secure data-sharing mechanisms and explore collaborative use cases via Snowflake Data Marketplace.
• Automate Workflows: Build and manage scheduled workflows using tasks, stored procedures, and Snowflake scripting.
• Optimize Performance and Costs: Monitor resource usage, analyze costs, and implement strategies like auto-scaling for optimal efficiency.
• Apply Advanced Snowflake Features: Combine automation, collaboration, and performance techniques to address real-world business challenges.

If your team requires different topics, additional skills or a custom approach, our team will collaborate with you to adjust the course to focus on your specific learning objectives and goals.

This course is ideal for data analysts, engineers, scientists, database administrators, and architects responsible for managing and optimizing data workflows. It's best suited for professionals who already have foundational Snowflake knowledge and are ready to advance their skills to handle complex data operations, enable secure collaboration, and optimize their Snowflake environments.

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience skill level, interests and participation.

Day 1: Semi-Structured Data and Data Sharing

1. Working with Semi-Structured Data

• Querying and transforming JSON, XML, and Parquet formats.
• Using FLATTEN to manage nested data structures.

2. Data Sharing and Collaboration

• Setting up secure data shares and managing permissions.
• Exploring Snowflake Data Marketplace use cases.
• Hands-On Lab
• Querying and visualizing semi-structured data.
• Configuring and testing data-sharing scenarios.

3. Advanced Governance Features

• Configuring role-based access controls and managing authentication.
• Implementing data masking and encryption techniques.
• Hands-On Lab
• Securing data using advanced governance features.
• Testing secure sharing workflows.

Day 2: Automation and Performance Optimization

3. Task Automation

• Creating and managing tasks for scheduled workflows.
• Building workflows using Snowflake scripting and stored procedures.
• Hands-On Lab
• Automating workflows with tasks and scripting.

4. Performance and Cost Management

• Monitoring resource utilization with Query Profile and Account Usage views.
• Implementing auto-scaling policies for cost and performance optimization.
• Hands-On Lab
  • Analyzing resource utilization and optimizing virtual warehouse configurations.
  • Applying best practices for cost management and performance tuning.