Curriculum For This Course
Video tutorials list
-
Intorduction
Video Name Time 1. Course Structure 1:56 2. Making the Most of This Course 1:28 3. Provisioning a Trial Snowflake Account - Hands-on 6:50 -
Snowflake Features & Architecture
Video Name Time 1. Snowflake Features & Architecture Introduction 0:56 2. What is Snowflake? 9:07 3. Multi-cluster Shared Data Architecture 6:14 4. Storage Layer Overview 3:18 5. Query Processing Layer Overview 3:57 6. Services Layer Overview 2:41 7. Snowflake Editions 2:12 8. Snowflake Object Model 3:33 9. Organizations, Accounts, Databases & Schemas 7:37 10. Table & View Types 5:39 11. Databases, Schemas, Tables & Views - Hands-on 7:33 12. User Defined Functions (UDFs) 7:48 13. Stored Procedures 5:08 14. UDFs, External Functions & Stored Procedures - Hands-on 5:38 15. Sequences 3:08 16. Tasks & Streams 6:52 17. Billing Overview 8:06 18. User Interfaces - Hands-on 7:19 19. SnowSQL - Hands-on 3:40 20. Connectivity: Connectors, Drivers & Partnered Tools 5:12 21. Connectivity: Snowflake Scripting 5:11 22. Snowpark 5:15 -
Account Access & Security
Video Name Time 1. Account Access & Security Introduction 0:51 2. Access Control Overview 4:01 3. Roles 5:01 4. Privileges 2:27 5. Access Control - Hands-on 7:59 6. User Authentication 2:04 7. Multi-factor Authentication (MFA) 3:02 8. Federated Authentication 3:28 9. Key Pair Authentication, OAuth & SCIM 2:45 10. Network Policies 3:14 11. Data Encryption 6:57 12. Column Level Security 5:32 13. Row Level Security 3:37 14. Column and Row Level Security - Hands-on 4:56 15. Secure Views - S3L15 2:19 16. Account Usage & Information Schema 5:51 -
Performance Concepts: Virtual Warehouses Introduction
Video Name Time 1. Performance Concepts: Virtual Warehouses Introduction 0:44 2. Virtual Warehouse Overview 2:56 3. Virtual Warehouse State & Properties 3:39 4. Virtual Warehouse Overview - Hands-on 5:19 5. Virtual Warehouse Sizing and Billing 4:23 6. Resource Monitors 3:06 7. Compute Monitoring & Resource Monitors - Hands-on 5:29 8. Multi-cluster Warehouses 7:33 -
Performance concepts
Video Name Time 1. Query performance analysis tools - Hands-on 7:26 2. SQL Tuning 7:46 3. Caching 4:52 4. Caching - Hands-on 6:10 5. Materialized Views 4:17 6. Clustering 5:57 7. Automatic Clustering 6:07 8. Clustering & Pruning - Hands-on 5:15 9. Search Optimization Service - S5L9 2:45 -
Data Loading & Unloading
Video Name Time 1. Data Loading and Unloading Introduction 0:40 2. Simple Data Loading Methods: INSERT & UI - Hands-on 4:18 3. Stages 8:49 4. Stages - Hands-on 5:28 5. Bulk Loading - COPY INTO TABLE command 7:26 6. File Formats 2:34 7. Bulk Loading - Hands-on 5:08 8. Snowpipe 8:25 9. Data Unloading 5:28 10. Semi-structured Overview 6:09 11. Loading and Unloading Semi-structured Data 5:28 12. Accessing Semi-structured Data 4:05 13. Semi-structured Functions 3:29 14. Semi-structured Data - Hands-on 7:34 -
Data Transformtions
Video Name Time 1. Data Transformations Introduction 0:24 2. Summary of Snowflake Functions 4:51 3. Estimation Functions 6:59 4. Table Sampling 2:52 5. Unstructured File Functions 6:07 6. Directory Tables 2:39 7. File Support REST API 2:14 -
Storage, Data Protection & Data Sharing
Video Name Time 1. Storage, Data Protection & Data Sharing Introduction 0:33 2. Storage Layer Overview 2:04 3. Micro-partitions 4:58 4. Time Travel & Fail-Safe 5:57 5. Time Travel - Hands-on 5:39 6. Cloning 5:02 7. Cloning - Hands-on 2:36 8. Replication 2:30 9. Storage Billing 3:07 10. Secure Data Sharing 8:31 11. Secure Data Sharing - Hands-on 6:16 12. Data Marketplace Hands-on 3:01 13. Data Exchange 01:10
Add Comment