This 4-day course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform.

By the end of this class, you will be able to:

• Illustrate the unique and differentiated architecture of the Snowflake Cloud Data Platform
• Load and transform data
• Evaluate Query Constructs and DDL & DML Operations
• Review Snowflakes broad SQL support for data analysis
• Describe how user and application access can be easily managed
• Demonstrate best practices for working with semi-structured data
• Discuss how Snowflake provides a unique approach to caching Examine the various ways to connect and interact with the Snowflake Platform
• Employ Snowflake's method for continuous data protection
• Utilize Data Sharing to send your data in real-time to Customers and Partners
• Scale your Virtual Warehouse for performance and concurrency
• Explain the different ways you can manage and monitor your Snowflake account

Unit 1: Overview and Architecture

Unit 2: Connecting to Snowflake

Unit 3: Data Protection features

Unit 4: SQL Support in Snowflake

Unit 5: Metadata and caching in Snowflake

Unit 6: Query Performance

Unit 7: Data loading and unloading

Unit 8: Functions, Procedures and Snowflake Scripting

Unit 9: Using Tasks and Managin Security

Unit 10: Access Control and User Management

Unit 11: Introduction to Data Sharing

Unit 12: Cost Management

• Data Analysts
• Data Engineers
• Data Scientists
• Database Architects
• Database Administrators

Snowflake SnowPro Core Certification

Previous Data Warehouse knowledge is expected.