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

    Introduction to Snowflake: Architecture, Competitors, and SnowflakeSQL

    Free

    In this chapter, you will learn about Snowflake, a cloud-based data warehouse that offers a unique architecture. We will discuss its key features, use cases, architecture, and how it compares to its competitors. You will also get started with SnowflakeSQL, exploring its basic syntax and similarities with PostgreSQL.

  • 2

    Snowflake SQL and key concepts

    In this chapter, you'll embark on a journey through 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. Conclude your exploration by mastering Snowflake's functions and honing data sorting and grouping techniques.

  • 3

    Advance Snowflake SQL Concepts

    In Chapter 3, you'll 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

NATURAL JOIN

Pissa, the ever-expanding pizza delivery enterprise, has a new challenge for you. They're interested in discovering which type of pizza generates the most revenue.

Identify the top-selling pizza category using your knowledge on NATURAL JOIN.

Here is the pizza schema for your reference:

Schema Diagram

Instructions

100 XP
  • Calculate total_revenue based on SUM of price * quantity; taking price from p (pizzas) and quantity from od (order_details) table.
  • NATURAL JOIN the pizzas and pizza_type tables.
  • GROUP the records by category from pt (pizza_type) table.
  • ORDER the details by total_revenue in descending order and LIMIT to 1 to fetch only the top revenue pizza.