Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

[2025] SnowPro Advanced Architect COURSE

Name: [2025] SnowPro Advanced Architect COURSE
Rating: 4.0 (652 reviews)

Pass the Snowflake SnowPro Advanced Architect Certification ARA-C01 with flying colors!

Created byPauwel Dalmeida

Last updated 2/2025

English

What you'll learn

FULLY UPDATED FOR ARA-C01: Pass the SnowPro Advanced Architect Certification
Around 300 slides are available as downloadable PDF
+100 questions in quizzes to enforce your knowledge
Master the Snowflake Architecture
Learn how to manage Accounts and Security
Learn how to use the tools for Data Engineering in Snowflake
Learn how to Otimize the Performance

Course content

7 sections • 94 lectures • 7h 37m total length

Course Overview & Resources Download1:20
Get started with the SnowPro advanced architect course by focusing on real-world practice, hands-on lessons, and a realistic study plan with dates, while understanding prerequisites like the SnowPro Core.
Pre-requisites

Organization, Accounts and Editions3:06
Account Identifiers2:19
One Account: benefits vs disadvantages2:32
Compliance2:16
Parameters3:20
Storage Integration2:02
Replication and Failover2:05
Public and Private Connection2:27
Access Control Overview6:07
System-Defined Roles and Custom Roles4:42
System-defined Roles (Best Practices)1:06
Primary and Secondary Roles1:40
Access Control Commands1:39
[Hands-On] - Access Control6:40
Access Control (Best Practices)1:24
[Hands-On] - Managed Schemas5:47
Sensitive Data (Best Practices)3:08
Authentication Overview2:19
Authentication for Humans3:56
[Hands-On] Multi-Factor Authentication1:57
Authentication for Machines - Part 15:11
Authentication for Machines - Part 23:33
Network Security4:34
[Hands On] Network Policies3:50
End-to-End Encryption3:30
Encryption Key Management2:51
Secure Data Sharing2:41
[Hands-On] - Secure Data Sharing5:54
Time Travel2:03
[Hands-On] Time Travel14:17
Time Travel
Secure Views4:13
Column-level Security3:05
[Hands-On] Column-level Security5:21
Cloning1:28

Data Modeling with Snowflake8:10
Data Modeling
Schema-on-Read and Schema-on-Write4:30
Marketplace4:10
[Hands On] Marketplace15:56
Reader Accounts3:20
Secure Data Sharing - Part 14:02
[Hands On] Secure Data Sharing - Listings13:22
Secure Data Sharing - Part 25:34
[Hands On] Secure Data Sharing - Data Exchange16:31
Secure Data Sharing - Part 34:13
Secure Data Sharing
Reference Architectures and Development Lifecycles12:10
Data Recovery - Replication7:07
[Hands On] Data Recovery - Replication11:02
Data Recovery - Failover7:08
[Hands On] Data Recovery - Failover10:08
Data Recovery

Prerequisite: Download Data2:01
download a usa real estate dataset from kaggle to start the data engineering section. extract the 14mb zip to csv with 1.2 million rows and 10 columns.
Prerequisite: Generate Key/Pair3:12
Data Ingestion Overview3:14
Staging6:36
[Hands On] Create an AWS Account1:39
[Hands On] Read from AWS with an External Stage9:15
Staging Data
Loading Data - Overview6:56
Loading Data - Overview
Bulk Loading7:02
[Hands On] Bulk Loading5:53
Bulk Loading
Continuous Loading1:48
Snowpipe4:20
[Hands On] Load with Snowpipe from AWS10:27
Snowpipe Streaming6:20
Snowpipe Streaming
Kafka Connector4:44
Kafka Connector
Alternatives of Loading1:39
Views2:40
External Functions3:36
Stored Procedures4:08
UDF2:22
Streams7:23
[Hands On] Streams3:56
Tasks6:05
Streams and Tasks2:20
Data Processing
Semi-Structured Data14:01
[Hands On] Semi-Structured Data9:01
Semi-Structured Data
Data Unloading7:01
[Hands On] Data Unloading5:36
Create a database and a table, define Json and CSV file formats, export data to stages using copy commands, verify files, and clean up.
Data Unloading
SnowSQL2:46
[Hands On] SnowSQL5:06
ODBC Driver2:41
[Hands On] ODBC Driver3:23
JDBC Driver1:05
SQL API0:52
[Hands On] SQL API4:07
Spark Connector2:52
Python Connector0:59
Python and Spark Connector

Requirements

MUST HAVE - Snowflake SnowPro Core Certification
MUST HAVE - Real Hands On experience with Snowflake

Description

* 01/2025 update *

- Add 2 real exam questions in the "Short Exam Questions" section

* 12/2024 update *

- Add the "Short Exam Questions" section

* 03/2024 update *

- Updated some subtitles

* 02/2024 update *

- Add all the code in the first session

- Corrected the Virtual Warehouse session

* 01/2024 update *

- Modify the parameters session in order to fix a typo

Welcome in this course!

Advanced course

No practical exam included: This course contains no practical exam. This course focuses on teaching the knowledge needed to PASS the exam.

The Snowflake SnowPro Advanced Architect certification is one of the most challenging exams from Snowflake.

This course also includes:

Lifetime access to all future updates
300 slides available to download
A responsive instructor in the Q&A Section
Udemy Certificate of Completion Ready for Download
A 30 Day "No Questions Asked" Money Back Guarantee!

Certification exam overview:

The SnowPro Advanced: Architect Certification assesses advanced expertise and proficiency in implementing comprehensive architect solutions with Snowflake. This certification evaluates the capability to:

Develop a complete data flow from source to consumption utilizing Snowflake's Platform
Create and implement a data architecture that aligns with business, security, and compliance standards
Choose suitable Snowflake and third-party tools to enhance architecture performance.
Create and implement a collaborative data set using the Snowflake Marketplace and Data Exchange

Join me in this course if you want to become an Snowflake SnowPro Advanced Architect and master the Snowflake platform!

Sign up today!

Who this course is for:

Solution Architects
Database Architects
System Architects
Data Architect
Data Engineers
Snowflake Developer
Cloud Architect
Cloud Developers

[2025] SnowPro Advanced Architect COURSE

What you'll learn

Explore related topics

Course content

Course Overview1 lecture • 1min

Create a Snowflake account1 lecture • 2min

Domain 1: Accounts & Security34 lectures • 2hr 3min

Domain 2: Snowflake Architecture15 lectures • 2hr 7min

Domain 3: Data Engineering36 lectures • 2hr 47min

Domain 4: Performance Optimization7 lectures • 36min

Short Exam Questions0

Requirements

Description

Who this course is for: