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 | 7 hours on-demand video course
Welcome to the ultimate COF-C02 SnowPro Core Certification preparation course! After completing this course you’ll have everything you need to ace the SnowPro Core certification exam. The contents have been arranged to cover everything from the Snowflake study guide (and more).
It starts with a broad look at Snowflake’s architecture and key features and moves through important topics such as account security and data protection, performance improvement, data loading and unloading, working with structured, semi-structured and unstructured data and data sharing.
This Ultimate SnowPro Core Certification Course & Exam – 2024 course not only provides you with a solid practical level of skill you can take into the workplace but also places you well to attempt further certifications such as the SnowPro Advanced: Data Engineer and SnowPro Advanced: Architect.
Ultimate SnowPro Core Certification Course
What you’ll 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.
Recommended Course
Snowflake for Data Science and Data Engineering – 2023/24
Snowflake Certification: SnowPro Core COF-C02 Exam Prep
Snowflake – The Complete Masterclass Best seller
The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero Best seller
What do you get with this course?
- Covers in-depth all the topics required for the COF-C02 SnowPro Core Certification exam.
- Hands-on lessons using the new Snowsight Web Interface with downloadable code examples.
- Theory lectures which include architectural diagrams, graphics, code snippets and overview slides to bookmark and study from.
- Practice exam with 100 questions.
- A questionnaire at the end of each section to help solidify the theory and hands-on covered.
- The perspective of someone who has studied and passed the Core and Advanced Snowflake certifications.