Mastering PostgreSQL: Learning By Real Examples

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

A Comprehensive Guide to Practical PostgreSQL

1 - Introduction

1 - Prerequisites

2 - Working Data

2 - Querying

3 - Select

4 - Select Multiple

5 - Select Constants

6 - Order By

7 - Limit and Offset

8 - Where Statement

9 - IS NULL

10 - OrAnd

11 - Not

12 - Between

13 - In

14 - AnySum

15 - Alias

16 - Exists

17 - Distinct

18 - Like

19 - Case When

3 - Querying Exercises

4 - String Operators

20 - Lower Upper

21 - Initcap

22 - Concat

23 - Left

24 - Right

25 - Substring

26 - Length

27 - Replace

28 - Cast

29 - Trim

30 - SplitPart

5 - Function Exercises

6 - Aggregates

31 - Introduction

32 - Min

33 - Max

34 - Sum

35 - Avg

36 - Count

37 - Filter

38 - Group By

39 - Group By Multiple Columns

40 - Having

41 - Over

7 - Aggregates Exercises

8 - Joins

42 - Union

43 - Union All

44 - Left Join

45 - Inner Join

9 - Joins Exercises

10 - Dates

46 - Current Datetime

47 - AT TIME ZONE

48 - EXTRACT

49 - DATEPART

50 - DATETRUNC

51 - Date Differences

52 - AGE

53 - TOCHAR

54 - TODATE

55 - INTERVAL

56 - makeinterval

11 - Working with JSON

57 - Inserting JSON as a Value

58 - Selecting a JSON Property

59 - Selecting a Sub Property

60 - Json Aggregate

61 - Json Build Object

12 - Working with Arrays

62 - Introduction

63 - UNNEST

64 - SLICING

65 - ARRAYAPPEND

66 - ARRAYLENGTH

67 - Searching an Array

68 - ARRAYAGG

69 - STRINGTOARRAY

13 - Window Functions

70 - Introduction

71 - ROWNUMBER

72 - PARTITION BY

73 - NTILE

14 - Schema and Data

74 - Introduction

75 - Database

76 - Tables

77 - Columns

78 - Columns Attributes DEFAULT

79 - Columns Attributes NOT NULL

80 - Columns Attributes UNIQUE

81 - Columns Attributes CHECK

82 - Primary Keys

83 - Primary Keys Multiple

84 - Foreign Keys

85 - Foreign Keys On Delete

86 - Indexes

87 - IF NOT EXISTS

88 - Rows

89 - Rows Insert Multiple

90 - Rows Handle onConflict

91 - Transactions

15 - Extras

92 - GreatestLeast

93 - Nested Queries

94 - Coalesce

95 - Except

96 - CTE

97 - Generate Series

16 - Conclusion

98 - Where To Go Next

17 - Easy Exercises

18 - Medium Exercises

19 - Hard Exercises

139,000 تومان

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

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

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

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