Snowflake SnowPro® Core

On this accelerated SnowPro™ Core course, you’ll learn the concepts, design and best practices for stakeholders working on the Snowflake Data Platform to support drive business objectives. You’ll be able to apply specific core expertise implementing and migrating to Snowflake.

In just 4 days, you’ll build knowledge on illsutrating and differentiating the architecture of the Snowflake Coud Data Platorm and transform data, as well as:

• 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 and demonstrate best practices for working with semi-structured data

At the end of this course, you’ll sit the SnowPro™ Core Certification exam, and achieve your certification. Through Firbrand’s Lecture | Lab | Review methodology, you’ll get access to courseware, learn from certified instructors, and train in a distraction-free environment.

Audience

This course is ideal if you’re in any of the following job roles:

• Technical Team Leads
• Snowflake Administrators
• Data Application Developers
• Data Analysts
• Data Engineers
• Data Scientists
• Database Architects
• Database Administrators

• Section 1: Snowflake Architecture and Overview
• Section 2: Data Movement 
• Section 3: Snowflake Objects & Commands 
• Section 4: Snowflake SQL Support for Data Analysis 
• Section 5: Managing Security 
• Section 6: Semi-structured Data
• Section 7: Caching 
• Section 8: Snowflake Clients and Ecosystem 
• Section 9: Continuous Data Protection
• Section 10: Data Sharing
• Section 11: Performance & Concurrency
• Section 12: Account and Resource Management and Monitoring

As part of your accelerated course, you’ll sit the following exam at the Firebrand Training centre, covered by your Certification Guarantee:

SnowPro™ Core Certification exam

• Duration: 2 hours
• Format: Multiple-choice, multiple-select, True/False, fill-in-the blank and technology matching questions
• Passing score: 80%
• Domains:
1. Snowflake Overview and Architecture (28%)
2. Snowflake Virtual Warehouses (18%)
3. Snowflake Storage and Protection (15%)
4. Data Movement (Loading and Unloading) (14%)
5. Snowflake Account and Security (12%)
6. Snowflake Performance and Tuning (9%)
7. Semi-Stuctured (4%)

There are no formal prerequisites for this accelerated course, but Snowflake recommend you have knowledge in data warehouse.

Your accelerated course includes:

• Accommodation *
• Meals, unlimited snacks, beverages, tea and coffee *
• On-site exams **
• Exam vouchers **
• Practice tests **
• Certification Guarantee ***
• Courseware
• Up-to 12 hours of instructor-led training each day
• 24-hour lab access
• Digital courseware **

* For residential training only. Accommodation is included from the night before the course starts. This doesn't apply for online courses.
** Some exceptions apply. Please refer to the Exam Track or speak with our experts.
*** Pass first time or train again free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.

Seven reasons why you should sit your course with Firebrand Training

• Two options of training. Choose between residential classroom-based, or online courses
• You'll be certified fast. With us, you’ll be trained in record time
• Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
• Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
• You’ll learn more. A day with a traditional training provider generally runs from 9 am – 5 pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day of quality learning time, with your instructor
• You’ll learn faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
• You’ll be studying with the best. We’ve been named in the Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 135,000 professionals

*For residential training only. Doesn't apply for online courses
**Some exceptions apply. Please refer to the Exam Track or speak with our experts

Think you are ready for the course? Take a FREE practice test to assess your knowledge!  Free Practice Test