Learn how to use Snowflake, the cloud-based data warehouse and data management platform that includes AWS, Azure, BigQuery, and more.
Overview
Syllabus
Introduction
- Driving maximum results with a flexible data cloud
- What you should know
- Use cloud services
- Meet SnowflakeDB
- Understand SnowflakeDB data platform
- Compare cloud data warehouse solutions
- Review SnowflakeDB architecture
- Use SnowflakeDB cloud tools
- See SnowflakeDB queries
- Learn SnowflakeDB file ingest
- Load SnowflakeDB using web UI
- Load SnowflakeDB from S3
- Load SnowflakeDB using Snowpipe streams
- Scenario: Import files and data into SnowflakeDB
- Use SnowflakeDB for SQL queries
- Understand SnowflakeDB dashboards
- Create and use user-defined functions
- Optimize virtual warehouses
- Scenario: Optimize SnowflakeDB compute
- Understand SnowflakeDB account usage
- Learn SnowflakeDB authentication and authorization
- Review Snowflake DB sessions
- Implement SnowflakeDB policies
- Scenario: Secure data on SnowflakeDB
- Learn the Snowflake data life cycle
- Use SnowflakeDB Data Marketplace
- Use SnowflakeDB Partner Connect
- Scenario: Design and build solutions with SnowflakeDB
- Keep learning
Taught by
Lynn Langit