Snowflake
What is Snowflake ?
Snowflake is cloud based data warehouse and analytical tool. With so many SAAS based Data warehouse applications available currently that are competing against one another, Snowflake stands out among the crowd for it uniqueness in design and approach. Snowflake works on an application that is faster and easier to handle. Unlike other data warehouse systems Snowflake is not built on Big data platforms rather it works on new SQL engine that is best suited for cloud.
About Snowflake
Snowflake is the best cloud based data warehousing & analytics tool. It is very unique in its approach and design hence most large sized organizations started to use this tool. The number of job openings on snowflakes are high these days as the tool started to emerge. The number of vacancies are expected to increase even more as the tool grows and more organizations start to adapt to Snowflake.
Looking to get placed on a snowflake?
If yes, you are in the right place. Learning any tool is actually easy if you have the right mentor that can train you. We at Nandini Software Solutions from have got expert trainers that can train you and help you crack the dream job. Snowflake is a special application that is much faster than the other competitive data warehousing as it works on Big data unlike others that work on Big Data. The main advantage in snowflakes is that the users can track the changes in date over a date range of up to 60 days. You can go back in time up to 60 days and look at the changes that are made. We are the leading Snowflake training institute in Marathahalli, Bangalore with more than 80% success rate in placing the students in various companies.
Snowflake Course Content
Data Terminology
- Data
- Database
- Database Management System
- Warehouse
- ETL
- Analytical Tools
Data Service line
- Use cases of snowflake
- Data flow in Data service line projects
Snowflake Introduction
- What is snowflake
- Advantages of snowflake
- Editions of snowflake
- Snowflake Free trial
- AWS free Trail
Snowflake Architecture
- Shared disk architecture
- Shared nothing architecture
- Hybrid Architecture
- Global Service Layer
- Query processing Layer
- Storage Layer
Global service layer
- Meta Data
- Authentication
- Authorization
- Query result cache
- Metadata Cache
Query Processing Layer
- Virtual warehouses
- Clusters
- Vertical scaling
- Horizontal scaling
- Virtual warehouse parameters
Storage Layer
- Compression
- Micro – Partitions
- Columnar Storage
Data Loading
- Stages
- File Formats
- Put and copy into command
- Storage integration
- Bulk loading
- Continuous loading
- Snow pipe
- Working with unstructured data
Time Travel
- Time Travel
- Offset
- Time stamp
- Statement id
- Fail safe
- Data recovery
- Undrop
Views
- Materialized views
- Non – Materialized views
Shares
- Producer account
- Consumer account
- Reader / Managed account
- Inbound shares
- Outbound shares
Zero copy cloning
- Normal cloning
- Zero copy cloning
Streams
- CDC
- Streams
- Streams offset
Tables
- Temporary table
- Transient table
- Permanent table
Editions
- Standard
- Enterprise
- Business Critical
- Virtual Private Snowflake
Query Optimization
- Dedicated warehouse
- Clustering key
- Materialized view
- Caching
- Scaling
Caching
- Metadata Cache
- Warehouse Cache
- Query Results Cache
Access Management
- RBAC Roles
- Roles
- Users
- System Defined Roles
- User Defined Roles
Making Policy
- PPI
- Masking data
- Masking data per role
Task and Schedulers
- Task
- Child Task
- Parent Task
- Tree of Tasks
Stored Procedures
- Stored procedures
- Sql scripting
- Java scripting
- Python scripting
Projects
- Real Time project Explanation
- One project
- Connecting to other tools
Interview prep
- Sample resumes
- Interview preparation
- Sql interview questions
- Data Warehouse core
- Snowflake interview questions
- Project Related interview questions
Every concepts in this course has it’s own lab session for hands on practice
Raw Files
Documentations
Lab Notes
Interview Questions
Recorded Videos