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

“Master Consumer Behavior To Boost Sales” به سبد خرید شما اضافه شد. مشاهده سبد خرید

139,000 تومان

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

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

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

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