Snowflake Database - Querying Data Part 1

Focused View

Randy Minder

5:10:21

9 View

1 - Introduction

1 - Introduction.mp4

02:20

2 - Creating a demo account.mp4

01:14

2 - Web UI and Worksheets

3 - Worksheets Part 1.mp4

06:29

4 - Worksheets Part 2.mp4

14:12

5 - Snowsight Prelude.mp4

01:56

6 - Snowsight Part 1.mp4

14:28

7 - Snowsight Part 2.mp4

15:29

3 - Miscellaneous Query Topics

8 - Data Types.mp4

07:49

9 - Getting the DDL statement for any Object.mp4

03:44

9 - getddl.zip

10 - InformationSchema.mp4

09:30

10 - informationschema.zip

11 - Account Usage Queries.mp4

13:56

11 - accesshistory.zip

11 - accountusage.zip

12 - Connect By Clause.mp4

05:17

12 - connectby.zip

13 - Limit Fetch Top N Offset.mp4

05:42

13 - limit.zip

14 - Windowing Functions Part 1.mp4

14:07

15 - Windowing Functions Part 2.mp4

12:06

15 - windowfunctionspart2.zip

16 - Generating Data.mp4

07:23

16 - generatingdata.zip

17 - Row Pattern Recognition Queries.mp4

10:23

17 - matchrecognize.zip

4 - Creating Queries

18 - Joins.mp4

07:19

18 - queries.zip

19 - Subqueries.mp4

05:32

19 - queries.zip

20 - Common Table Expressions.mp4

06:44

20 - cte.zip

21 - Working with Dates and Times.mp4

10:54

21 - dates.zip

22 - Time Travel Queries.mp4

11:36

22 - timetravel.zip

23 - Pivot Queries.mp4

06:55

23 - pivoting.zip

24 - Regular Expression Queries.mp4

05:24

24 - regularexpressions.zip

25 - Frequently used Queries.mp4

06:11

25 - commonqueries.zip

5 - Query Performance Monitoring

26 - Query Performance Monitoring in Snowflake.mp4

16:29

27 - The Snowflake Explain Statement.mp4

11:01

27 - explainstatement.zip

6 - Querying SemiStructured Data

28 - Overview.mp4

11:55

29 - External Stages and Tables.mp4

04:40

30 - Other Types of Stages.mp4

02:46

31 - Stages Wrap up.mp4

04:22

32 - Lesser Known File Formats.mp4

08:08

33 - Querying Parquet Files.mp4

10:22

34 - Querying JSON Files Prelude.mp4

01:58

35 - Querying JSON Files.mp4

18:18

35 - carsalesjson.zip

7 - Time for a Little Practice

36 - Practice 1.mp4

13:42

36 - dataloads.zip

36 - practice.zip

Description

The Complete Guide to Querying Data with Snowflake

What You'll Learn?

Snowflake Semi-Structured Data (JSON and Parquet Files) Queries
Snowflake Windowing Queries
Snowflake Data Generation Queries
Snowflake Snowsight (Snowflakes Next Generation Worksheet Replacement)
Snowflake Information Schema and Account Usage Queries
Snowflake Common Table Expression and Connect By Queries
Snowflake Pivot and Unpivot Queries
Snowflake Query Performance Monitoring

Who is this for?

Any Snowflake developer or administrator who wants a deeper understand of the types of queries that can be generated in Snowflake

What You Need to Know?

Some basic understand of Snowflake and SQL would be very helpful

More details

Description
SQL is the most used query language in the world and Snowflake is quickly becoming the most used cloud data platform in the world. There are, of course, other query languages for different types of databases, such as NoSQL databases but SQL remain the standard and Snowflake's SQL implementation is full ANSIÂ SQL compliant.
Snowflake's cloud data platform features a data warehouse / data lake architecture that supports the most common standardized version of SQL (ANSI) for extremely powerful relational database querying.
Snowflake can also be used as a data lake replacement, or supplement, because it can also aggregate semi-structured data such as JSON and Parquet, with structured data in a SQL format. Snowflake simplifies access to JSON data and allows users to combine it with structured data.
In this course we cover many query techniques such as Windowing functions, Common Table Expressions (CTEs) and Connect By, generating data, time travel queries, working with dates and times, pivot and unpivot queries, regular expression queries and many other types of queries.
We demonstrate how to perform query performance monitoring. We also spend a significant amount of time demonstrating how Snowflake can be used to query semi-structured data such as JSON and Parquet files.
When you finish part 1 of this course you will have a solid foundation for performing numerous types of Snowflake queries.
Who this course is for:
Any Snowflake developer or administrator who wants a deeper understand of the types of queries that can be generated in Snowflake

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Randy Minder

Instructor's Courses

Microsoft Certified Professional:Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019 - 80% score)Snowflake Core Certification Exam (April 2021 - 90% score)Seasoned database engineer (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence. Power BI, Snowflake and KQL. 20 years of software development using a variety of Microsoft technologies, mostly C#. 2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure.StackOverflow reputation of 45,000 (top 1%)

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.