Snowflake Decoded - Fundamentals and hands on Training (Udemy.com)
Master the Fundamental Snowflake concepts & acquire the necessary skills to start implementing Snowflake based solutions
Created by: Hamid Qureshi
Produced in 2021
What you will learn
- Snowflake Essentials, it's unique architecture &its differentiation
- Scalability through the virtual warehouse compute clusters
- Staging & Ingesting bulk & streaming data from cloud storage
- Unique features such as zero copy clones, time travel
- Snowflake value proposition through its pricing model
- Secure data sharing with snowflake & non-snowflake users
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 92 / 100
Course Description
This course is not affiliated with Snowflake (the company).
This course provides Snowflake concepts &hands on expertise to help get you started on implementing solutions using Snowflake. This course reinforces the learning through hands on labs, assignments &quizzes.
At a high level we will go through the following topics Introduction - A bit of history about snowflake &its differentiation. Getting Started with Snowflake - Sign up for a snowflake trial, setup the required tools and will create & load our first table into SnowflakeArchitecture - A look into the snowflake concepts, how the snowflake decoupled architecture differs from the traditional database architectures. We will explore how Snowflake virtual warehouses allow scaling up and down of compute as per demand.
Getting data into Snowflake - We will explore the ingestion or loading methods available in Snowflake i.
e. bulk copy &snowpipe. We will stage the data in an S3 bucket and load into Snowflake table using both bulk copy and snowpipe. We will also explore ways to load semi structured data like JSON into Snowflake.
Time Travel& Zero Copy Clones - Time travel &cloning is a very powerful feature unique to Snowflake. We will explore how time travel can help you recover data before a query was run or before a specific time. Combine time travel with cloning and you can create new tables which contain data back in time, and all that without incurring additional storage cost.
Secure Data Sharing - Snowflake based solutions can easily share data with other Snowflake users as well as non Snowflake users. We will explore ways on how to share your data and also how the sharing reuses existing storage.
Who this course is for:
Snowflake beginner to intermediate skills.
Basic knowledge of databases & data warehousing
This course provides Snowflake concepts &hands on expertise to help get you started on implementing solutions using Snowflake. This course reinforces the learning through hands on labs, assignments &quizzes.
At a high level we will go through the following topics Introduction - A bit of history about snowflake &its differentiation. Getting Started with Snowflake - Sign up for a snowflake trial, setup the required tools and will create & load our first table into SnowflakeArchitecture - A look into the snowflake concepts, how the snowflake decoupled architecture differs from the traditional database architectures. We will explore how Snowflake virtual warehouses allow scaling up and down of compute as per demand.
Getting data into Snowflake - We will explore the ingestion or loading methods available in Snowflake i.
e. bulk copy &snowpipe. We will stage the data in an S3 bucket and load into Snowflake table using both bulk copy and snowpipe. We will also explore ways to load semi structured data like JSON into Snowflake.
Time Travel& Zero Copy Clones - Time travel &cloning is a very powerful feature unique to Snowflake. We will explore how time travel can help you recover data before a query was run or before a specific time. Combine time travel with cloning and you can create new tables which contain data back in time, and all that without incurring additional storage cost.
Secure Data Sharing - Snowflake based solutions can easily share data with other Snowflake users as well as non Snowflake users. We will explore ways on how to share your data and also how the sharing reuses existing storage.
Who this course is for:
Snowflake beginner to intermediate skills.
Basic knowledge of databases & data warehousing
Instructor Details
- 4.6 Rating
312 Reviews
Hamid Qureshi
Hamid has 16+ years of experience in data warehouse, big data &cloud solutions. Hamid's experience includes architecting & leading data warehouse & cloud implementations. He has a keen interest in up-and-coming technologies like Snowflake. He is a certified Teradata Master & also certified in Teradata Aster - a big data and data science platform.
More other courses
Unofficial Udemy Student Guide: Courses Free or Dirt Cheap (2019)
4.9 (312 Reviews)
Provider: Udemy
Time: 3.5h
$11.99
Professional Advanced Angelic Healing Practitioner Course (2021)
4.9 (310 Reviews)
- Provider: Udemy
- Time: 3h
$11.99
Professional Accredited Earth Angel Course (2021)
4.9 (301 Reviews)
- Provider: Udemy
- Time: 2.5h
$11.99
Cours signe bb tout le vocabulaire autour du bb (2021)
4.9 (198 Reviews)
- Provider: Udemy
- Time: 1 hour on-demand videoh
$11.99
Reviews
- Video Duration:
4.5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
