Snowflake Mastery: Easy steps to gain expertise [2023]

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

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 - Course Resources.html

3 - Snowflake-Mastery-Expertise-in-easy-steps.pdf

4 - Actions.pdf

4 - Few Actions before you launch your learning

2 - Introduction

5 - Create trial account

6 - Know your UI interface

7 - Share and non share disc architecture

8 - High level snowflake architecture

9 - Virtual warehouse sizes

10 - Create virtual warehouse

11 - Scaling policy

12 - Create first database and table

12 - lecture-create-first-db-and-table.zip

13 - Load csv file from public S3 bucket

13 - lecture-create-first-db-and-table-load-from-s3.zip

3 - Snowflake Architecture

14 - Snowflake editions

15 - Credits

16 - Minumum 1 minute concept

17 - Credit usage scenarios

18 - Credit to dollar storage cost

19 - Credit consumption for storage

4 - Performance management

20 - Performance improvement methods

21 - Dedicated virtual warehouses

22 - Dedicated Virtual warehouse creation

22 - dedicated-warehouse.zip

23 - Scale up and Scale down

23 - scaleup-scale-down.zip

24 - Scale out and Scale in

25 - Maximize caching

26 - Maximize caching demonstration

26 - maximize-caching-demo.zip

27 - Clustering keys

27 - clustering.zip

28 - Clustering costs

29 - Clustering performance

29 - clustering-performance.zip

30 - Micropartitions

31 - Micropartitions query pruning depths and overlap

31 - micropartition-query-pruning.zip

5 - Access management

32 - Access control and RBAC

33 - Securable objects

34 - Roles

6 - Tables in snowflake

35 - Table types

35 - tables.zip

36 - Database and schema types

36 - database-and-schema.zip

7 - User defined functions UDFs and Stored procedures

7 - UDFs and SP.html

37 - User defined functions UDFs

37 - udf.zip

38 - Stored procedures SPs

38 - sps.zip

39 - Secure UDFs and SPs

39 - secure-udfss-sps.zip

8 - Views

40 - Non materialized views

40 - views.zip

41 - Materialized views

41 - materialized-views.zip

42 - Refresh materialized view

42 - refresh-materialized-views.zip

9 - Data loading

43 - Data loading techniques

44 - Know snowflake stages

45 - Install SNOWSQL

45 - snowsql.zip

46 - Internal stages Userstage

46 - subjects.csv

46 - user-stage.zip

47 - Internal stages Tablestage

47 - salary.csv

47 - table-stage.zip

48 - Internal stages Namedstage

48 - internal-named-stage.zip

48 - weather.csv

49 - External stages

49 - contacts5.csv

49 - external-stage.zip

50 - COPY command

50 - contacts1.csv

50 - contacts2.csv

50 - contacts4.csv

50 - copy.zip

51 - COPY Transformations1

51 - contacts5.csv

51 - copy-transformations1.zip

52 - COPY Transformations2

52 - copy-transformations2.zip

53 - File format object

53 - file-format-object.zip

54 - File format object properties

54 - file-format-object-properties.zip

10 - COPY OPTIONS

55 - ONERROR CONTINUE

55 - on-error-continue.zip

56 - ONERROR SKIPFILE

56 - Snowflake-3-b-1.1-Copy-Option-ON-ERROR-SKIP-FILE

56 - on-error-skip-file.zip

57 - SIZELIMIT

57 - size-limit.zip

58 - RETURNFAILEDONLY

58 - returned-failed-only.zip

59 - ENFORCELENGTHTRUNCATECOLUMNS

59 - enforce-length-truncatecolumns.zip

60 - FORCELOADUNCERTAINFILES

60 - force-and-load-uncertain-files.zip

61 - LOADHISTORY

61 - load-history.zip

62 - VALIDATION MODE RETURNERRORS

62 - validation-mode-return-errors.zip

63 - VALIDATION MODE RETURNnROWSRETURNALLERRORS

