Ultimate Snowflake Challenges - 2024 Hands On!

Focused View

Cristian Scutaru

1:39:25

12 View

1. Introduction

1. Quick Review of All Challenges.mp4

03:00

2.1 GitHub Repository for this Course.html

2.2 My Blog on Medium.html

2.3 Snowflake-Challenges-Slides.pdf

2. Best Ways to Benefit from this Course.mp4

02:47

2. Challenge #1 Multi-Table Insert

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #1 Question.mp4

01:00

2.1 INSERT (multi-table).html

2. Challenge #1 Answer.mp4

02:41

3. Challenge #1 Conclusion.mp4

01:31

3. Challenge #2 Multi-Pivot Query

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #2 Question.mp4

01:07

2. Challenge #2 Answer.mp4

05:17

3.1 About the Implicit Hidden GROUP BY Clause in a PIVOT Query.html

3.2 How to Properly Generate a Dynamic Pivot Query in Snowflake.html

3. Challenge #2 Conclusion.mp4

01:39

4. Challenge #3 Shared Hidden Secrets

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #3 Question.mp4

01:11

2. Challenge #3 Answer.mp4

05:00

3.1 [Snowflake Data Clean Rooms] Row Access Policies.html

3.2 [Snowflake Data Clean Rooms] Yaos Millionaires Problem in SQL.html

3.3 Under the Hood of Row Access Policies in Snowflake.html

3. Challenge #3 Conclusion.mp4

01:44

5. Challenge #4 Tabular Data Editor

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #4 Question.mp4

00:37

2.1 [Snowflake Quick Tips] How to start data modeling with DBeaver.html

2.2 st.data editor.html

2. Challenge #4 Answer.mp4

05:47

3. Challenge #4 Conclusion.mp4

01:37

6. Challenge #5 Dependency Graph

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #5 Question.mp4

00:26

2.1 How to Display Object Dependencies in Snowflake.html

2.2 How to Visualize the Data Lineage Graph in Snowflake.html

2. Challenge #5 Answer.mp4

03:47

3. Challenge #5 Conclusion.mp4

01:54

7. Challenge #6 History Finder

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #6 Question.mp4

00:57

2. Challenge #6 Answer.mp4

12:30

3.1 How to Use Time Travel in Snowflake the Right Way.html

3.2 Understanding & Using Time Travel.html

3. Challenge #6 Conclusion.mp4

00:46

8. Challenge #7 Hierarchical Queries

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #7 Question.mp4

00:43

2. Challenge #7 Answer.mp4

07:28

3.1 How to Easily Visualize Hierarchical Tabular Data.html

3.2 How to Query Hierarchical Data in Snowflake.html

3. Challenge #7 Conclusion.mp4

01:42

9. Challenge #8 Fake Data Generator

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #8 Question.mp4

01:52

2. Challenge #8 Answer.mp4

09:13

3.1 How to Generate Snowflake Stored Procs via Python Worksheets.html

3.2 Synthetic Data Generation at Scale Part 1.html

3. Challenge #8 Conclusion.mp4

01:19

10. Challenge #9 Running Tasks

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #9 Question.mp4

01:12

2. Challenge #9 Answer.mp4

07:47

3.1 12 Misconceptions about Virtual Warehouses in Snowflake.html

3.2 How to Make Your Own Snowflake Task Graph Viewer.html

3.3 Introduction to Tasks.html

3.4 Offset Window Functions in Snowflake the Easy Way.html

3. Challenge #9 Conclusion.mp4

02:33

11. Challenge #10 Generic Script

1.1 setup.sql - to execute content in a new SQL Worksheet.html

1. Challenge #10 Question.mp4

01:17

2. Challenge #10 Answer.mp4

06:44

3.1 Variable Substitution for Multi-Tenant Apps and Deployment Environments.html

3. Challenge #10 Conclusion.mp4

02:02

12. Conclusions

1. Test Your Knowledge.html

2. Congratulations, You Made It!.mp4

00:15

Description

Interesting Funny Puzzles to Learn More about Snowflake and SQL

What You'll Learn?

Hidden gems in Snowflake Data Cloud
Quick Snowflake challenges and recipes
Discover things about Snowflake in a funny and entertaining way
Challenge yourself and get to know Snowflake better

Who is this for?

Data Engineers with basic knowledge of Snowflake

Data Architects willing to know more about Snowflake

Any technical person willing to be challenged with small entertaining puzzles in SQL

What You Need to Know?

Basic knowledge of Snowflake

Basic knowledge of SQL and Python programming

Basic knowledge of relational databases and data warehouses

More details

Description
Who I Am
World-Class Expert in Snowflake.
Former Snowflake "Data Superhero".
Former SnowPro Certification SME (Subject Matter Expert): many exam questions have been created by me.
SnowPro Exams in Core, Architect, Data Engineer, and Data Analyst Certifications.
Seasoned Data Architect, Data Engineer, Machine Learning Engineer...
What You Will Learn More About
Find out about some obscure but very interesting things in Snowflake.
Solve tricky issues with Snowflake queries and hierarchical data.
Fix intermediate to advanced SQL queries.
Solve funny and challenging puzzles using Snowflake.
Learn more about the Snowflake ecosystem in a funny and engaging way.
See the questions and try to solve them on your own.
Watch my hands-on experiments and follow my hints.
Follow extra-curriculum recommended material.
Learn intermediate to advanced SQL and Python programming in Snowflake.
Learn something about Streamlit and how to use it in Snowflake.
Advanced tips and tricks.
What Snowflake Areas Will Be Considered
Time Travel
Auditing and Query History
Generating Synthetic but Realistic Data
Data Classification
Snowpark Stored Procedures from Python Code
Streamlit Apps
Data Clean Rooms
Row Access Policies
SQL Queries in Snowflake
Querying Metadata
User-Managed and Serverless Tasks
Details on Snowflake's Virtual Warehouses
Charts and Graphs
Recursive SQL Queries on Hierarchical Data
Semi-Structured Data
Cost Management and Cost Estimates
Multiple-Table Inserts
Extended Pivot Queries
Multi-Tenant Architectures
SnowSQL Variable Substitution
Object Dependencies
Python Worksheets
== Enroll today, you'll not regret it! ==
Who this course is for:
Data Engineers with basic knowledge of Snowflake
Data Architects willing to know more about Snowflake
Any technical person willing to be challenged with small entertaining puzzles in SQL

User Reviews

Rating

average 0

Total votes0

Focused display

Certified Solutions Architect in AWS/Azure/Google Cloud (20 total exams). Former Snowflake “Data Superhero” and SnowPro Certification SME. Certified in many NoSQL stores: Cassandra/Redis/Couchbase/Neo4j/TigerGraph...Decades of practical experience in software design and implementation. Former Microsoft employee. Architect of the Data Xtractor Suite - with a visual SQL editor, data visualization charts, data modeling... Former assistant professor at the "Polytechnica" University of Bucharest.I live in beautiful Vancouver/Canada.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.