Snowflake Data Engineer II Training

Live Online & Classroom Enterprise Training

Snowflake Data Engineer II focuses on advanced data engineering practices, including complex pipeline design, performance optimization, and enterprise data integration on Snowflake. It equips engineers to manage large-scale workloads, ensure data reliability, and implement production-ready architectures on the Snowflake Data Cloud.

COURSE BROCHURE DOWNLOAD PDF

Looking for a private batch ?

REQUEST A CALLBACK

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Snowflake Data Engineer II Training about?

This two‐day, role‐specific course presents additional topics and a deep dive into select subjects for the Data Engineer through the lens of the data engineering lifecycle. The course covers Snowflake concepts, features, considerations, and best practices intended for stakeholders who will be accessing, developing, and querying datasets for analytic tasks, and building data pipelines in Snowflake. This course consists of data engineering concepts delivered through lectures, demos, labs, and discussions.

What are the objectives of Snowflake Data Engineer II Training ?

Develop applications for Snowflake, including comprehensive ANSI standard SQL support.
IdentifyanddescribevariousdatamodelingtechniquesandarchitecturesdeployedontheSnowflake Platform.
Govern data stored and accessed in Snowflake effectively.
ExploitSnowflakecapabilitiestoworkeffectivelywithstructured,semi‐structured,andunstructured data in Snowflake.
UseSnowflake’s SQL extensibility features, such as user‐defined functions and stored procedures.
Employ the Snowpark client libraries to query and transform data in a data pipeline and build appli cations that process data in Snowflake without moving data to the system running the application.
Automate data ingestion and expand data lake capabilities using Snowflake.

Who is Snowflake Data Engineer II Training for?

Data Analysts
Data Engineers
Data Scientists
Database Architects
Database Administrators
Data Application Developers

What are the prerequisites for Snowflake Data Engineer II Training?

Recommended completion of the “Snowflake Multi‐Factor Authentication (MFA) Essentials” free on‐demand course.
Completion of either “Snowflake Fundamentals” or “Snowflake Data Engineer” course is recommended.

Available Training Modes

Live Online Training

2 Days

Classroom Training

2 Days

Course Outline Expand All

Expand All

Snowflake Overview and Architecture Recap

Data Engineering Workflow Recap

Data Storage

Table Formats and Apache Iceberg™ Tables

Apache Iceberg™ Tables in Snowflake

Hybrid Tables in Snowflake

Define and Implement Hybrid Tables

Cost Analysis and Limitations

Ingestion

Schema Detection

Schema Evolution

Visualizing Data Ingestion

Transformation

Developing for Snowflake Overview

User Defined Functions (Java and Python)

User Defined Table Functions (Java and Python)

Snowpark Stored Procedures (Java, Scala, and Python)

Working With Snowpark

Data Platform Architecture

Data Modelling

Data Vault Introduction

Supporting Platform Features

Data Governance Overview

Classification and Object Tagging

Object Dependencies

Access History

Snowflake Policies

Tag‐based Masking Policies

External Tokenization

Performance Optimization

Search Optimization Service

Query Acceleration Service

Delivery

Snowflake Python API

Snowflake SQLAPI

Stream lit in Snowflake

Orchestration

Scheduling Workflows With Airflow

Snowflake Python Task API

Management and Observability

Observability on Snowflake

No‐code Pipeline Observability Within Snow sight

Cost Governance Framework

Logging and Tracing

DOWNLOAD COURSE BROCHURE

Who is the instructor for this training?

The trainer for this Snowflake Data Engineer II Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree