Advanced Snowflake

Focused View

Janani Ravi

2:09:00

181 View

01 - Introduction

01 - Advanced Snowflake.mp4

04:03

02 - Snowflake architecture.mp4

05:13

03 - Getting set up with Snowflake.mp4

02:15

02 - 1. Table Structures in Snowflake

01 - Micropartitioning and clustering.mp4

04:50

02 - Types of tables in Snowflake.mp4

04:45

03 - Creating permanent tables.mp4

04:16

04 - Creating temporary tables.mp4

05:08

05 - Creating transient tables.mp4

04:45

06 - Configuring data retention time.mp4

02:31

07 - Querying historical data.mp4

03:43

08 - Dropping and restoring tables.mp4

02:03

03 - 2. Views in Snowflake

01 - Non-materialized, materialized, and secure views.mp4

03:47

02 - Creating and populating tables.mp4

03:11

03 - Creating and querying views.mp4

03:17

04 - Recreating views.mp4

01:54

05 - Querying regular views and secure views.mp4

04:32

06 - Creating and querying materialized views.mp4

04:29

04 - 3. Optimizing Query Performance

01 - Caching, clustering, and search optimization.mp4

05:06

02 - Loading data using COPY INTO.mp4

04:13

03 - Retrieval optimization using cached results.mp4

03:54

04 - Enabling clustering on tables.mp4

04:33

05 - Querying clustered tables.mp4

03:59

06 - Querying clustering information.mp4

02:45

07 - Running point lookup queries on search-optimized tables.mp4

05:27

08 - Clustering vs. search optimization.mp4

05:55

05 - 4. Working with Semi-structured Data

01 - Loading and querying parquet data.mp4

05:19

02 - Loading JSON data.mp4

03:22

03 - Querying JSON data.mp4

04:09

06 - 5. Managing Users and Granting Privileges

01 - Access control.mp4

04:18

02 - Creating users and viewing grants.mp4

04:53

03 - Granting privileges to roles.mp4

04:48

07 - Conclusion

01 - Summary and next steps.mp4

01:37

Description

If you’re familiar with the Snowflake platform but need to learn more, this course can help you supercharge your skills. Instructor Janani Ravi deep dives into architecture and advanced concepts. After a concise introduction, Janani gets started with table structures in Snowflake, covering topics like micropartitioning, clustering, and creating permanent, temporary, and transient tables. She explains views in Snowflake, then demonstrates several useful techniques for optimizing query performance. Janani goes over working with semi-structured data, including loading and querying parquet data and JSON data. Plus, she shows you how to articulate the access control system in Snowflake, create users, view grants, and grant privileges to roles.

Note: This course was created by Janani Ravi. We are pleased to host this training in our library.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Network Engineering

Janani Ravi

Instructor's Courses

Janani Ravi is a certified Google cloud architect and data engineer. Janani earned an MS degree in electrical engineering from Stanford and has worked for Microsoft, Google, and Flipkart. She is the co-founder of Loonycorn, a content studio focused on providing high-quality content for technical skill development, where she combines her love for technology with her passion for teaching.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.