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

Codecademy

Advanced Snowflake

via Codecademy Path

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn Advanced Snowflake covering data transformation, performance optimization, Snowpark implementation, machine learning techniques and data governance strategies.

Syllabus

  • Track 1: Performance Monitoring and Optimization
    • <p>This track equips learners with the tools and techniques needed to optimize <span>Snowflake</span> performance for large-scale data engineering tasks. You will explore the strategies for scaling workloads with virtual and multi-cluster warehouses, query optimization through data clustering and caching, and monitoring performance with query profiling and resource utilization tracking. Learners will also explore handling geospatial and semi-structured data, working with transient and dynamic tables, and optimizing queries through secure and materialized views.</p>
  • Track 2: Data Transformation Using Snowpark
    • <p>In this in-depth track, learners dive into Snowpark, <span>Snowflake</span>’s powerful framework for scalable data manipulation and transformation. Through hands-on experience with Snowpark DataFrames and integration with external systems like Kafka and Spark, learners will master tasks such as filtering, aggregating, and joining data. The track also covers the creation and management of user-defined functions (UDFs) and stored procedures, as well as data quality assurance using Soda and real-time data ingestion techniques.</p>
  • Track 3: Continuous Data Pipelines
    • <p>This track introduces learners about continuous data pipelines in Snowflake. Participants will learn how to create and configure dynamic tables and the usage and internal workings of streams for change data capture (CDC), stream types, and standard stream contents during insert, update, and delete operations. The final section of this track will be exploring continuous data processing tasks, creating and execute scheduled serverless and user-managed scheduled tasks, and implementing task graphs and child tasks.</p>
  • Track 4: Advanced Analytics and Machine Learning
    • <p>This track introduces learners to the world of machine learning within <span>Snowflake</span>. Participants will learn to design and deploy ML models using Snowpark and popular tools like scikit-learn. The track covers key areas such as data preprocessing, model training, hyperparameter tuning, and deployment through MLOps. Learners will also explore the application of large language models (LLMs) in <span>Snowflake</span> Cortex for tasks like sentiment analysis, translation, and summarization, as well as <span>advanced</span> techniques like time series forecasting and anomaly detection.</p>

Reviews

Start your review of Advanced Snowflake

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.