Facebook

Snowflake Data Engineer Training

* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us:  sales@ccslearningacademy.com.

Student financing options are available.

Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.

Looking for group training? Contact Us

psinghal
Last Update December 12, 2023
0 already enrolled

About This Course

Course Description

This 3-day role-specific course covers the Snowflake key concepts, features, considerations, and best practices intended for key stakeholders who will be accessing, developing, and querying datasets for analytic tasks and building data pipelines in Snowflake. These stakeholders often are in the role of database application developers and data engineers. This course will consist of lectures, demos, labs, and discussions.

Learning Objectives

Overview of Snowflake key features and architecture
Performance and cost optimization techniques using caching and high performing functions
Learn different UI and application methods of accessing Snowflake
Use the capabilities and best practices for working with semi-structured data in Snowflake Load, unload data sets and best practices
Tune queries and performance using advanced techniques such as data clustering and materialized views
Develop application for Snowflake including using comprehensive ANSI standard SQL support
Leveraging Snowflake SQL extensibility features such as time travel capabilities, user-defined functions and stored procedures

Inclusions

  • Instructor-led training
  • Training Seminar Student Handbook
  • Collaboration with classmates (not currently available for self-paced course)
  • Real-world learning activities and scenarios
  • Exam scheduling support*
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*

Pre-requisites

  • Basic knowledge of SQL and Python is helpful.

Target Audience

  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators

Curriculum

52 Lessons24h

1. Snowflake Architecture and Overview

• Snowflake technical overview
• Review three-tiered architecture
• Cloud services
• Virtual warehouse
• Storage

2. Interfaces and Connectivity

3. Developing for Snowflake

4. Loading New Data Sets

5. Data Pipelines

6. Data Lakes

7. Pipeline Transformations and Querying Data

8. Query Caching Performance Features

9. Performance monitoring and management of query and ETL workloads

10. Using Data Clustering Optimization for Advanced Query Performance Tuning

11. Test, QA, and Production and Agile Development

12. Working with Semi-Structured Data

13. Snowflake Data Cloud

Your Instructors

psinghal

0/5
472 Courses
0 Reviews
0 Students
See more

Write a review

IMG1696503282.jpg

$3,000.00

Level
Intermediate
Duration 24 hours
Lectures
52 lectures
Print Friendly, PDF & Email

Inclusions

  • Instructor-led training
  • Training Seminar Student Handbook
  • Collaboration with classmates (not currently available for self-paced course)
  • Real-world learning activities and scenarios
  • Exam scheduling support*
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*
#edumall-wp-widget-courses-1 { display: none; } #single-course-ratings { display: none; } .tutor-single-course-lead-meta { display: none; } .lead-meta-item meta-course-total-enrolled { display: none; }