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

DataCamp

Associate Data Engineer in Snowflake

via DataCamp

Go to class Write review

Overview

DataCamp Flash Sale:
50% Off - Build Data and AI Skills!
Grab it
Prepare for one of the most sought-after roles in tech with the Associate Data Engineer in Snowflake track. You'll build a strong foundation in SQL, data modeling, and database design while developing hands-on experience using Snowflake, one of the fastest-growing AI-powered cloud data platforms in the world. Get up to speed with Snowflake’s architecture, features, and performance benefits through interactive courses and tutorials. You'll practice core skills like ingesting, manipulating, and querying data in Snowflake using Snowflake SQL. This track gives you the skills to manage real-world data workflows, from joining and transforming data to modeling schemas. You'll see how to build scalable pipelines, and you'll apply what you learn in a practical project that simulates building insights for a sports media agency.

Syllabus

  • Introduction to SQL
    • Learn how to create and query relational databases using SQL in just two hours.
  • Intermediate SQL
    • Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!
  • Introduction to Snowflake
    • Snowflake is a top data warehousing platform. Learn how they use Snowsight, a user-friendly SQL interface for accessing and exploring data.
  • Snowflake Tutorial For Beginners: From Architecture to Running Databases
  • Joining Data in SQL
    • Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
  • Introduction to Snowflake SQL
    • This course will take you from Snowflake's foundational architecture to mastering advanced SnowSQL techniques.
  • Snowflake Data Ingestion: A Comprehensive Guide
  • Data Manipulation in Snowflake
    • Master data manipulation and analysis techniques such as CASE statements, subqueries, and CTEs in Snowflake.
  • Database Design
    • Learn to design databases in SQL to process, store, and organize data in a more efficient way.
  • Introduction to Data Modeling in Snowflake
    • Step right into the dynamic world of data modeling with Snowflake!
  • Data Types and Functions in Snowflake
    • Learn Snowflake data types and functions to manipulate text, numbers, and dates while building custom functions and pivot tables.
  • Window Functions in Snowflake
    • Discover Snowflake window functions to solve complex data problems with rankings, partitions, and rolling calculations.
  • Producing Soccer Insights for a Sports Media Agency
  • Building Data Pipelines in Snowflake: A Beginner-Friendly Guide

Taught by

Lis Sulmont, Izzy Weber, Jasmin Ludolf, Maham Khan, George Boorman, Margarita Torres, Danny Hong, and Jake Roach

Reviews

Start your review of Associate Data Engineer in 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.