17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
Language: English | Size: 1.71 GB | Duration: 7h 6m
Learn Snowflake from scratch with a certified data engineer and ace the SnowPro Core COF-C02 certification exam.
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.
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!
Description
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 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.Even if you have no experience with Snowflake, this course will take you from beginner to certified. Here’s why:This is one of the only courses online which is geared specifically to cover the contents of the Core exam for the most recent COF-C02 version of the certification.As well as all the topics required for the certification exam, the course also includes extra content on advanced topics to help you truly master Snowflake.This is one of the most comprehensive Snowflake courses you can find on Udemy with over 7+ hours of quality HD videos, providing an engaging mixture of theory and hands-on lessons.Because we start with beginners in mind, and cover basic to advanced topics, it’s great even for those not intending to take the certification exam. There is enough content to drop in and out of the areas that interest you.Your instructor is an experienced data engineer certified in Amazon Web Services (AWS), Apache Kafka and most importantly for this course, has earned the SnowPro Core and SnowPro Advanced Data Engineer certifications.All lectures and hands-on have been designed from the ground up to make difficult topics easy to understand, getting straight to the point and using simple English.Includes personal support via the Q&A when you have questions and queries either about Snowflake concepts or assistance with making the most out of the course.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 & ArchitectureIncluding an overview of Snowflake, the multi-cluster shared data architecture, storage, query processing and services layers, Snowflake editions and more. Account Access & SecurityIncluding 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 OptimizationIncluding a look at query performance analysis tools, SQL tuning, caching, clustering and more.Data Loading & UnloadingIncluding 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 TransformationsIncluding a birds eye look at functions, deep-dive into estimation functions, table sampling, directory tables and more. Storage, Data Protection and Data SharingIncluding 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!
Overview
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1 - Introduction/1 - Course Structure.mp4
10.5 MB
~Get Your Files Here !/1 - Introduction/2 - Making the most of this course.mp4
8.5 MB
~Get Your Files Here !/1 - Introduction/3 - Provisioning a trial Snowflake account Handson.mp4
34 MB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D1/D1_1 - Access Control.sql
2.1 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D1/D1_2 - Column And Row Level Security.sql
3.3 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D2/D2_1 - Virtual Warehouse Introduction.sql
1.4 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D2/D2_2 - Resource Monitors & Warehouse Monitoring.sql
1.6 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D2/D2_3 - Multi-cluster Warehouse.sql
1.2 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D3/D3_1 - Insert & UI File Upload.sql
1.5 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D3/D3_2 - Stage Types.sql
2.2 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D3/D3_3 - Copy Into Table.sql
2.3 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D3/D3_4 - Semi-structured Introduction.sql
3.5 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D3/films.csv
242 B
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D3/films.json
1017 B
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D4/D4_1 - Query History & Query Profile.sql
1.4 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D4/D4_2 - Caching.sql
2.2 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D4/D4_3 - Clustering & Micro-partition Pruning.sql
1.2 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D5/D5_1 - Databases, Schemas, Tables & Views.sql
2.8 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D5/D5_2 - UDFs, External Functions & Stored Procedures.sql
4.4 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D5/D5_3 - SnowCD & SnowSQL.sql
811 B
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D5/D5_4 - Secure Data Sharing.sql
2.4 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D5/D5_5 - Data Marketplace.sql
340 B
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D6/D6_1 - Time Travel.sql
3 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/D6/D6_2 - Cloning.sql
1.5 KB
~Get Your Files Here !/1 - Introduction/Hands-on Queries/Introduction/environment_setup.sql
265 B
~Get Your Files Here !/10 - Thank You/93 - Thank You & Well Done.mp4
13.6 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/10 - Snowflake Editions.mp4
7 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/11 - Snowflake Object Model.mp4
10.1 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/12 - Organizations Accounts Databases & Schemas.mp4
29.4 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/13 - Table & View Types.mp4
17.9 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/14 - Databases Schemas Tables & Views Handson.mp4
29 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/15 - User Defined Functions UDFs.mp4
26 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/16 - Stored Procedures.mp4
11.4 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/17 - UDFs External Functions & Stored Procedures Handson.mp4
26.1 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/18 - Sequences.mp4
8.5 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/19 - Tasks & Streams.mp4
20.4 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/20 - Billing Overview.mp4
32.8 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/21 - User Interfaces Handson.mp4
25.9 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/22 - SnowSQL Handson.mp4
9.3 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/23 - Connectivity Connectors Drivers & Partnered Tools.mp4
17.2 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/24 - Connectivity Snowflake Scripting.mp4
18.3 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/25 - Snowpark.mp4
18.6 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/4 - Snowflake Features & Architecture Introduction.mp4
11 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/5 - What is Snowflake.mp4
35.1 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/6 - Multicluster Shared Data Architecture.mp4
26.8 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/7 - Storage Layer Overview.mp4
11.4 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/8 - Query Processing Layer Overview.mp4
16.3 MB
~Get Your Files Here !/2 - Snowflake Features & Architecture/9 - Services Layer Overview.mp4
11.8 MB
~Get Your Files Here !/3 - Account Access & Security/26 - Account Access & Security Introduction.mp4
8.2 MB
~Get Your Files Here !/3 - Account Access & Security/27 - Access Control Overview.mp4
14 MB
~Get Your Files Here !/3 - Account Access & Security/28 - Roles.mp4
23.8 MB
~Get Your Files Here !/3 - Account Access & Security/29 - Privileges.mp4
10.3 MB
~Get Your Files Here !/3 - Account Access & Security/30 - Access Control Handson.mp4
30.4 MB
~Get Your Files Here !/3 - Account Access & Security/31 - User Authentication.mp4
8.7 MB
~Get Your Files Here !/3 - Account Access & Security/32 - Multifactor Authentication MFA.mp4
11.9 MB
~Get Your Files Here !/3 - Account Access & Security/33 - Federated Authentication.mp4
12.4 MB
~Get Your Files Here !/3 - Account Access & Security/34 - Key Pair Authentication OAuth & SCIM.mp4
10.7 MB
~Get Your Files Here !/3 - Account Access & Security/35 - Network Policies.mp4
13.2 MB
~Get Your Files Here !/3 - Account Access & Security/36 - Data Encryption.mp4
25 MB
~Get Your Files Here !/3 - Account Access & Security/37 - Column Level Security.mp4
18.9 MB
~Get Your Files Here !/3 - Account Access & Security/38 - Row Level Security.mp4
11.8 MB
~Get Your Files Here !/3 - Account Access & Security/39 - Column and Row Level Security Handson.mp4
21.4 MB
~Get Your Files Here !/3 - Account Access & Security/40 - Secure Views.mp4
11.2 MB
~Get Your Files Here !/3 - Account Access & Security/41 - Account Usage & Information Schema.mp4
26.3 MB
~Get Your Files Here !/4 - Performance Concepts Virtual Warehouses/42 - Performance Concepts Virtual Warehouses Introduction.mp4
8.1 MB
~Get Your Files Here !/4 - Performance Concepts Virtual Warehouses/43 - Virtual Warehouse Overview.mp4
11.3 MB
~Get Your Files Here !/4 - Performance Concepts Virtual Warehouses/44 - Virtual Warehouse Sizing and Billing.mp4
17.1 MB
~Get Your Files Here !/4 - Performance Concepts Virtual Warehouses/45 - Virtual Warehouse State & Properties.mp4
14 MB
~Get Your Files Here !/4 - Performance Concepts Virtual Warehouses/46 - Virtual Warehouse Overview Handson.mp4
20.8 MB
~Get Your Files Here !/4 - Performance Concepts Virtual Warehouses/47 - Resource Monitors.mp4
16 MB
~Get Your Files Here !/4 - Performance Concepts Virtual Warehouses/48 - Compute Monitoring & Resource Monitors Handson.mp4
23.8 MB
~Get Your Files Here !/4 - Performance Concepts Virtual Warehouses/49 - Multicluster Warehouses.mp4
36.5 MB
~Get Your Files Here !/5 - Performance Concepts Query Optimisation/50 - Query performance analysis tools Handson.mp4
37.8 MB
~Get Your Files Here !/5 - Performance Concepts Query Optimisation/51 - SQL Tuning.mp4
28.4 MB
~Get Your Files Here !/5 - Performance Concepts Query Optimisation/52 - Caching.mp4
23.6 MB
~Get Your Files Here !/5 - Performance Concepts Query Optimisation/53 - Caching Handson.mp4
35.8 MB
~Get Your Files Here !/5 - Performance Concepts Query Optimisation/54 - Materialized Views.mp4
15.8 MB
~Get Your Files Here !/5 - Performance Concepts Query Optimisation/55 - Clustering.mp4
21.7 MB
~Get Your Files Here !/5 - Performance Concepts Query Optimisation/56 - Automatic Clustering.mp4
22.8 MB
~Get Your Files Here !/5 - Performance Concepts Query Optimisation/57 - Clustering & Pruning Handson.mp4
32.5 MB
~Get Your Files Here !/5 - Performance Concepts Query Optimisation/58 - Search Optimization Service.mp4
9.1 MB
~Get Your Files Here !/6 - Data Loading & Unloading/59 - Data Loading and Unloading Introduction.mp4
6 MB
~Get Your Files Here !/6 - Data Loading & Unloading/60 - Simple Data Loading Methods INSERT & UI Handson.mp4
16.6 MB
~Get Your Files Here !/6 - Data Loading & Unloading/61 - Stages.mp4
33.1 MB
~Get Your Files Here !/6 - Data Loading & Unloading/62 - Stages Handson.mp4
22.3 MB
~Get Your Files Here !/6 - Data Loading & Unloading/63 - Bulk Loading COPY INTO TABLE command.mp4
35.3 MB
~Get Your Files Here !/6 - Data Loading & Unloading/64 - File Formats.mp4
9.8 MB
~Get Your Files Here !/6 - Data Loading & Unloading/65 - Bulk Loading Handson.mp4
19.8 MB
~Get Your Files Here !/6 - Data Loading & Unloading/66 - Snowpipe.mp4
33.5 MB
~Get Your Files Here !/6 - Data Loading & Unloading/67 - Data Unloading.mp4
21.3 MB
~Get Your Files Here !/6 - Data Loading & Unloading/68 - Semistructured Overview.mp4
22.7 MB
~Get Your Files Here !/6 - Data Loading & Unloading/69 - Loading and Unloading Semistructured Data.mp4
20.4 MB
~Get Your Files Here !/6 - Data Loading & Unloading/70 - Accessing Semistructured Data.mp4
15.5 MB
~Get Your Files Here !/6 - Data Loading & Unloading/71 - Semistructured Functions.mp4
12.4 MB
~Get Your Files Here !/6 - Data Loading & Unloading/72 - Semistructured Data Handson.mp4
33.7 MB
~Get Your Files Here !/7 - Data Transformations/73 - Data Transformations Introduction.mp4
4.1 MB
~Get Your Files Here !/7 - Data Transformations/74 - Summary of Snowflake Functions.mp4
21 MB
~Get Your Files Here !/7 - Data Transformations/75 - Estimation Functions.mp4
