Description

Price: 5.00 USD | Size: 1.24GB | Duration : 3+  Hours  | ⭐️⭐️⭐️⭐️⭐️ 4.9

BRAND: Expert TRAINING | ENGLISH | Bonus : Snowflake PDF Guides | INSTANT DOWNLOAD

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

• 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.

• 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!

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.

What is covered in the course?

• Snowflake Cloud Data Platform Features & Architecture
  Including an overview of Snowflake, the multi-cluster shared data architecture, storage, query processing and services layers, Snowflake editions and more.
• Account Access & Security
  Including a review of RBAC and DAC access control schemes, deep-dive on roles and privileges, various types of authentication including user authentication, multi-factor authentication (MFA), federated authentication, Key Pair authentication and more.
• Performance Concepts: Virtual Warehouses:
  Including a Virtual warehouse overview, a look at virtual warehouse sizing and billing, virtual warehouse state & properties, resource monitors and more.
• Performance Concepts: Query Optimization
  Including a look at query performance analysis tools, SQL tuning, caching, clustering and more.
• Data Loading & Unloading
  Including a review of simple loading methods such as INSERT, stage objects, file format objects, the serverless feature Snowpipe, bulk loading with the COPY INTO <table> statement, semi-structured functions and more.
• Data Transformations
  Including a birds eye look at functions, deep-dive into estimation functions, table sampling, directory tables and more.
• Storage, Data Protection and Data Sharing
  Including an overview of the storage layer, deep-dive into micro-partitions, data protection features Time Travel and Fail-safe, cloning, replication and more.

In other words, there is a lot of content in this course for you to learn from and that will help you achieve an excellent score in your certification exam!

And once you have passed (which I am sure you will) I’d love to share in your success, so please tag me in a post on LinkedIn. My LinkedIn handle: thomas-bailey-bd.

Enroll now to get lifelong access and pass the SnowPro Core Certification!

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