In the Data Analytics with Snowflake LearningKIT, you will explore Snowflake, how to set up Snowflake, execute queries using the snowflake web interface, and perform various operations like time travel and Fail-safe in snowflake. You will also explore the loading data into Snowflake, integrate Snowflake with Google Cloud Storage, Azure Blob Storage, and Amazon S3, unloading data from Snowflake to all types of internal as well as external storage. You will also learn performance optimization and clustering, working with continuous data and semi-structured data, and performing advanced analytics in Snowflake. You will also explore how to manage and administer snowflake and how to securely share snowflake objects with other snowflake users.
Track 1: Getting Started with SnowflakeIn this track, the focus will be on uisng the Snowflake platform, working with queries, dashboards, tables, and using Time Travel and SnowSQL CLI.
Courses (4 hour +):
- Getting Started with Snowflake: Using the Snowflake Data Platform
- Getting Started with Snowflake: Queries, Dashboards, & Tables
- Getting Started with Snowflake: Using Time Travel & the SnowSQL CLI
Track 2: Working with the Snowflake Data PlatformIn this track, the focus will be on Snowflake. You will explore Snowflake data loading and queries.
Courses (8 hours +)
- Data Loading in Snowflake: Fundamentals of Stages
- Data Loading in Snowflake: Using External Stages
- Data Loading in Snowflake: Unloading Data
- Queries in Snowflake: Getting Started with Performance Optimizations
- Queries in Snowflake: Search Optimization, External Table Partitions, & Views
Track 3: Advanced Analytics with SnowflakeIn this track, the focus will be on Snowflake continuous data, analytics, and managing Snowflake.
Courses (8 hours +)
- Continuous Data: Ingesting Continuous Data in Snowflake
- Continuous Data: Automating Data Ingestion from Cloud Storage into Snowflake
- Advanced Analytics: Performing Analytics Using Snowflake
- Semi-structured Data: Loading and Querying JSON & XML Data in Snowflake
- Managing Snowflake: Administering a Snowflake Account
- Data Sharing in Snowflake: Implementing Secure Data Sharing
Assessment:• Final Exam: The Snowflake Data Platform
