Ultimate SnowPro Core Certification Course & Exam – 2022/23

سرفصل های دوره

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

1 - Introduction

1 - Course Structure

2 - Making the most of this course

2 - SnowPro-Core-Course-Hands-on-Resources.zip

3 - Provisioning a trial Snowflake account Handson

2 - Snowflake Features & Architecture

4 - Snowflake Features & Architecture Introduction

5 - What is Snowflake

6 - Multicluster Shared Data Architecture

7 - Storage Layer Overview

8 - Query Processing Layer Overview

9 - Services Layer Overview

10 - Snowflake Editions

11 - Snowflake Object Model

12 - Organizations Accounts Databases & Schemas

13 - Table & View Types

14 - Databases Schemas Tables & Views Handson

15 - User Defined Functions UDFs

16 - Stored Procedures

17 - UDFs External Functions & Stored Procedures Handson

18 - Sequences

19 - Tasks & Streams

20 - Billing Overview

21 - User Interfaces Handson

22 - SnowSQL Handson

23 - Connectivity Connectors Drivers & Partnered Tools

24 - Connectivity Snowflake Scripting

25 - Snowpark

3 - Account Access & Security

26 - Account Access & Security Introduction

27 - Access Control Overview

28 - Roles

29 - Privileges

30 - Access Control Handson

31 - User Authentication

32 - Multifactor Authentication MFA

33 - Federated Authentication

34 - Key Pair Authentication OAuth & SCIM

35 - Network Policies

36 - Data Encryption

37 - Column Level Security

38 - Row Level Security

39 - Column and Row Level Security Handson

40 - Secure Views

41 - Account Usage & Information Schema

4 - Performance Concepts Virtual Warehouses

42 - Performance Concepts Virtual Warehouses Introduction

43 - Virtual Warehouse Overview

44 - Virtual Warehouse Sizing and Billing

45 - Virtual Warehouse State & Properties

46 - Virtual Warehouse Overview Handson

47 - Resource Monitors

48 - Compute Monitoring & Resource Monitors Handson

49 - Multicluster Warehouses

5 - Performance Concepts Query Optimisation

50 - Query performance analysis tools Handson

51 - SQL Tuning

52 - Caching

53 - Caching Handson

54 - Materialized Views

55 - Clustering

56 - Automatic Clustering

57 - Clustering & Pruning Handson

58 - Search Optimization Service

6 - Data Loading & Unloading

59 - Data Loading and Unloading Introduction

60 - Simple Data Loading Methods INSERT & UI Handson

61 - Stages

62 - Stages Handson

63 - Bulk Loading COPY INTO TABLE command

64 - File Formats

65 - Bulk Loading Handson

66 - Snowpipe

67 - Data Unloading

68 - Semistructured Overview

69 - Loading and Unloading Semistructured Data

70 - Accessing Semistructured Data

71 - Semistructured Functions

72 - Semistructured Data Handson

7 - Data Transformations

73 - Data Transformations Introduction

74 - Summary of Snowflake Functions

75 - Estimation Functions

76 - Table Sampling

77 - Unstructured File Functions

78 - Directory Tables

79 - File Support REST API

8 - Storage Data Protection & Data Sharing

80 - Storage Data Protection & Data Sharing Introduction

81 - Storage Layer Overview

82 - Micropartitions

83 - Time Travel & FailSafe

84 - Time Travel Handson

85 - Cloning

86 - Cloning Handson

87 - Replication

88 - Storage Billing

89 - Secure Data Sharing

90 - Secure Data Sharing Handson

91 - Data Marketplace Handson

92 - Data Exchange

9 - Mock SnowPro Core Exam 100 Questions

1 - Mock SnowPro Core Exam.html

10 - Thank You

93 - Thank You & Well Done

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training