Ultimate SnowPro Core Certification Course & Exam – 2024

Learn Snowflake from scratch with a certified data engineer and ace the SnowPro Core COF-C02 certification exam.

Created by: Tom Bailey
Instructor • AWS, Kafka & Snowflake Certified Developer

What Will I Learn?

• Learn the fundamentals of Snowflake with a mixture of theory lectures and practical hands-on using the Snowflake platform.
• End of course mock exam including 100 questions to help you prepare for certification exam.
• End of section quizzes to solidify knowledge from each section.
• Downloadable code samples for the practical hands-on lessons.
• Learn in-depth about Snowflake’s architecture including storage concepts in the storage layer, warehouses in the compute layer and the global services layer.
• In-depth look at the Snowsight UI and the classic console and a comparison of their features.
• Learn about Snowflake’s broad set of objects including Organizations, Accounts, Databases, Schemas, Tables, Views, User-define functions (UDFs) and much more.
• Overview of high-level programmatic data processing with the Snowpark API.
• Learn about Snowflake security features including Network Policies, Multi-Factor Authentication (MFA), Federated Authentication and Single Sign-On (SSO).
• Learn about the access control schemes Snowflake use including Role Based Access Control (RBAC) and Discretionary Access Control (DAC).
• Learn about the ways you can monitor and track usage within organizations, accounts and tables programmatically and through the UI.
• Learn to optimise query performance using the Query Profile tool, Materialized Views, Clustering, the Search Optimization Service and tuning SQL code.
• Learn how to load and unload data into Snowflake. Covering bulk data loading with the COPY INTO statement and continuous data loading with Snowpipe.
• Learn how to work with structured, semi-structured and unstructured data.
• Learn about Snowflake data protection features such as Time Travel, Fail-safe, Data Encryption, Cloning and Replication.
• Learn how to share data between Snowflake accounts with Secure Data Sharing, the Data Marketplace and the Data Exchange.

Requirements

• Basics of SQL syntax such as selecting, inserting, and dropping data. Any SQL concepts specific to Snowflake will be explained thoroughly during the course.
• Understanding the basics of cloud computing will help but is not needed to complete this course.
• For the hands-on lessons you’ll need a free Snowflake trial account. We walk through the process of obtaining an account in one of the introductory videos!

Target audience

• Anyone wanting to know more about Snowflake or prepare for the SnowPro Core Certification.