Pular para o conteúdo principal
Página inicialData EngineeringIntroduction to Snowflake

Introduction to Snowflake

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

Comece O Curso Gratuitamente
3 Horas12 Videos43 Exercicios
11.479 AprendizesTrophyDeclaração de Realização

Crie sua conta gratuita

GoogleLinkedInFacebook

ou

Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.
GroupTreinar 2 ou mais pessoas?Experimente o DataCamp For Business

Amado por alunos de milhares de empresas


Descrição do Curso

Dive into Snowflake's universe! This course will take you from its foundational architecture to mastering advanced SQL techniques. In our data-driven era, data warehousing is crucial. Snowflake, a cloud-native platform, is redefining scalability and performance. You will dive deep into its significance and learn what differentiates it from competitors like Google BigQuery, Amazon Redshift, Databricks, and Postgres.

Snowflake Basics


You'll start by uncovering Snowflake's distinct architecture. Grasp fundamental database concepts, including DDL (Data Definition Language) and DML (Data Manipulation Language). Dive deeper into the importance of data types, their conversions, and the specifics of Snowflake's functionality.

Advanced Techniques


Once you have the basics, it's time to elevate your skills. You'll delve into joins, subqueries, and query optimization. Play with semi-structured data, focusing on `JSON`.

Seal Your Snowflake Expertise


By the end of this course, you'll have a strong Snowflake understanding, ready to handle data and conduct deep SQL analyses. Whether you're an analyst, data engineer, or a curious tech enthusiast, this course offers a comprehensive view of Snowflake's capabilities, preparing you for the ever-evolving data-driven landscape.
Para Empresas

GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados
Experimente O DataCamp for BusinessPara uma solução sob medida , agende uma demonstração.

Nas seguintes faixas

Engenheiro de dados associado em SQL

Ir para a trilha
  1. 1

    Introduction to Snowflake: Architecture, Competitors, and SnowflakeSQL

    Grátis

    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.

    Reproduzir Capítulo Agora
    What is Snowflake?
    50 xp
    Traditional vs. cloud data warehouse
    100 xp
    Row versus column oriented database
    100 xp
    Snowflake use cases
    50 xp
    Introduction to Snowflake SQL
    100 xp
    Snowflake Architecture
    50 xp
    Decoupling Compute & Storage
    50 xp
    Snowflake Architecture Layers
    100 xp
    Virtual Warehouse
    50 xp
    Snowflake Competitors and why use Snowflake
    50 xp
    Data warehousing platforms
    50 xp
    Features: Snowflake & its competitors
    100 xp
    Snowflake SQL: Using SELECT and WHERE in Snowflake
    100 xp
  2. 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.

    Reproduzir Capítulo Agora
  3. 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.

    Reproduzir Capítulo Agora
Para Empresas

GroupTreinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

Nas seguintes faixas

Engenheiro de dados associado em SQL

Ir para a trilha

Colaboradores

Collaborator's avatar
George Boorman
Collaborator's avatar
Arne Warnke
Collaborator's avatar
Anastasia Dvoryanchikova

Pre Requisitos

Joining Data in SQL
Palak Raina HeadshotPalak Raina

Senior Data Engineer at BUX

Veja Mais

O que os outros alunos têm a dizer?

Junte-se a mais de 14 milhões de alunos e comece Introduction to Snowflake hoje mesmo!

Crie sua conta gratuita

GoogleLinkedInFacebook

ou

Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.