Loading Course Schedule...
PT27707
Training Summary
Snowflake is a cloud-based data warehouse and analytical tool. With so many SaaS Data warehouse solutions available competing against one another, Snowflake stands out among the crowd for its uniqueness in design and approach. Unlike other data warehouse systems, Snowflake is not built on Big Data platforms; instead, it works on a new SQL engine best suited for the cloud.
Snowflake has one of the best ACID (atomicity, consistency, isolation, and durability) compliant solutions. One of Snowflake’s unique capabilities is its table structures wherein Micro–Partitions and Data–Clustering is adopted. Snowflake allows users to “time travel,” i.e., track data changes over time and view changes made in the past 90–days.
Some of the other features of Snowflake are:
- Cloning – the clone feature creates an instant copy of any Snowflake object
- Undrop – any dropped object (Databases, schemas, tables, etc.) can be undropped
- Fail-safe – In the event of any disaster like hardware or disk failures, Snowflake engineers can recover the data for up to seven days.
Prerequisites
Attendees should Data Warehouse knowledge
Duration
4 Days/Lecture & Lab
Audience
The audience for this class is Data Analysts, Data Engineers, Data Scientists, Data Architects, and Database Administrators.
Course Topics
- Data Warehousing Overview
- Architecture and Overview
- Data Movement
- Objects and Commands
- SQL Support for Data Analysis
- Managing Security
- Semi-structured data
- Caching
- Clients and Ecosystem
- Security
- Performance and Concurrency
- Account and Resources Management and ::Monitoring