1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Snowflake SQL
  • 1

    Snowflake SQL and key concepts

    Free

    In this chapter, you're diving into Snowflake SQL. You'll start by discovering various methods to connect and interface with Snowflake. As you delve deeper, you'll grasp the significance of Snowflake Staging. Navigate the vast landscapes of Snowflake's databases using essential commands and broaden your understanding of its data types, learning to convert them, and drawing comparisons with Postgres. Finally, we'll get into functions, sorting, and grouping.

  • 2

    Advanced Snowflake SQL Concepts

    Time to advance your skills in Snowflake SQL. You'll begin by exploring diverse join methods and building complex queries with subqueries and CTEs. We'll emphasize query optimization, showing you ways to enhance the speed and efficiency of your SQL tasks. At the end, we'll delve into handling semi-structured data like JSON.

Initializing

Exercise

JSONified

Semi-structured data can be challenging to query, so let's practice interacting with Yelpto's data once again.

Here, you will filter the contents of a VARIANT column.

Instructions

100 XP
  • Filter where the DogsAllowed key in the attributes column is 'True' (note this is a string, not boolean).
  • Filter where the BusinessAcceptsCreditCards key in the attributes column is 'True' (note this is a string, not boolean).