63 - validation-mode-return-n-rows-and-return-all-errors.zip

64 - Logging rejected records using RESULTSCAN

64 - logging-rejected-records-using-result-scan.zip

65 - Logging rejected records using validate

65 - logging-rejected-records-using-validate.zip

66 - Data loading best practices1

67 - Data loading best practices2

11 - Data Unloading

68 - Data unloading theory

69 - COPY into location Internalstage Userstage

69 - data-unloading-user-stage.zip

70 - COPY into location Internalstage Tablestage

70 - data-unloading-table-stage.zip

71 - COPY into location Internalstage Named internalstage

71 - unloading-data-internal-named-stage.zip

72 - Unloading using query

72 - unloading-using-query.zip

73 - Unloading multiple files

73 - unloading-data-to-multiple-files.zip

12 - Loading and Unloading from AWS

74 - Create AWS freetier account

75 - Create S3 bucket file and role

76 - Storage integration object

76 - aws-loading-integration-object.zip

77 - Load file from AWS

77 - aws-loading.zip

77 - web-sites.csv

78 - Unload data to AWS

78 - aws-unloading.zip

13 - Loading and Unloading from AZURE

79 - Create azure free trial account

80 - Create storage and container

80 - call-centers.csv

81 - Integration object

81 - azure-integration-object.zip

82 - Load data from Azure

82 - azure-loading.zip

83 - Unload data to Azure

83 - azure-unloading.zip

14 - Loading and Unloading from GCP

84 - Create GCP trial account create bucket and upload file

84 - promotions.csv

85 - Integration object

85 - gcp-integration-object.zip

86 - Load data from GCP

86 - gcp-loading.zip

87 - Unload data to GCP

87 - gcp-unloading.zip

15 - Loading SemiStructured data

19 - Semistructured data.html

88 - Introduction

88 - semi-structured-data.zip

89 - Process and understanding the demo data

89 - book.zip

89 - books.zip

89 - understanding-demo-data.zip

90 - JSON Load raw data and analyse nested objects

90 - raw-data-analysis.zip

91 - JSON FLATTEN

91 - flatten.zip

92 - JSON Data load and transformation

92 - json-transformation-load.zip

93 - PARQUET File load and transformation

93 - assignment-cities.zip

93 - cities.zip

93 - parquet-load-transformation.zip

16 - Snowpipe

94 - Overview

95 - Create snowpipe load and configure

95 - create-snowpipe-configure-load.zip

95 - promotions1.csv

95 - promotions2.csv

95 - promotions3.csv

96 - Troubleshooting and pipe refresh

96 - promotions4.csv

96 - promotions4err.csv

96 - promotions5.csv

96 - troubleshooting-pipe-refresh.zip

97 - Manage snowpipe

97 - manage-snowpipe.zip

97 - promotions5.csv

17 - Dynamic Data Masking

98 - Dynamic data masking overview

99 - Create dynamic data masking policy

99 - create-dynamic-datamasking.zip

100 - Masking policy and policy reference

100 - masking-policies-and-policy-references.zip

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

101 - masking-policies-on-multiple-columns.zip

102 - Masking policy context and conditional masking

102 - policy-context-and-conditional-masking.zip

18 - Data Visualization

103 - Data setup for visualization

103 - snowsight-data-visualization.zip

104 - Snowsight charts and visualization

105 - Tableau installation

106 - Snowflake ODBC driver

107 - Tableau visualization from snowflake data

19 - Partner Connect

108 - Overview

109 - Partner connect demo

20 - Data Sharing

24 - Data Sharing.html

110 - Data sharing overview

111 - Create Table external table and UDFs for data sharing

111 - create-table-exttable-udf-for-datasharing.zip

112 - Data sharing demo of table external table and UDF

112 - data-sharing-demo.zip

113 - Create data share via UI

114 - Data share to a reader account

114 - data-share-to-reader-account.zip

