Snowflake Mastery: Easy steps to gain expertise [2024]

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

Snowflake Mastery: An easy step by step approach to be an expert in snowflake

1 - Getting Started

1 -Snowflake Udemy Course Structure -AES.pdf

1 -Welcome and Course Structure

2 -Alphaedge Solutions disclaimer and instructors

2 -Disclaimer-AlphaedgeSolutions.pdf

3 -Actions.pdf

3 -Few Actions before you launch your learning

3 -Snowflake Mastery - Expertise in easy steps.pdf

3 - Course Resources.html

2 - Introduction

1 -Create trial account

2 -Know your UI interface

3 -Share and non share disc architecture

4 -High level snowflake architecture

5 -Virtual warehouse sizes

6 -Create virtual warehouse

7 -Scaling policy

8 -Create first database and table

9 -Load csv file from public S3 bucket

Files.zip

3 - Snowflake Architecture

1 -Snowflake editions

2 -Credits

3 -Minumum 1 minute concept

4 -Credit usage scenarios

5 -Credit to dollar storage cost

6 -Credit consumption for storage

4 - Performance management

1 -Performance improvement methods

2 -Dedicated virtual warehouses

3 -Dedicated Virtual warehouse creation

4 -Scale up and Scale down

5 -Scale out and Scale in

6 -Maximize caching

7 -Maximize caching demonstration

8 -Clustering keys

9 -Clustering costs

10 -Clustering performance

11 -Micropartitions

12 -Micropartitions - query pruning, depths and overlap

Files.zip

5 - Access management

1 -Access control and RBAC

2 -Securable objects

3 -Roles

6 - Tables in snowflake

1 -Table types

2 -Database and schema types

Files.zip

7 - User defined functions (UDFs) and Stored procedures

1 -User defined functions (UDFs)

2 -Stored procedures (SPs)

3 -Secure UDFs and SPs

Files.zip

8 - Views

1 -Non materialized views

2 -Materialized views

3 -Refresh materialized view

Files.zip

9 - Data loading

1 -Data loading techniques

2 -Know snowflake stages

3 -Install SNOWSQL

4 -Internal stages - Userstage

4 -subjects.csv

5 -Internal stages - Tablestage

5 -salary.csv

6 -Internal stages - Namedstage

6 -weather.csv

7 -External stages

7 -contacts5.csv

8 -COPY command

8 -contacts1.csv

8 -contacts2.csv

8 -contacts4.csv

9 -COPY Transformations1

9 -contacts5.csv

10 -COPY Transformations2

11 -File format object

12 -File format object properties

Files.zip

10 - COPY OPTIONS

1 -ON ERROR - CONTINUE

2 -ON ERROR - SKIP FILE

2 -Snowflake-3-b-1

3 -SIZE LIMIT

4 -RETURN FAILED ONLY

5 -ENFORCE LENGTHTRUNCATECOLUMNS

6 -FORCELOAD UNCERTAIN FILES

7 -LOAD HISTORY

8 -VALIDATION MODE - RETURN ERRORS

9 -VALIDATION MODE - RETURN n ROWSRETURN ALL ERRORS

10 -Logging rejected records using RESULT SCAN

11 -Logging rejected records using validate

12 -Data loading best practices1

13 -Data loading best practices2

Files.zip

11 - Data Unloading

1 -Data unloading theory

2 -COPY into location Internalstage - Userstage

3 -COPY into location Internalstage - Tablestage

4 -COPY into location Internalstage - Named internalstage

5 -Unloading using query

6 -Unloading multiple files

Files.zip

12 - Loading and Unloading from AWS

1 -Create AWS free-tier account

2 -Create S3 bucket, file and role

3 -Storage integration object

4 -Load file from AWS

4 -web sites.csv

5 -Unload data to AWS

Files.zip

13 - Loading and Unloading from AZURE

1 -Create azure free trial account

2 -Create storage and container

2 -call centers.csv

3 -Integration object

4 -Load data from Azure

5 -Unload data to Azure

Files.zip

14 - Loading and Unloading from GCP

1 -Create GCP trial account, create bucket and upload file

1 -promotions.csv

2 -Integration object

3 -Load data from GCP

4 -Unload data to GCP

Files.zip

15 - Loading Semi-Structured data

1 -Introduction

2 -Process and understanding the demo data

2 -book.zip

2 -books.zip

3 -JSON Load raw data and analyse nested objects

4 -JSON FLATTEN

5 -JSON Data load and transformation

6 -PARQUET File load and transformation

Files.zip

16 - Snowpipe

1 -Overview

2 -Create snowpipe, load and configure

2 -promotions1.csv

2 -promotions2.csv

2 -promotions3.csv

3 -Troubleshooting and pipe refresh

3 -promotions4.csv

3 -promotions4err.csv

3 -promotions5.csv

4 -Manage snowpipe

4 -promotions5.csv

Files.zip

17 - Dynamic Data Masking

1 -Dynamic data masking overview

2 -Create dynamic data masking policy

3 -Masking policy and policy reference

4 -Masking policy on multiple columns, nested masking and real life examples

5 -Masking policy context and conditional masking

Files.zip

18 - Data Visualization

1 -Data setup for visualization

2 -Snowsight charts and visualization

3 -Tableau installation

4 -Snowflake ODBC driver

5 -Tableau visualization from snowflake data

Files.zip

19 - Partner Connect

1 -Overview

2 -Partner connect demo

20 - Data Sharing

1 -Data sharing overview

2 -Create Table, external table and UDFs for data sharing

3 -Data sharing demo of table, external table and UDF

4 -Create data share via UI

5 -Data share to a reader account

6 -Imported privileges

7 -Data share - entire database

8 -Data share operations - DDL and DML affect

9 -Sharing views and materialized views

Files.zip

139,000 تومان

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

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

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

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