Snowflake Database - Querying Data Part 1

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
Requirements
Some basic understand of Snowflake and SQL would be very helpful
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.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Creating a demo account
Section 2: Web UI and Worksheets
Lecture 3 Worksheets Part 1
Lecture 4 Worksheets Part 2
Lecture 5 Snowsight Prelude
Lecture 6 Snowsight Part 1
Lecture 7 Snowsight Part 2
Section 3: Miscellaneous Query Topics
Lecture 8 Data Types
Lecture 9 Getting the DDL statement for any Object
Lecture 10 Information_Schema
Lecture 11 Account Usage Queries
Lecture 12 Connect By Clause
Lecture 13 Limit / Fetch / Top N / Offset
Lecture 14 Windowing Functions Part 1
Lecture 15 Windowing Functions Part 2
Lecture 16 Generating Data
Lecture 17 Row Pattern Recognition Queries
Section 4: Creating Queries
Lecture 18 Joins
Lecture 19 Subqueries
Lecture 20 Common Table Expressions
Lecture 21 Working with Dates and Times
Lecture 22 Time Travel Queries
Lecture 23 Pivot Queries
Lecture 24 Regular Expression Queries
Lecture 25 Frequently used Queries
Section 5: Query Performance Monitoring
Lecture 26 Query Performance Monitoring in Snowflake
Lecture 27 The Snowflake Explain Statement
Section 6: Querying Semi-Structured Data
Lecture 28 Overview
Lecture 29 External Stages and Tables
Lecture 30 Other Types of Stages
Lecture 31 Stages Wrap up
Lecture 32 Lesser Known File Formats
Lecture 33 Querying Parquet Files
Lecture 34 Querying JSON Files Prelude
Lecture 35 Querying JSON Files
Section 7: Time for a Little Practice
Lecture 36 Practice #1
Any Snowflake developer or administrator who wants a deeper understand of the types of queries that can be generated in Snowflake

Homepage

https://www.udemy.com/course/snowflake-database-querying-data-part-1/

Snowflake Database - Querying Data Part 1 Fast Download
Snowflake Database - Querying Data Part 1 Full Download