From the course: Everybody's Introduction to Snowflake
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Querying your data - Snowflake Tutorial
From the course: Everybody's Introduction to Snowflake
Querying your data
- At the beginning of the course, we talked about querying your data. Structured query language, or SQL, is at the heart of the ability to do that. It's a standardized programming language that's specifically designed for managing, manipulating, and retrieving data stored in databases. SQL's foundation consists of key syntax elements, namely SELECT, FROM, WHERE, GROUP BY, and ORDER BY. In a nutshell, these commands are allowed to specify what data we want and where it comes from, how to filter it using the WHERE clause, how to group it with the GROUP BY clause, and finally, how to sort the data with ORDER BY. Combining these into a single query allows us to answer specific questions, and you can start to see why SQL is the basis not just for analysts to interact with databases but also tools that use databases as a source. Yet, databases, when used well, don't typically store data in silos. More often than not, we need to…
Contents
-
-
-
-
(Locked)
Ensuring security on the Snowflake platform3m 49s
-
(Locked)
Implementing data governance on the Snowflake platform3m 28s
-
(Locked)
Querying your data3m 23s
-
(Locked)
Data management in Snowflake5m 59s
-
(Locked)
Visualizing your data with Snowsight5m 46s
-
(Locked)
Understanding workloads in Snowflake6m 7s
-
(Locked)
The power of data sharing4m 28s
-
(Locked)
The Snowflake pricing model6m 55s
-
(Locked)
-
-