Master Snowflake with Hands On (Sep 2023)

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

Unfolding Snowflake: Unlocking the Art of Cloud Data Warehousing

1. Introduction

1. Overview

2. Lesson 1

1. Lesson 1 Introduction to snowflake and its architecture

2.1 AG 1.1.pdf

2. Practice 1-1 Creating a Snowflake account, knowing the interface and components

3.1 AG 1.2.pdf

3. Practice 1-2 Creating and Using Virtual Warehouses, altering the warehouse and

3. Lesson 2

1. Lesson 2 Introduction to Snowflake Database Objects

2.1 AG 2.1.pdf

2.2 Employees Managers.csv

2.3 Employees Status.csv

2.4 Employees.csv

2. Practice 2.1 - Creating database, schema, and table from UI and using command

3.1 AG 2.2.pdf

3. Practice 2.2 - Insert data into table, perform SQL queries with joins

4.1 AG 2.3.pdf

4. Practice 2.3 - Creating views, stages and file formats. Creating simple UDF and

4. Lesson 3

1. Lesson 3 Query Development, Data Types, Data Loading & Unloading

2.1 AG 3.1.pdf

2.2 employees2.csv

2. Practice 3.1 - Data Loading using External stage (bulk loading) and Snowpipe (co

3.1 AG 3.2.pdf

3. Practice 3.2 Data Unloading

5. Lesson 4

1. Lesson 4 Snowflake Access Control

2.1 AG 4.1.pdf

2. Practice 4.1 - Creating user defined role, grant that role to other role and ass

6. Lesson 5

1. Lesson 5 Snowflake Security & Governance

2.1 AG 5.1.pdf

2. Practice 5.1 - Enable multifactor authentication, apply data masking to table da

7. Lesson 6

1. Lesson 6 Snowflake Account Costs

2.1 AG 6.1.pdf

2. Practice 6.1 - Check the cost incurred and calculate charges based on credit con

3.1 AG 6.2.pdf

3. Practice 6.2 - Trigger alerts based on credit quota and resource monitor.

189,000 تومان

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

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

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

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