From Excel to SQL! :- Using Snowflake, Cloud Datawarehouse.

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

SQL, Excel, Snowflake, Cloud Datawarehouse.

1 - Introduction

1 - 1

1 - Introduction

2 - Logging to snowflake

3 - Preparation

2 - Basic

4 - Select ALL

5 - Select specific columns

6 - Select specific Rows Where Clause

7 - Multiple Filters AND OR IN Between Not In Not Between

8 - Aggregation SUM MIN MAX COUNT AVG

9 - Select unique values DISTINCT Group By

10 - Filters on Aggregated Data Having Clause

11 - Column Alias Use cases AS

12 - Conditional Logic CASE IFF

13 - Limiting records TOP Limit Sample

14 - Intro to NULL finding NULL values replace NULL with Coalease NULLIFZERO

15 - Sorting the output ORDER BY

16 - Subquery

3 - Joins

17 - Join Concept

18 - Inner JOIN

19 - Left JOIN

20 - Right JOIN

21 - Full Outer JOIN

22 - CROSS JOIN

4 - SET Operators

23 - Set Operator Concept

24 - UNION ALL

25 - UNION

26 - MINUS Except

27 - INTERSECT

5 - DML

28 - Insert Into the table 1 row multiple rows at a time Manual

29 - Insert Into the table From other tables

30 - Handling NOT NULL columns Default Values

31 - Update a specific value

32 - Update using other tables

33 - Delete Specific row in table

34 - Delete based upon reference table

35 - Truncate

36 - Merge

6 - DDL

37 - Data Types

38 - Create Table Primary Key Not Null

39 - Create Table with Like and Clone

40 - Alter Table Add a column

41 - Alter Table Drop a column

42 - Alter Table Rename a column

43 - Drop Table

44 - Create View

45 - Create Materialized View

7 - Type Casting

46 - Number to String tochartovarchar

47 - String to Number ToNumber

48 - String to Date ToDate

8 - Advanced SQL

49 - Pivot

50 - Unpivot

51 - Aggregate with LISTAGG

52 - Table Functions

53 - Hierarchy

54 - Hierarchy using Connect By

55 - Recursive SQL

56 - Common Table Expression CTE

9 - Window Functions

57 - Windows Functions Rank

58 - RowNumber

59 - NTILE

60 - DenseRank

61 - LAG LEAD

62 - FirstValue LastValue NTHValue

63 - Cumulative Sum

64 - Handling Duplicates

10 - String Functions

65 - Concat

66 - Len

67 - Substr

68 - Position

69 - Upper case Lower case proper case

70 - Trim

71 - Replace

72 - Reverse

73 - Contains

74 - ARRAYAGG

75 - Translate

11 - Number Functions

76 - SUM Count Min Max AVG ABS

77 - Arithmetic Operations

78 - Convert String to Number

12 - Date Functions

79 - Get Number of DayMonthYear between 2 dates DATEDIFF TIMEDIFF

13 - Regular Expression

80 - REGEXP

81 - REGEXPLIKE

82 - REGEXPSUBSTR REGEXPSUBSTRALL

83 - REGEXPCount

84 - REGEXPREPLACE

85 - REGEXPINSTR

14 - Bonus Sessions

86 - SQL Standards Tips

87 - Performance Tunning

15 - Practice Session

88 - Practice Session 1

89 - Practice Session 2

90 - Practice Session 3

91 - Practice Session 4

92 - Practice Session 5

93 - Practice Session 6

94 - Practice Session 7

95 - Practice Session 8

96 - Practice Session 9

139,000 تومان

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

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

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

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