SnowPro® Advanced Architect Certification Training
About Course
The SnowPro® Advanced Architect Certification verifies advanced proficiency in designing Snowflake solutions. It covers complex data warehousing scenarios, performance optimization, security implementation, and integration strategies. Targeting experienced architects and consultants, it validates skills in architecting scalable, reliable, and efficient data solutions on Snowflake. This certification enhances career opportunities by demonstrating mastery in leveraging Snowflake’s capabilities for enterprise-grade data architecture and management. It equips professionals to lead and implement complex data projects, ensuring optimal utilization of Snowflake’s cloud data platform to meet business requirements effectively.
What Will You Learn?
- 1. In-Demand Skills
- 2. Career Advancement
- 3. Efficient CRM Management
- 4. Data Security
- 5. Workflow Automation
- 6. Reporting Insights
- 7. Job OpportunitiesHours On Demanded Videos
Course Content
Course Overview
-
Course Overview & Resources Download
-
Pre-requisites
Create a Snowflake account
-
Hands-on: Create a Snowflake account
Domain 1: Accounts & Security
-
Organization, Accounts and Editions
-
Account Identifiers
-
One Account: benefits vs disadvantages
-
Compliance
-
Parameters
-
Storage Integration
-
Replication and Failover
-
Public and Private Connection
-
Access Control Overview
-
System-Defined Roles and Custom Roles
-
System-defined Roles (Best Practices)
-
Primary and Secondary Roles
-
Access Control Commands
-
[Hands-On] – Access Control
-
Access Control (Best Practices)
-
[Hands-On] – Managed Schemas
-
Sensitive Data (Best Practices)
-
Authentication Overview
-
Authentication Overview
-
Authentication for Humans
-
[Hands-On] Multi-Factor Authentication
-
Authentication for Machines – Part 1
-
Authentication for Machines – Part 2
-
Network Security
-
[Hands On] Network Policies
-
End-to-End Encryption
-
Encryption Key Management
-
Secure Data Sharing
-
[Hands-On] – Secure Data Sharing
-
Time Travel
-
[Hands-On] Time Travel
-
Secure Views
-
Column-level Security
-
[Hands-On] Column-level Security
-
Cloning
Domain 2: Snowflake Architecture
-
Data Modeling with Snowflake
-
Data Modeling
-
Schema-on-Read and Schema-on-Write
-
Marketplace
-
[Hands On] Marketplace
-
Reader Accounts
-
Secure Data Sharing – Part 1
-
[Hands On] Secure Data Sharing – Listings
-
Secure Data Sharing – Part 2
-
[Hands On] Secure Data Sharing – Data Exchange
-
Secure Data Sharing – Part 3
-
Secure Data Sharing
-
Reference Architectures and Development Lifecycles
-
Data Recovery – Replication
-
[Hands On] Data Recovery – Replication
-
Data Recovery – Failover
-
[Hands On] Data Recovery – Failover
-
Data Recovery
Domain 3: Data Engineering
-
Prerequisite: Download Data
-
Prerequisite: Generate Key/Pair
-
Data Ingestion Overview
-
Staging
-
[Hands On] Create an AWS Account
-
[Hands On] Read from AWS with an External Stage
-
Staging Data
-
Loading Data – Overview
-
Bulk Loading
-
[Hands On] Bulk Loading
-
Continuous Loading
-
Snowpipe
-
[Hands On] Load with Snowpipe from AWS
-
Snowpipe Streaming
-
Kafka Connector
-
Alternatives of Loading
-
Views
-
External Functions
-
Stored Procedures
-
UDF
-
Streams
-
[Hands On] Streams
-
Tasks
-
Streams and Tasks
-
Data Processing
-
Semi-Structured Data
-
[Hands On] Semi-Structured Data
-
Semi-Structured Data
-
Data Unloading
-
[Hands On] Data Unloading
-
SnowSQL
-
[Hands On] SnowSQL
-
ODBC Driver
-
[Hands On] ODBC Driver
-
JDBC Driver
-
SQL API
-
[Hands On] SQL API
-
Spark Connector
-
Python Connector
-
Python and Spark Connector
Domain 4: Performance Optimization
-
Persisted Query Result
-
Search Optimization Service
-
Virtual Warehouse
-
Scaling Up vs Scaling Out
-
ACCOUNT_USAGE and INFORMATION_SCHEMA
-
Query Rewrite(Clustering Keys)
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
