Registration is closed

SNOWFLAKE ASCENT: SINGAPORE

Data Engineering Edition

2 July
9:00AM – 4:30PM SGT
WeWork Collyer Quay
July 1

Registration is closed as we have reach max capacity.

We would love to have you at our upcoming User Group in Singapore.

Register here

It starts with you. Essential hands-on to continue your data journey.

WHAT TO EXPECT
Snowflake Ascent Singapore is a step-by-step live and free, Data Cloud certification primer delivered by Snowflake’s technical instructors.

This full-day workshop imparts foundational knowledge of Snowflake’s data engineering capabilities. Participants involved in analytics tasks, development, and data pipeline creation will gain a deeper understanding through lectures, demonstrations, hands-on labs, and interactive discussions.

Attendees will receive a virtual Snowflake badge that verifies that you have completed the course. This virtual badge is sharable on social media and other virtual platforms. You will also receive an exclusive offer on Snowflake Training and Certification.

ACQUIRED SKILLS

  • Understand Snowflake’s architecture and the role of each component
  • Recognize the data engineering lifecycle and Snowflake’s supporting features
  • Efficiently manage semi-structured data within Snowflake
  • Identify and automate the steps involved in a data pipeline

COURSE PREREQUISITES
Participants should have a fundamental understanding of SQL.

WHO SHOULD ATTEND
Data Analysts, Data Engineers, Data Scientists, Database Architects, Database Administrators, Data Application Developers

DELIVERY FORMAT
The workshop is delivered onsite by Snowflake Training and Certification team


Cost to Attend: Free

AGENDA

START TIME SESSION DETAILS
8:00 – 9:00
Registration and Breakfast
9:00 – 9:05
Introduction and Kickoff
9:05 – 9:45
Module 1: Getting Started and Snowflake Overview

This section will outline the Snowflake platform, starting with Intro to Data Cloud: an end-to-end on walkthrough on the Snowflake architecture including core workloads – data warehousing, data lakes, data engineering, data science, data applications and data sharing. You will learn how to set-up a trial account, how to navigate between the classic UI and the new Snowsight UI, and what is an Account URL.

9:45 – 10:30
Module 2: Project Kick-Off and Database Setup

We will walk through the Snowflake hierarchy, roles, database setup and data loading. You will be introduced to the various stages, and learn how to load data into Snowflake.

10:30 – 10:50
Break
10:50 – 11:20
Module 3: Time Zones, Dates and Timestamps

Learn about the extensive support for various types of date formats and timezone formats availble on Snowflake. The section also outlines Snowflake’s support for schema detection and schema inference.

11:20 – 11:50
Module 4: Extracting, Transforming and Loading

Aligning with the data lifecycle, you will learn how to perform extract, transform and load (ETL) on the Snowflake Data Cloud. You will also learn about useful features in the Snowflake marketplace.

11:50 – 12:35
Module 5: Productionizing our Work

You will be introduced to tasks and various DML operations that be used to transform data reliably.

12:35 – 13:35
Lunch
13:35 – 14:10
Module 6: Productionizing across the Pipeline

Get hands-on with features like task history, auditing task history via dashboards, resource monitors and Snowflake alerts.

14:10 – 14:40
Module 7: DE Practice Improvement and Cloud Foundations

A game-changer feature will be introduced to you: Dynamic Tables can reliablly let you keep data up-to-date without writing complex pipelines.

14:40 – 15:10
Module 8: Your Snowpipe!

Learn how you can change data capture and related user cases in this section where we take you through 2 features: Snowpipe and Streams.

15:10 – 15:30
Break
15:30 – 16:00
Module 9: Curated Data

We will fit in the last piece of the data engineering lifecycle “Consumption”, and walk you through features such as charts and dashboards for visualisation.

16:00 – 16:30
Journey to Snowflake Certification & Close

You have completed your ascent! We’ll wrap up with a quick summary, take you through how you can obtain the training completion badge and share how you can get SnowPro Core Certification.

Technical Instructors

Ravi Gurbaxani

Manager, Delivery
Snowflake

Ravi Gurbaxani

Manager, Delivery
Snowflake

Hwee Yee, Lim

Technical Instructor
Snowflake

Hwee Yee, Lim

Technical Instructor
Snowflake

EVENT DETAILS

WHEN & WHERE

WeWork Collyer Quay
21 Collyer Quay, Singapore 049320
2 July 2024 | 8:00 AM - 4:30 PM SGT
Registration is closed