115 - Imported privileges

115 - imported-privileges.zip

116 - Data share entire database

116 - data-share-entire-db.zip

117 - Data share operations DDL and DML affect

117 - data-share-dml-ddl.zip

118 - Sharing views and materialized views

118 - data-share-vw-mvw.zip

21 - Time Travel

119 - Time travel overview

119 - time-travel-overview.zip

120 - Retrieve data using at and before

120 - data-retrieval-using-at-and-before.zip

121 - Data restoration using direct method

121 - data-restoration-direct-method.zip

122 - Data restoration using indirect method

122 - data-restoration-indirect-method.zip

123 - UNDROP

123 - undrop.zip

124 - Understanding retention time

124 - retention-time.zip

22 - FAILSAFE

125 - Overview

126 - Failsafe demo

126 - fail-safe.zip

23 - Zero Copy Cloning

127 - Overview

128 - Cloning permanent tables

128 - cloning-permanent-tables.zip

129 - Copy grants and more on cloning

129 - copy-grants-and-more-on-cloning.zip

130 - Clone schema and database

130 - clone-database-schema.zip

131 - Swap

131 - swap.zip

132 - Clone using time travel and understand sharing vs cloning

132 - clone-using-time-travle.zip

24 - Streams

133 - Streams Overview

133 - streams.zip

134 - Streams Offset

135 - Consuming streams using insert update and delete

135 - consume-streams-insert-update-delete.zip

136 - Types of streams default append only Consume stream using false condition

136 - types-of-streams.zip

137 - Insert only streams for external tables

137 - insert-only-external-table.zip

137 - promotions1.csv

137 - promotions2.csv

137 - promotions3.csv

137 - promotions3-less.csv

137 - promotions4.csv

138 - Multiple consumers with streams

138 - multiple-consumers.zip

139 - Changes clause

139 - change-clause.zip

140 - Streams staleafter and extension in days

140 - streams-stale-after-and-extension.zip

141 - Recreate rename and clone effect on stream

141 - streams-recreate-rename-clone.zip

25 - Tasks

142 - Understanding tasks

142 - understanding-tasks.zip

143 - Create tasks using procedure when and troubleshoot tasks

143 - create-tasks-using-proc-and-when-and-troubleshoot.zip

144 - Schedule task using CRON

144 - schedule-tasks-using-cron.zip

145 - CRON Day light savings considerations

145 - cron-demo-day-light-saving-cosiderations.zip

146 - DAG Tree of tasks

146 - dag.zip

147 - Task with stream

147 - tasks-with-streams.zip

148 - User managed tasks and warehouse considerations

26 - Sampling Data

149 - Overview

150 - Row sampling method

150 - row-sampling.zip

151 - System block method

151 - block-sampling.zip

27 - Access management in practice

152 - System defined roles and its users

152 - system-defined-roles-and-its-users.zip

153 - Custom roles and its users

153 - custom-roles-and-its-users.zip

154 - Create objects from sysadmin role and assign to developer role

154 - objects-created-via-sysadmin-role.zip

155 - Create custom users developer1 developer2 qa1 and reader1

155 - custome-users-developer1-developer2-reader1-qa1.zip

156 - Problems due to unassigned custom roles

156 - problems.zip

157 - Solution of the problems

157 - solutions.zip

158 - Public Role

158 - public-role.zip

28 - Best Practices

32 - Best practices.html

159 - Auto resume success and failure and long running queries

159 - auto-resume-success-failure-long-running-queries.zip

160 - Resource monitor

161 - Resource monitor via SQL

161 - resource-monitor-via-sql.zip

162 - Resource monitor with custom schedule

162 - resource-monitor-custom-schedule.zip

163 - Columns storage cost and benchmarking the queries

29 - Thank you

164 - ThankYou-and-Stay-connected.pdf

164 - Thank you note stay connected and good luck

139,000 تومان

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

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

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

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