×

Querying Data with Snowflake

Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare+
Duration

1h 56m

level

Beginner

Course Creator

Mohit Batra

Last Updated

15-Feb-23

In this course, you’ll learn how to query data in Snowflake using various query constructs and built-in functions – like Scalar, Aggregate, Analytic, Window, Table & Semi-structured functions – to clean up, transform, and analyze data.

Add your review

Snowflake is one of the most popular cloud data platforms. It allows data storage, data processing, and analytics at a massive scale, with extremely less administrative effort. And one of the key areas is to effectively query the data. In this course, Querying Data with Snowflake, you’ll learn how to use various query constructs and built-in functions in Snowflake, to clean up, transform, and analyze data. First, you’ll learn about different querying options in Snowflake and how to explore data using SnowSQL and Snowsight. Then, you’ll discover how to perform common SQL operations – like using Scalar functions, working with subqueries and CTEs, using joins and set operations, building dynamic queries, and using table functions. Next, you’ll see how to work with various aggregate and analytic functions, including windows, rank-related, and window frame functions and working with various group by extensions. Finally, you’ll see the data protection lifecycle, and how to protect the data using time travel and some quick tips to improve query performance. By the end of this course, you’ll have the knowledge and skills, to Query Data with Snowflake, by using various query constructs and built-in functions.
Author Name: Mohit Batra
Author Description:
Mohit is a Data Engineer, a Microsoft Certified Trainer (MCT) and a consultant. Mohit has 15+ years of extensive experience in architecting large scale Business Intelligence, Data Warehousing and Big Data solutions with companies like Microsoft and some leading investment banks. As an expert in his field, Mohit has often shared his knowledge in Azure, Spark, SQL Server and Power BI at various public forums and as a corporate trainer. Mohit truly loves to teach and enjoys producing high-quality,… more

User Reviews

0.0 out of 5
0
0
0
0
0
Write a review

There are no reviews yet.

Be the first to review “Querying Data with Snowflake”

Your email address will not be published. Required fields are marked *

Querying Data with Snowflake
Querying Data with Snowflake
Edcroma
Logo
Compare items
  • Total (0)
Compare
0
https://login.stikeselisabethmedan.ac.id/produtcs/
https://hakim.pa-bangil.go.id/
https://lowongan.mpi-indonesia.co.id/toto-slot/
https://cctv.sikkakab.go.id/
https://hakim.pa-bangil.go.id/products/
https://penerimaan.uinbanten.ac.id/
https://ssip.undar.ac.id/
https://putusan.pta-jakarta.go.id/
https://tekno88s.com/
https://majalah4dl.com/
https://nana16.shop/
https://thamuz12.shop/
https://dprd.sumbatimurkab.go.id/slot777/
https://dprd.sumbatimurkab.go.id/
https://cctv.sikkakab.go.id/slot-777/
https://hakim.pa-kuningan.go.id/
https://hakim.pa-kuningan.go.id/slot-gacor/
https://thamuz11.shop/
https://thamuz15.shop/
https://thamuz14.shop/
https://ppdb.smtimakassar.sch.id/
https://ppdb.smtimakassar.sch.id/slot-gacor/
slot777
slot dana
majalah4d
slot thailand
slot dana
rtp slot
toto slot
slot toto
toto4d
slot gacor
slot toto
toto slot
toto4d
slot gacor
tekno88
https://lowongan.mpi-indonesia.co.id/
https://thamuz13.shop/
https://www.alpha13.shop/
https://perpustakaan.smkpgri1mejayan.sch.id/
https://perpustakaan.smkpgri1mejayan.sch.id/toto-slot/
https://nana44.shop/
https://sadps.pa-negara.go.id/
https://sadps.pa-negara.go.id/slot-777/
https://peng.pn-baturaja.go.id/
https://portalkan.undar.ac.id/
https://portalkan.undar.ac.id/toto-slot/
https://penerimaan.ieu.ac.id/
https://sid.stikesbcm.ac.id/