SnowPro Core Certification Training
About Course
SnowPro Core Certification validates foundational knowledge in Snowflake, covering key concepts like architecture, querying data, loading and transforming data, managing users and security, and monitoring and optimizing performance. Targeted at data professionals, analysts, and developers, it confirms proficiency in using Snowflake’s cloud data platform effectively. Benefits include enhanced career opportunities in data engineering, analytics, and cloud data warehousing. Achieving this certification demonstrates competence in leveraging Snowflake’s features for efficient data management, ensuring organizations can maximize the platform’s capabilities for scalable and performant data solutions.
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
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 9Performance 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.
