Introduction to Snowflake
This course will take you from Snowflake's foundational architecture to mastering advanced SnowSQL techniques.
Commencer Le Cours Gratuitement3 heures12 vidéos42 exercices20 842 apprenantsDéclaration de réalisation
Créez votre compte gratuit
ou
En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.Formation de 2 personnes ou plus ?
Essayer DataCamp for BusinessApprécié par les apprenants de milliers d'entreprises
Description du cours
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.
Formation de 2 personnes ou plus ?
Donnez à votre équipe l’accès à la plateforme DataCamp complète, y compris toutes les fonctionnalités.Dans les titres suivants
Ingénieur de données associé en SQL
Aller à la piste- 1
Introduction to Snowflake: Architecture, Competitors, and SnowflakeSQL
GratuitIn 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 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
Formation de 2 personnes ou plus ?
Donnez à votre équipe l’accès à la plateforme DataCamp complète, y compris toutes les fonctionnalités.Dans les titres suivants
Ingénieur de données associé en SQL
Aller à la pistecollaborateurs
prérequis
Joining Data in SQL
Qu’est-ce que les autres apprenants ont à dire ?
Inscrivez-vous 15 millions d’apprenants et commencer Introduction to Snowflake Aujourd’hui!
Créez votre compte gratuit
ou
En continuant, vous acceptez nos Conditions d'utilisation, notre Politique de confidentialité et le fait que vos données sont stockées aux États-Unis.