
Hands-On Essentials: Collaboration, Marketplace & Cost Estimation Workshop
A course covering Snowflake's revolutionary collaboration technologies. Learn to create listings, get listings sent by other accounts, and shop for data sets on the Data Marketplace. Understand how your organization can get rid of nightly extracts and cumbersome ETL processes. This course also helps those new to SQL brush up on some important SQL skills including basics like DISTINCT, GROUP BY, ORDER BY, JOINS, and control-of-flow like BEGIN, END, DECLARE and FOR. Finally, the course covers cost categories, cost estimation, and some beginner-level cost control mechanisms.
Skills / Knowledge
- SQL Basics
- SQL Intermediate
- SQL Block Scripting/Control-of-Flow
- Snowflake COPY INTO
- File Formats
- Snowflake Cost Categories
- Snowflake on Azure
- Snowflake on GCP
- Snowflake Data Marketplace
- SQL UPDATE
- SQL Cursor
- COPY INTO with Column Count Mismatch
- Local SQL Variables
- Secure UDTFs
- Secure Views
- Data Listing Development
- Snowflake Provider Studio
- Data Loading with Column Name Matching
- Snowflake ORGADMIN Role
- Snowflake Account Creation