Snowflake SnowPro Core Cert Prep

Course details

The SnowPro Core Certification demonstrates your ability to apply core technical concepts, skills, and expertise when implementing and migrating to Snowflake. A SnowPro Core Certified professional has a proven understanding of the Snowflake platform, along with the knowledge required to design, develop, and manage secure, scalable Snowflake solutions to drive more productive and efficient business objectives.

Join instructor and Snowflake expert Adam Morton as he guides you through the six domains of the official exam: Snowflake cloud data platform features and architecture, account access and security, performance concepts, data loading and unloading, data transformations, and data protection and data sharing.

Concepts

0. Introduction

01 - Course orientation
02 - Signing up for the Snowflake trial
03 - Snowsight web UI orientation

1. Domain 1.0 - Snowflake Cloud Data Platform Features and Architecture

04 - Domain 1.0 - Introduction
05 - The Snowflake data cloud
06 - IaaS vs. PaaS vs. SaaS
07 - Snowflake editions
08 - Commercial options
09 - Phased release process
10 - Snowflake architecture
11 - Data sharing
12 - Tools and interfaces
13 - Partner ecosystem
14 - Domain 1.0 - Part 1 recap
15 - Snowflake table types
16 - Snowflake view types
17 - Snowflake stage types
18 - Extensibility
19 - Data types
20 - Non-relational data
21 - Domain 1.0 - Part 2 recap
22 - Row- vs. column-oriented databases
23 - Micro-partitions
24 - Data clustering
25 - Storage layer
26 - Domain 1.0 - Part 3 recap

2. Domain 2.0 - Account Access and Security

27 - Domain 2.0 - Introduction
28 - Managing Snowflake accounts
29 - Access control
30 - Security features
31 - Data security
32 - Object tagging
33 - Secure views
34 - Domain 2.0 - Recap

3. Domain 3.0 - Performance Concepts

35 - Domain 3.0 - Introduction
36 - Virtual warehouse
37 - Configuring a virtual warehouse
38 - Caching
39 - Managing virtual warehouses
40 - Query profile
41 - Data spilling
42 - Micro-partition pruning
43 - Search optimization service
44 - Domain 3.0 - Recap

4. Domain 4.0 - Data Loading and Unloading

45 - Domain 4.0 - Introduction
46 - Stages
47 - File formats
48 - Key commands
49 - Bulk vs. continuous loading
50 - Best practices for data loading
51 - Load options
52 - Unloading data
53 - Streams and tasks
54 - Domain 4.0 - Recap

5. Domain 5.0 - Data Transformations

55 - Domain 5.0 - Introduction
56 - Estimating functions
57 - Table sampling
58 - Stored procedures
59 - User-defined functions
60 - Working with semi-structured data
61 - Working with unstructured data
62 - Domain 5.0 - Recap

6. Domain 6.0 - Data Protection and Data Sharing

63 - Domain 6.0 - Introduction
64 - Infrastructure protection
65 - High availability
66 - Data encryption
67 - Data protection
68 - Cloning
69 - Time travel
70 - Fail safe
71 - Underlying storage concepts
72 - Domain 6.0 - Part 1 recap
73 - Secure data shares
74 - Data marketplace
75 - Data exchange
76 - Domain 6.0 - Part 2 recap

7. The Snowflake SnowPro Core Certification

77 - About the exam

Conclusion

78 - Course summary