SnowPro® Certifications Training
About Course
SnowPro® Certifications, offered by Snowflake Inc., validate expertise in Snowflake’s cloud data platform. They are designed for data professionals, including data engineers, data analysts, and architects, who work with Snowflake’s technology. Key certifications include SnowPro Core, which covers foundational Snowflake concepts, and advanced certifications focusing on data engineering, data science, and architecture. These credentials demonstrate proficiency in building, optimizing, and managing scalable data solutions on Snowflake. By earning SnowPro® Certifications, professionals enhance their credibility, expand their skill set, and increase their career opportunities in the rapidly growing field of cloud data warehousing and analytics.
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 Opportunities
Course Content
Module 1: Introduction
-
Snowsight Interface
-
Sample Database
-
Worksheets & Interface
-
What is Snowflake?
Module 2: Snowflake Architecture
-
Multi cluster shared-disk
-
Three distinct layers of Snowflake
-
Snowflake fundamental architecture
-
Hands-on: First Data Loading
-
Snowflake Editions
-
Compute Cost
-
Storage & Data Transfer Cost
-
Cost in Snowflake
-
Storage Monitoring
-
Resource Monitors
-
Resource Monitors & Storage Monitoring
-
Warehouses & Multi-Clustering
-
Create a Warehouse
-
Snowflake Objects
-
SnowSQL
Module 3: Data Loading & Unloading
-
Internal Stages
-
External Stages
-
Stages
-
COPY INTO (Bulk Loading)
-
File Format
-
INSERT & UPDATE
-
Hands-on: Storage Integration
-
Loading data
-
Snowpipe
-
Copy Options
-
VALIDATION_MODE
-
Unloading
Module 4: Data Transformation
-
Transformations & Functions
-
Estimation functions
-
UDFs
-
Stored Procedures
-
External functions
-
Secure UDFs & Procedures
-
Sequences
-
Semi-structured data
-
Query semi-structured data
-
Flatten hierarchical data
-
Insert JSON data
-
Unstructured data
-
Directory tables
-
Data Sampling
-
Tasks
-
Streams
Module 5: Additional Snowflake Tools & Connectors
-
Connectors, Drivers & Partner Connect
-
Snowflake Scripting
-
Snowpark
-
Additional Tools & Connectors
Module 6: Continuous Data Protection
-
Time Travel
-
Hands-on: UNDROP
-
Retention period
-
Fail Safe
-
Hands-on: Storage Cost
-
Table Types
Module 7: Zero-Copy Cloning & Sharing
-
Zero-Copy Cloning
-
Data Sharing
-
Hands-on: Create the share
-
Hands-on: Consume the share
-
Database replication
-
Data Sharing & Cloning
Module 8: Account & Security
-
Access Control in Snowflake
-
Roles
-
Privileges
-
Multi-factor authentication
-
Federated Authentication (SSO)
-
Key Pair Authentication
-
Column-Level Security
-
Row-Level Security
-
Network policies
-
Data Encryption
-
Network policies & Encryption
-
Account Usage & Information Schema
-
Release Process
Module 9: Performance Concepts
-
Query Profile & History
-
Caching
-
Micro-partitions
-
Understanding Clustering Keys
-
Defining Clustering Keys
-
System functions for clustering information
-
Micro-partitions & Clustering
-
Search Optimization Service
-
Materialized Views
-
Warehouse Considerations
-
Search Optimization, Materialized Views & Warehouses
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
