fbpx

Snowflake Online Training

coursack
Coursack Tutor
Last Update October 7, 2023
0 already enrolled

About This Course

Learn from the best with Coursack’s Snowflake Online Training course. You will master the fundamentals of data warehousing capabilities, dealing with data and analytics and more. The course will teach you how to write queries and use SQL. You will also learn about the different types of data warehousing, design models, and the concepts behind them. This Snowflake Online Training Course curriculum is designed to prepare you for SnowPro Core Certification Exam. At the end of the training you will be covering multiple real-time projects.

Snowflake Training

Contact for Next batch on Snowflake Online Training.

Course Features
livetraining
Book FREE DEMO Class
Course Syllabus
  • Key Concepts & Architecture
  • Cloud Platforms
  • Snowflake Editions
  • Overview of Key Features
  • Overview of the Data Lifecycle
  • Overview of the Ecosystem
  • Snowflake Partner Connect
  • SnowSQL (CLI Client) – Installation, Configuring and Usage
  • Overview of Data Loading/Unloading
  • Data Loading/Unloading Considerations
  • Preparing to Load/Unload Data
  • Bulk Loading/Unloading from a Local File System
  • Bulk Loading/Unloading from Amazon S3
  • Loading Continuously Using Snowpipe
  • Loading Using the Web Interface (Limited)
  • Querying Data in Staged Files
  • Querying Metadata for Staged Files
  • Transforming Data During a Load
  • Troubleshooting Bulk Data Loads
  • Web Interface
  • Virtual Warehouses
  • Databases, Tables & Views
  • Queries
  • Date & Time Data
  • Semi-structured Data
  • Binary Data
  • Snowflake Time Travel & Fail-safe
  • Introduction to Data Sharing
  • Data Providers
  • Data Consumers
  • Working with Shares
  • Using Secure Objects to Control Data Access
  • Configuring a Reader Account
  • Managing Reader Accounts
  • Streams, Tasks & Snowpipe
  • System Usage & Billing
  • Understanding Snowflake Credit and Storage Usage
  • Monitoring Credit and Storage Usage
  • Resource Monitors
  • Parameter Management
  • User Management
  • Summary of Security Features
  • Network Policies
  • Multi-Factor Authentication (MFA)
  • Access Control in Snowflake (DAC & RBAC)
  • Query Tuning
  • Clustering
  • Materialized Views
  • Performance Considerations
Join our Social Learning Group

Learning Objectives

You will learn the Snowflake data warehouse platform
You will be equipped with SnowPro Cro certification knowledge

Requirements

  • Familiarity with database & data warehousing concepts
  • Familiarity with SQL
  • Laptop/Desktop required for this training

Target Audience

  • Experience with one of the Cloud service is required.
  • Minimal Programming knowledge
  • Ideal for 2+ years of work experience.
snowflake training

18,00024,500

27% off
Level
Intermediate
Duration 60 hours
Language
English

Want to receive push notifications for all major on-site activities?