Introduction to Snowflake
This course will take you from Snowflake's foundational architecture to mastering advanced SnowSQL techniques.
Comece O Curso Gratuitamente3 horas12 vídeos43 exercícios
Crie sua conta gratuita
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.Treinar 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.
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.
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`.
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.
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
Treinar 2 ou mais pessoas?
Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizadosNas seguintes faixas
Engenheiro de dados associado em SQL
Ir para a trilha- 1
Introduction to Snowflake: Architecture, Competitors, and SnowflakeSQL
GratuitoIn 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.
What is Snowflake?50 xpTraditional vs. cloud data warehouse100 xpRow versus column oriented database100 xpSnowflake use cases50 xpIntroduction to Snowflake SQL100 xpSnowflake Architecture50 xpDecoupling Compute & Storage50 xpSnowflake Architecture Layers100 xpVirtual Warehouse50 xpSnowflake Competitors and why use Snowflake50 xpData warehousing platforms50 xpFeatures: Snowflake & its competitors100 xpSnowflake SQL: Using SELECT and WHERE in Snowflake100 xp - 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.
Connecting to Snowflake and DDL commands50 xpSnowflake connections and DDL commands100 xpSnowflake Staging50 xpSnowflake database structures and DML50 xpLoading data50 xpDESCRIBE & SHOW100 xpSnowflake data type and data type conversion50 xpData types100 xpDatatype conversion100 xpFunctions, sorting, and grouping50 xpString functions100 xpFunctions & Grouping100 xpDATE & TIME100 xp - 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.
Joining in Snowflake50 xpNATURAL JOIN100 xpThe world of JOINS100 xpLATERAL JOIN100 xpSubquerying and Common Table Expressions50 xpSubqueries100 xpUnderstanding CTE100 xpCTEs100 xpSnowflake Query Optimization50 xpEssentials of query optimization100 xpEarly filtering100 xpQuery history50 xpHandling semi-structured data50 xpPARSE_JSON & OBJECT_CONSTRUCT100 xpQuerying JSON data100 xpJSONified100 xpWrap-up50 xp
Para Empresas
Treinar 2 ou mais pessoas?
Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizadosNas seguintes faixas
Engenheiro de dados associado em SQL
Ir para a trilhacolaboradores
pré-requisitos
Joining Data in SQLPalak Raina
Ver Mais
Senior Data Engineer at BUX
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
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.