Udemy - Mastering Postgresql - Learning By Real Examples

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 - Prerequisites.mp4 (2.4 MB)
• 2 - Working Data.mp4 (8.9 MB)
10 - Dates
• 46 - Current Datetime.mp4 (8.5 MB)
• 47 - AT TIME ZONE.mp4 (10.3 MB)
• 48 - EXTRACT.mp4 (15.2 MB)
• 49 - DATEPART.mp4 (8.5 MB)
• 50 - DATETRUNC.mp4 (17.6 MB)
• 51 - Date Differences.mp4 (24.0 MB)
• 52 - AGE.mp4 (11.4 MB)
• 53 - TOCHAR.mp4 (12.5 MB)
• 54 - TODATE.mp4 (11.5 MB)
• 55 - INTERVAL.mp4 (12.2 MB)
• 56 - makeinterval.mp4 (20.6 MB)
11 - Working with JSON
• 57 - Inserting JSON as a Value.mp4 (5.4 MB)
• 58 - Selecting a JSON Property.mp4 (14.6 MB)
• 59 - Selecting a Sub Property.mp4 (16.5 MB)
• 60 - Json Aggregate.mp4 (17.6 MB)
• 61 - Json Build Object.mp4 (22.6 MB)
12 - Working with Arrays
• 62 - Introduction.mp4 (8.6 MB)
• 63 - UNNEST.mp4 (12.9 MB)
• 64 - SLICING.mp4 (12.8 MB)
• 65 - ARRAYAPPEND.mp4 (6.0 MB)
• 66 - ARRAYLENGTH.mp4 (11.4 MB)
• 67 - Searching an Array.mp4 (17.3 MB)
• 68 - ARRAYAGG.mp4 (16.3 MB)
• 69 - STRINGTOARRAY.mp4 (10.9 MB)
13 - Window Functions
• 70 - Introduction.mp4 (10.3 MB)
• 71 - ROWNUMBER.mp4 (14.2 MB)
• 72 - PARTITION BY.mp4 (18.3 MB)
• 73 - NTILE.mp4 (19.7 MB)
14 - Schema and Data
• 74 - Introduction.mp4 (6.2 MB)
• 75 - Database.mp4 (17.2 MB)
• 76 - Tables.mp4 (27.4 MB)
• 77 - Columns.mp4 (19.5 MB)
• 78 - Columns Attributes DEFAULT.mp4 (20.3 MB)
• 79 - Columns Attributes NOT NULL.mp4 (15.6 MB)
• 80 - Columns Attributes UNIQUE.mp4 (9.2 MB)
• 81 - Columns Attributes CHECK.mp4 (14.2 MB)
• 82 - Primary Keys.mp4 (19.3 MB)
• 83 - Primary Keys Multiple.mp4 (16.7 MB)
• 84 - Foreign Keys.mp4 (39.9 MB)
• 85 - Foreign Keys On Delete.mp4 (36.0 MB)
• 86 - Indexes.mp4 (10.6 MB)
• 87 - IF NOT EXISTS.mp4 (9.7 MB)
• 88 - Rows.mp4 (18.7 MB)
• 89 - Rows Insert Multiple.mp4 (5.8 MB)
• 90 - Rows Handle onConflict.mp4 (19.5 MB)
• 91 - Transactions.mp4 (22.3 MB)
15 - Extras
• 92 - GreatestLeast.mp4 (5.8 MB)
• 93 - Nested Queries.mp4 (9.4 MB)
• 94 - Coalesce.mp4 (9.0 MB)
• 95 - Except.mp4 (9.6 MB)
• 96 - CTE.mp4 (18.9 MB)
• 97 - Generate Series.mp4 (24.5 MB)
16 - Conclusion
• 98 - Where To Go Next.mp4 (6.0 MB)
2 - Querying
• 10 - OrAnd.mp4 (12.2 MB)
• 11 - Not.mp4 (15.0 MB)
• 12 - Between.mp4 (7.7 MB)
• 13 - In.mp4 (10.7 MB)
• 14 - AnySum.mp4 (19.7 MB)
• 15 - Alias.mp4 (17.5 MB)
• 16 - Exists.mp4 (17.3 MB)
• 17 - Distinct.mp4 (5.2 MB)
• 18 - Like.mp4 (19.3 MB)
• 19 - Case When.mp4 (9.1 MB)
• 3 - Select.mp4 (8.2 MB)
• 4 - Select Multiple.mp4 (7.1 MB)
• 5 - Select Constants.mp4 (6.9 MB)
• 6 - Order By.mp4 (17.5 MB)
• 7 - Limit and Offset.mp4 (16.3 MB)
• 8 - Where Statement.mp4 (11.3 MB)
• 9 - IS NULL.mp4 (12.0 MB)
4 - String Operators
• 20 - Lower Upper.mp4 (8.4 MB)
• 21 - Initcap.mp4 (6.3 MB)
• 22 - Concat.mp4 (8.1 MB)
• 23 - Left.mp4 (5.4 MB)
• 24 - Right.mp4 (6.1 MB)
• 25 - Substring.mp4 (7.6 MB)
• 26 - Length.mp4 (13.9 MB)
• 27 - Replace.mp4 (6.7 MB)
• 28 - Cast.mp4 (13.0 MB)
• 29 - Trim.mp4 (14.2 MB)
• 30 - SplitPart.mp4 (8.6 MB)
6 - Aggregates
• 31 - Introduction.mp4 (7.3 MB)
• 32 - Min.mp4 (6.4 MB)
• 33 - Max.mp4 (3.9 MB)
• 34 - Sum.mp4 (6.0 MB)
• 35 - Avg.mp4 (4.0 MB)
• 36 - Count.mp4 (8.3 MB)
• 37 - Filter.mp4 (18.3 MB)
• 38 - Group By.mp4 (15.5 MB)
• 39 - Group By Multiple Columns.mp4 (15.8 MB)
• 40 - Having.mp4 (13.2 MB)
• 41 - Over.mp4 (12.9 MB)
8 - Joins
• 42 - Union.mp4 (12.3 MB)
• 43 - Union All.mp4 (9.1 MB)
• 44 - Left Join.mp4 (39.6 MB)
• 45 - Inner Join.mp4 (15.7 MB)
• Bonus Resources.txt (0.4 KB)