SnowPro Core: SnowPro Core

Curriculum For This Course

Intorduction

3Lectures

Time 00:10:14

Snowflake Features & Architecture

22Lectures

Time 01:56:04

Account Access & Security

16Lectures

Time 01:04:04

Performance Concepts: Virtual Warehouses Introduction

8Lectures

Time 00:33:09

Performance concepts

9Lectures

Time 00:50:35

Data Loading & Unloading

14Lectures

Time 01:15:01

Data Transformtions

7Lectures

Time 00:26:06

Storage, Data Protection & Data Sharing

13Lectures

Time 00:51:24

Intorduction
	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
	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
	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
	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
	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
	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
	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
	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

Free SnowPro Core Exam Questions & Snowflake SnowPro Core Dumps
Snowflake.train4sure.snowpro core.v2024-04-13.by.lana.80q.ete	Downloads: 272	Size: 84.83 KB
Snowflake.braindumps.snowpro core.v2021-05-25.by.megan.45q.ete	Downloads: 1235	Size: 49.58 KB