Snowflake Fundamentals Training
This four-day course covers the core concepts, design considerations, and Snowflake best practices intended for key stakeholders who will be working on the Snowflake Data Cloud. The course consists of lectures, demos, and labs covering a wide range of essential topics.
In this course, you will:
- Outline the unique and dierentiated architecture of the Snowflake Data Cloud.
- Load and transform data.
- Summarize query constructs, DDL, and DML operations.
- Use Snowflake’s extensive SQL capabilities for data analysis.
- Describe how user and application access can be easily managed.
- Apply Snowflake best practices for working with semi-structured data.
- Discuss Snowflake’s unique approach to caching.
- Implement the options provided to connect and interact with the Snowflake Data Cloud.
- Employ Snowflake’s continuous data protection features.
- Utilize Data Sharing to send your data in real-time to Customers and Partners.
- Scale your Virtual Warehouses to improve performance and address concurrency needs.
- Explain the dierent ways you can manage and monitor your Snowflake account.
This course is intended for:
- Data Analysts
- Data Engineers
- Data Scientists
- Database Architects
- Database Administrators
We recommend that attendees of this course have:
- Previous Data Warehouse knowledge is assumed.
Module 1: Overview and Architecture
- Overview of Snowflake
- Snowflake Structure
- Using Snowsight
- Storage Layer
- Compute Layer
- Cloud Services Layer
- Snowgrid
Module 2: Connecting to Snowflake
- Connection Options
- SnowSQL
Module 3: Data Protection Features
- Cloning
- Time Travel
- Fail-safe
- Introduction to Replication
Module 4: SQL Support in Snowflake
- Tables, Views, and Data Types
- Transactions
- Standard SQL and Snowflake
- Estimation Functions
- Sampling
- Collation
- Multi-table Inserts
- Query Tags
- Working with Parameter
Module 5: Metadata and Caching in Snowflake
- Overview
- Metadata
Class Deliverables
- E-Content kit by AWS
- Hands-on labs
- Class completion certificates
- Exam Prep sessions
Class Schedule
Stay ahead with our comprehensive course schedule. Browse upcoming training sessions & reserve your spot to gain hands-on expertise & certification-ready skills.
| Virtual | 4 days | All Day | June 4, 2024 | ₹0 | |
| Virtual | 4 days | All Day | June 18, 2024 | ₹0 | |
| Virtual | 4 days | All Day | July 9, 2024 | ₹0 | |
| Virtual | 4 days | All Day | July 23, 2024 | ₹0 |
FAQs
Find answers to commonly asked questions about our courses, certifications, schedules, and more.
Your cloud learning journey made simple and transparent.
To enroll in this course, choose the starting date and make an online payment. Once your payment is confirmed, our team will reach out to you.
Wire Transfer, Credit Card, Debit Card, UPI & Purchase Order.
There is no minimum number of candidates required, we are happy to train 1 to 1 . With regards to the maximum number, we can accomodate 30 learners in one batch.
- Training Delivered by an Amazon Authorized Instructor.
- AWS Content E-Kit
- Hands-on-labs for 30 days
- Class attendance certificate
You will get the access to course content & lab on first day of your training session.
The course Completion Certificate will be issued to your email id within 2 weeks of completing your course.
A one-day course could be delivered over two half day sessions (4 hours a day), or a three-day course could be delivered over five days (4 hours a day)
