100 Most Popular Courses For September

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Introduction to Snowflake

via DataCamp

Go to class Write review

Overview

This course will take you from Snowflake's foundational architecture to mastering advanced SnowSQL techniques.


Dive into Snowflake's universe! This course will take you from its foundational architecture to mastering advanced SQL techniques. You'll start by uncovering Snowflake's distinct architecture and grasping fundamental database concepts, including DDL (Data Definition Language) and DML (Data Manipulation Language).

Syllabus

  • Introduction to Snowflake: Architecture, Competitors, and SnowflakeSQL
    • 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.
  • 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.
  • 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.

Taught by

Palak Raina

Reviews

4.1 rating at DataCamp based on 29 ratings

Start your review of Introduction to Snowflake

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.