Learning SnowflakeDB
1h 43mBeginner2025-02-06
Authors

Lynn Langit
Cloud Architect
Course details
Are you in the process of trying to scale your business but bumping up against storage and capacity limits? Rather than shelling out more resources for expensive hardware and software licenses, consider Snowflake, the popular data warehouse and data management platform with unique data exchange capabilities for your business. Join instructor Lynn Langit and learn about how to use Snowflake—the power of the cloud awaits you.
Discover why Snowflake is one of the most rapidly growing cloud-based data management platforms in the industry. Explore the features and functions of the platform, what Snowflake does, how it works, and how to get the most out of its data storage and query processing power with hands-on examples, demos, and scenarios along the way. Lynn gives you tips and techniques for account management, authentication, security protocols, architectural patterns, the data life cycle, and more.
Discover why Snowflake is one of the most rapidly growing cloud-based data management platforms in the industry. Explore the features and functions of the platform, what Snowflake does, how it works, and how to get the most out of its data storage and query processing power with hands-on examples, demos, and scenarios along the way. Lynn gives you tips and techniques for account management, authentication, security protocols, architectural patterns, the data life cycle, and more.
Skills covered
SnowflakeCloud StorageDatabase DevelopmentDatabase ManagementCloud ServicesLearningCloud ComputingSoftware Development
Concepts
0. Introduction
- 01 - Driving maximum results with a flexible data cloud
- 02 - What you should know
- 03 - Use cloud services
1. SnowflakeDB Overview
- 04 - Meet SnowflakeDB
- 05 - Understand SnowflakeDB data platform
- 06 - Compare cloud data warehouse solutions
- 07 - Review SnowflakeDB architecture
- 08 - Use SnowflakeDB cloud tools
- 09 - Use Snowpark Python worksheets
2. SnowflakeDB Data Storage and Files
- 10 - See SnowflakeDB queries
- 11 - Learn SnowflakeDB file ingest
- 12 - Load SnowflakeDB using web UI
- 13 - Load SnowflakeDB from S3
- 14 - Load SnowflakeDB using Snowpipe streams
- 15 - Scenario - Import files and data into SnowflakeDB
3. SnowflakeDB Query Processing
- 16 - Use SnowflakeDB for SQL queries
- 17 - Understand SnowflakeDB dashboards
- 18 - Create and use user-defined functions
- 19 - Optimize virtual warehouses
- 20 - Scenario - Optimize SnowflakeDB compute
4. SnowflakeDB Data Services
- 21 - Understand SnowflakeDB account usage
- 22 - Learn SnowflakeDB authentication and authorization
- 23 - Review Snowflake DB sessions
- 24 - Implement SnowflakeDB policies
- 25 - Scenario - Secure data on SnowflakeDB
5. SnowflakeDB Partners and Architectures
- 26 - Learn the Snowflake data life cycle
- 27 - Use SnowflakeDB Data Marketplace
- 28 - Use SnowflakeDB Partner Connect
- 29 - Scenario - Design and build solutions with SnowflakeDB
Conclusion
- 30 - Keep learning