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
Related courses
- Intro to Snowflake for Devs, Data Scientists, Data Engineers
- Using Snowflake with Tableau
- Introduction to Gen AI with Snowflake
- Introduction to Modern Data Engineering with Snowflake
- Advanced Data Engineering with Snowflake
- Apache Iceberg: From Zero to Production Data Lakehouse
- Databricks Certified Data Analyst Associate Cert Prep
- Build with AI: LLM-Powered Data Analysis App with Python and Streamlit
Related learn paths
- Explore a Career in Data Engineering
- Generative AI Professional Certificate by Snowflake
- Data Engineering Professional Certificate by Snowflake
- Explore a Career in SQL Development
- Introduction to Fundamental Skills for Data Work: Data Storage
- Prepare for the Power BI Data Analyst Associate (PL-300) Certification
- Software Development Fundamentals
- Advance Your Skills in AI and Machine Learning