Snowflake

6841 Views

Technology

Overview

Curriculum

Features

Overview

Snowflake is the only data platform built for the cloud for all your data and all your users. Mobilize your data to advance your business.

Curriculum

Module 1:- Python
- Foundations of programming:
- Python built-in Data types
- Understanding Data Types in Python
- Control flow statements:
- Functions
- Oops
- Class
- Object
- Constructor
- Arrays
- List comprehensions and Lambda
- Parsing information with Python
- Dictionaries
- Tuples
- Python Programming Language
- Lambdas Python
- Regular Expressions
- Introduction to NumPy
- Arrays Structured Data:
- NumPy’s Structured Arrays
- Advanced NumPy
- Introducing Pandas Objects
- Data Indexing and Selection
- Operating on Data in Pandas,
- Handling Missing Data
- Hierarchical Indexing
- Combining Datasets:
- Aggregation and Grouping and Pivot Tables
Module 2:- SnowFlake
- Snowflake architecture in detail.
- SnowSQL/SQL
- How data processing happens in snowflake.
- Secure data sharing in snowflake.
- Understand different caching layers in snowflake.
- Continues data load using snowpipe.
- Clustering tables in snowflake and how it works under the hood.
- Load data and unload data from AWS , GOOGLE and AZURE cloud
- Snowflake internal stage and external stages.
- Snowflake data sampling and its importance.
- Detail overview about, snowflake clone , failsafe and data retention.
- Unique features of Snowfalke ( time travel , undrop , table swap)
- Scheduling using Tasks
- Streams in snowflake
- Best practices in snowflake

Features