Snowflake Fundamentals 4-Day
* 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
About This Course
Course Description
This 4-day course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform. The course will consist of lectures, demos, and labs on a wide range of foundational topics.
Learning Objectives
Illustrate the unique and differentiated architecture of the Snowflake Cloud Data Platform
Load and transform data
Evaluate Query Constructs and DDL & DML Operations
Review Snowflakes broad SQL support for data analysis
Describe how user and application access can be easily managed
Demonstrate best practices for working with semi-structured data
Discuss how Snowflake provides a unique approach to caching Examine the various ways to connect and interact with the Snowflake Platform
Employ Snowflake’s method for continuous data protection
Utilize Data Sharing to send your data in real-time to Customers and Partners
Scale your Virtual Warehouse for performance and concurrency
Explain the different ways you can manage and monitor your Snowflake account
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
- Previous Data Warehouse knowledge is assumed.
Target Audience
- Data Analysts
- Data Engineers
- Data Scientists
- Database Architects
- Database Administrators
Curriculum
61 Lessons32h
Week 1
Snowflake Architecture and Overview
– Snowflake Technical Overview
– Cloud Services Layer
– Storage Layer
– Compute Layer
Snowflake Clients & Ecosystem
– Snowflake Clients and Connectors Overview
– SnowSQL – Snowflake CLI
Caching
– Caching Features in Snowflake
– Best Practices of using caching for performance and cost optimization
Week 2
Week 3
Week 4
Your Instructors
Write a review
$3,000.00
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.*
