[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]

Other

udemy postgresql bootcamp beginner advanced

Seeders

Leechers

19.7 GB

Size

1260

Files

Magnet Download Download .torrent

Torrent Information

Details

Total Size

19.7 GB

Active Seeds

Total Peers

Downloads

Global Parameters

Added on

8/20/2021

Last Activity

1/23/2022

Health Status

Poor

Identification Hash

B2E0C657EB287DFD4133F18CB80B69E4D3BA87BF

Community Trust & Feedback

Reputation Score

100% Positive Rating

Verified

0 Likes

0 Dislikes

Visibility

High Ranking Content

Report Content

Files (1260)

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]

1260 files • 19.7 GB

29 Using regular expressions for text patterns

18 files • 397.27 MB

005 SUBSTRING with regular expressions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.mp4

195.75 MB

006 REGEXP_MATCHES Function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.mp4

39.59 MB

002 Regular expressions notations table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/002 Regular expressions notations table.mp4

37.32 MB

007 REGEXP_REPLACE Function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.mp4

30.8 MB

003 SIMILAR TO operator.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/003 SIMILAR TO operator.mp4

29.04 MB

001 Text to structured data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/001 Text to structured data.mp4

23.69 MB

004 POSIX regular expressions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/004 POSIX regular expressions.mp4

22.3 MB

009 REGEXP_SPLIT_TO_ARRAY function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.mp4

12.96 MB

008 REGEXP_SPLIT_TO_TABLE Function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.mp4

5.71 MB

005 SUBSTRING with regular expressions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.en.srt

27.93 KB

006 REGEXP_MATCHES Function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.en.srt

14.53 KB

002 Regular expressions notations table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/002 Regular expressions notations table.en.srt

13.15 KB

007 REGEXP_REPLACE Function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.en.srt

13.04 KB

003 SIMILAR TO operator.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/003 SIMILAR TO operator.en.srt

10.6 KB

001 Text to structured data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/001 Text to structured data.en.srt

8.88 KB

004 POSIX regular expressions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/004 POSIX regular expressions.en.srt

7.44 KB

009 REGEXP_SPLIT_TO_ARRAY function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.en.srt

4.18 KB

008 REGEXP_SPLIT_TO_TABLE Function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.en.srt

2.19 KB

28 Window Functions

85 files • 1.43 GB

015 Understanding window frames.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/015 Understanding window frames.mp4

185.12 MB

002 Analyze Global Trades Data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/002 Analyze Global Trades Data.mp4

96.75 MB

013 Ordering inside window.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/013 Ordering inside window.mp4

79.2 MB

022 FIRST_VALUE, LAST_VALUE and NTH_value functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.mp4

77.75 MB

021 LEAD and LAG functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/021 LEAD and LAG functions.mp4

72.96 MB

016 ROWS and RANGE indicators.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/016 ROWS and RANGE indicators.mp4

61.31 MB

023 ROW_NUMBER function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/023 ROW_NUMBER function.mp4

53.81 MB

003 Using aggregate functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/003 Using aggregate functions.mp4

47.62 MB

034 Comparing with least number.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/034 Comparing with least number.mp4

47.02 MB

025 ROW_NUMBER() - Window with Partition datasets.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.mp4

44.15 MB

020 NTILE function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/020 NTILE function.mp4

38.08 MB

017 Using WINDOW.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/017 Using WINDOW.mp4

35.79 MB

029 ROW_NUMBER() - Pagination technique.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/029 ROW_NUMBER() - Pagination technique.mp4

35.29 MB

014 Sliding dynamic windows.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/014 Sliding dynamic windows.mp4

31.96 MB

011 Partitioning the data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/011 Partitioning the data.mp4

27.74 MB

039 Using PARTITION BY for group averages.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/039 Using PARTITION BY for group averages.mp4

26.78 MB

028 ROW_NUMBER() - Find DISTINCT with subquery.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.mp4

26.66 MB

031 Calculate difference compared to average.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/031 Calculate difference compared to average.mp4

25.36 MB

041 Using WITH clause to set ORDER BY values.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/041 Using WITH clause to set ORDER BY values.mp4

25.32 MB

030 Using OVER() to calculate percentage.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/030 Using OVER() to calculate percentage.mp4

24.68 MB

042 DELETE and INSERT in one query using WITH.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/042 DELETE and INSERT in one query using WITH.mp4

23.2 MB

024 Finding Correlations.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/024 Finding Correlations.mp4

22.68 MB

009 Using FILTER clause.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/009 Using FILTER clause.mp4

22.36 MB

008 Query performance check.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/008 Query performance check.mp4

21.71 MB

004 GROUP BY ROLLUP.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/004 GROUP BY ROLLUP.mp4

21.65 MB

033 Using LEAD to compare with next values.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/033 Using LEAD to compare with next values.mp4

21.25 MB

032 Calculating cumulative totals.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/032 Calculating cumulative totals.mp4

21.19 MB

010 Using Window Functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/010 Using Window Functions.mp4

21.09 MB

019 RANK and DENSE_RANK functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/019 RANK and DENSE_RANK functions.mp4

20.89 MB

038 Getting RANK to compute group and global ranks.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/038 Getting RANK to compute group and global ranks.mp4

20.69 MB

006 GROUP BY CUBE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/006 GROUP BY CUBE.mp4

20.08 MB

007 GROUP BY GROUPING SETS.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/007 GROUP BY GROUPING SETS.mp4

19.48 MB

018 Using WINDOW with ROWS BETWEEN.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/018 Using WINDOW with ROWS BETWEEN.mp4

18.17 MB

005 ROLLUP - Grouping multiple columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/005 ROLLUP - Grouping multiple columns.mp4

17.45 MB

036 Planning tips on using Window Functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/036 Planning tips on using Window Functions.mp4

16.81 MB

035 Window Function Summary.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/035 Window Function Summary.mp4

16.48 MB

027 ROW_NUMBER() - Find Nth record.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/027 ROW_NUMBER() - Find Nth record.mp4

15.25 MB

040 Using WITH clause to create your own data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/040 Using WITH clause to create your own data.mp4

14.23 MB

026 ROW_NUMBER() - Reverse fields with order by.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.mp4

14.15 MB

037 Difference between RANK and DENSE_RANK.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/037 Difference between RANK and DENSE_RANK.mp4

12.04 MB

012 Set data into millions format.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/012 Set data into millions format.mp4

11.01 MB

001 Introduction to Window Functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/001 Introduction to Window Functions.mp4

6.29 MB

331 trades.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/331 trades.sql

510.16 KB

015 Understanding window frames.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/015 Understanding window frames.en.srt

33.06 KB

021 LEAD and LAG functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/021 LEAD and LAG functions.en.srt

21.76 KB

022 FIRST_VALUE, LAST_VALUE and NTH_value functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.en.srt

21.03 KB

016 ROWS and RANGE indicators.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/016 ROWS and RANGE indicators.en.srt

15.82 KB

025 ROW_NUMBER() - Window with Partition datasets.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.en.srt

14.22 KB

023 ROW_NUMBER function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/023 ROW_NUMBER function.en.srt

13.66 KB

020 NTILE function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/020 NTILE function.en.srt

13.47 KB

017 Using WINDOW.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/017 Using WINDOW.en.srt

13.39 KB

034 Comparing with least number.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/034 Comparing with least number.en.srt

13.34 KB

003 Using aggregate functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/003 Using aggregate functions.en.srt

12.41 KB

013 Ordering inside window.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/013 Ordering inside window.en.srt

11.9 KB

002 Analyze Global Trades Data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/002 Analyze Global Trades Data.en.srt

11.56 KB

014 Sliding dynamic windows.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/014 Sliding dynamic windows.en.srt

11.44 KB

036 Planning tips on using Window Functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/036 Planning tips on using Window Functions.en.srt

10.08 KB

041 Using WITH clause to set ORDER BY values.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/041 Using WITH clause to set ORDER BY values.en.srt

9.84 KB

029 ROW_NUMBER() - Pagination technique.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/029 ROW_NUMBER() - Pagination technique.en.srt

8.88 KB

033 Using LEAD to compare with next values.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/033 Using LEAD to compare with next values.en.srt

8.63 KB

030 Using OVER() to calculate percentage.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/030 Using OVER() to calculate percentage.en.srt

8.6 KB

039 Using PARTITION BY for group averages.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/039 Using PARTITION BY for group averages.en.srt

8.57 KB

024 Finding Correlations.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/024 Finding Correlations.en.srt

8.56 KB

031 Calculate difference compared to average.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/031 Calculate difference compared to average.en.srt

8.53 KB

032 Calculating cumulative totals.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/032 Calculating cumulative totals.en.srt

8.01 KB

042 DELETE and INSERT in one query using WITH.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/042 DELETE and INSERT in one query using WITH.en.srt

7.82 KB

004 GROUP BY ROLLUP.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/004 GROUP BY ROLLUP.en.srt

7.74 KB

019 RANK and DENSE_RANK functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/019 RANK and DENSE_RANK functions.en.srt

7.67 KB

009 Using FILTER clause.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/009 Using FILTER clause.en.srt

7.65 KB

010 Using Window Functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/010 Using Window Functions.en.srt

7.48 KB

008 Query performance check.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/008 Query performance check.en.srt

7.45 KB

028 ROW_NUMBER() - Find DISTINCT with subquery.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.en.srt

7.2 KB

006 GROUP BY CUBE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/006 GROUP BY CUBE.en.srt

7.11 KB

035 Window Function Summary.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/035 Window Function Summary.en.srt

6.85 KB

011 Partitioning the data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/011 Partitioning the data.en.srt

6.76 KB

038 Getting RANK to compute group and global ranks.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/038 Getting RANK to compute group and global ranks.en.srt

6.48 KB

005 ROLLUP - Grouping multiple columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/005 ROLLUP - Grouping multiple columns.en.srt

5.63 KB

040 Using WITH clause to create your own data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/040 Using WITH clause to create your own data.en.srt

5.56 KB

007 GROUP BY GROUPING SETS.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/007 GROUP BY GROUPING SETS.en.srt

5.38 KB

027 ROW_NUMBER() - Find Nth record.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/027 ROW_NUMBER() - Find Nth record.en.srt

5.33 KB

018 Using WINDOW with ROWS BETWEEN.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/018 Using WINDOW with ROWS BETWEEN.en.srt

5.15 KB

001 Introduction to Window Functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/001 Introduction to Window Functions.en.srt

5.07 KB

037 Difference between RANK and DENSE_RANK.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/037 Difference between RANK and DENSE_RANK.en.srt

4.13 KB

012 Set data into millions format.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/012 Set data into millions format.en.srt

3.81 KB

026 ROW_NUMBER() - Reverse fields with order by.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.en.srt

3.41 KB

44 Managing PostgreSQL security

30 files • 587.29 MB

009 Row Level Security.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/009 Row Level Security.mp4

169.35 MB

007 Table Level Security.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/007 Table Level Security.mp4

70.47 MB

015 Encrypted data in columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/015 Encrypted data in columns.mp4

69.73 MB

006 Schema Level Security.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/006 Schema Level Security.mp4

48.85 MB

008 Column Level Security.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/008 Column Level Security.mp4

34.98 MB

010 Using CURRENT_USER with RLS.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.mp4

25.54 MB

013 Inspecting permissions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/013 Inspecting permissions.mp4

24.4 MB

005 Database Level Security.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/005 Database Level Security.mp4

23.32 MB

011 Row level policy for application users.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/011 Row level policy for application users.mp4

22.97 MB

002 Instance Level Security.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/002 Instance Level Security.mp4

22.97 MB

014 Row Level Security Performance.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/014 Row Level Security Performance.mp4

20.31 MB

003 Instance Level Security - Add users to roles.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.mp4

18.4 MB

004 Use pgAdmin to create roles.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/004 Use pgAdmin to create roles.mp4

14.03 MB

001 Security concepts and and levels.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/001 Security concepts and and levels.mp4

11.81 MB

012 DROP a policy.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/012 DROP a policy.mp4

10.03 MB

009 Row Level Security.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/009 Row Level Security.en.srt

20.58 KB

006 Schema Level Security.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/006 Schema Level Security.en.srt

16.35 KB

007 Table Level Security.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/007 Table Level Security.en.srt

15.42 KB

008 Column Level Security.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/008 Column Level Security.en.srt

11.76 KB

015 Encrypted data in columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/015 Encrypted data in columns.en.srt

10.91 KB

002 Instance Level Security.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/002 Instance Level Security.en.srt

8.95 KB

010 Using CURRENT_USER with RLS.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.en.srt

8.93 KB

005 Database Level Security.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/005 Database Level Security.en.srt

7.65 KB

011 Row level policy for application users.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/011 Row level policy for application users.en.srt

7.36 KB

003 Instance Level Security - Add users to roles.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.en.srt

6.27 KB

004 Use pgAdmin to create roles.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/004 Use pgAdmin to create roles.en.srt

6.07 KB

001 Security concepts and and levels.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/001 Security concepts and and levels.en.srt

6.06 KB

014 Row Level Security Performance.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/014 Row Level Security Performance.en.srt

5.77 KB

013 Inspecting permissions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/013 Inspecting permissions.en.srt

3.88 KB

012 DROP a policy.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/44 Managing PostgreSQL security/012 DROP a policy.en.srt

3.14 KB

20 PostgreSQL Schemas

20 files • 407.4 MB

005 Schema search path.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/005 Schema search path.mp4

155.25 MB

009 Compare tables and columns in two schemas.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.mp4

47.3 MB

007 Duplicate a schema along with all data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/007 Duplicate a schema along with all data.mp4

40.78 MB

010 Schemas and Privileges.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/010 Schemas and Privileges.mp4

36 MB

002 Schema Operations (Add_Alter_Delete schemas).mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).mp4

28.19 MB

001 What is a Schema_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/001 What is a Schema_.mp4

27.28 MB

003 Schema Hierarchy.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/003 Schema Hierarchy.mp4

26.73 MB

008 What is a system catalog schema_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/008 What is a system catalog schema_.mp4

26.37 MB

004 Move a table to a new schema.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/004 Move a table to a new schema.mp4

10.87 MB

006 Alter a schema ownership.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/006 Alter a schema ownership.mp4

8.53 MB

005 Schema search path.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/005 Schema search path.en.srt

20.43 KB

009 Compare tables and columns in two schemas.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.en.srt

11.41 KB

002 Schema Operations (Add_Alter_Delete schemas).en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).en.srt

10.88 KB

003 Schema Hierarchy.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/003 Schema Hierarchy.en.srt

9.59 KB

010 Schemas and Privileges.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/010 Schemas and Privileges.en.srt

9.5 KB

007 Duplicate a schema along with all data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/007 Duplicate a schema along with all data.en.srt

9.2 KB

001 What is a Schema_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/001 What is a Schema_.en.srt

9.13 KB

008 What is a system catalog schema_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/008 What is a system catalog schema_.en.srt

6.53 KB

004 Move a table to a new schema.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/004 Move a table to a new schema.en.srt

4.52 KB

006 Alter a schema ownership.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/20 PostgreSQL Schemas/006 Alter a schema ownership.en.srt

2.94 KB

30 Powerful text searches in PostgreSQL

15 files • 424.68 MB

003 Using tsquery with operators.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.mp4

150.2 MB

004 Full text search within a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/004 Full text search within a table.mp4

63.55 MB

002 Introducing tsvector.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/002 Introducing tsvector.mp4

52.25 MB

005 Setup presidents speeches data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.mp4

46.42 MB

001 The Good Ol' Text Search.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.mp4

44.28 MB

006 Analyzing presidents speeches text data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.mp4

42.94 MB

007 Ranking and Normalizing text results.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.mp4

23.82 MB

385 president_speeches.csv

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/385 president_speeches.csv

1.12 MB

003 Using tsquery with operators.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.en.srt

21.67 KB

004 Full text search within a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/004 Full text search within a table.en.srt

20.37 KB

002 Introducing tsvector.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/002 Introducing tsvector.en.srt

17.38 KB

001 The Good Ol' Text Search.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.en.srt

12.4 KB

006 Analyzing presidents speeches text data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.en.srt

11.62 KB

005 Setup presidents speeches data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.en.srt

9.61 KB

007 Ranking and Normalizing text results.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.en.srt

7.74 KB

33 Functions with SQL language

38 files • 834.28 MB

009 Function using parameters Part 3.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/009 Function using parameters Part 3.mp4

132.86 MB

010 Function using parameters Part 4.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/010 Function using parameters Part 4.mp4

80.29 MB

007 Function using parameters.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/007 Function using parameters.mp4

75.52 MB

011 Function returning a composite.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/011 Function returning a composite.mp4

67.81 MB

015 Function as a table source.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/015 Function as a table source.mp4

55.42 MB

012 Function returning multiple rows.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/012 Function returning multiple rows.mp4

55.17 MB

001 Creating our first SQL function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/001 Creating our first SQL function.mp4

50.19 MB

004 Function returning a single value.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/004 Function returning a single value.mp4

50.18 MB

017 Function parameters with default values.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/017 Function parameters with default values.mp4

45.21 MB

018 Function based on views.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/018 Function based on views.mp4

32.64 MB

005 Function returning a single value Part 2.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/005 Function returning a single value Part 2.mp4

28.68 MB

008 Function using parameters Part 2.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/008 Function using parameters Part 2.mp4

28.44 MB

006 Function returning a single value Part 3.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/006 Function returning a single value Part 3.mp4

26.35 MB

003 Function returning no values.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/003 Function returning no values.mp4

22.58 MB

019 Drop a function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/019 Drop a function.mp4

18.46 MB

013 Function - order matters!.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/013 Function - order matters!.mp4

16.69 MB

016 Function parameter modes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/016 Function parameter modes.mp4

16.68 MB

002 Introducing dollar quoting.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/002 Introducing dollar quoting.mp4

16.18 MB

014 Function returning a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/014 Function returning a table.mp4

14.7 MB

007 Function using parameters.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/007 Function using parameters.en.srt

19.76 KB

009 Function using parameters Part 3.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/009 Function using parameters Part 3.en.srt

19.63 KB

010 Function using parameters Part 4.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/010 Function using parameters Part 4.en.srt

18.59 KB

011 Function returning a composite.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/011 Function returning a composite.en.srt

17.9 KB

004 Function returning a single value.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/004 Function returning a single value.en.srt

17.76 KB

017 Function parameters with default values.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/017 Function parameters with default values.en.srt

16.39 KB

001 Creating our first SQL function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/001 Creating our first SQL function.en.srt

15.38 KB

015 Function as a table source.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/015 Function as a table source.en.srt

13.92 KB

012 Function returning multiple rows.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/012 Function returning multiple rows.en.srt

12.23 KB

018 Function based on views.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/018 Function based on views.en.srt

9.37 KB

005 Function returning a single value Part 2.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/005 Function returning a single value Part 2.en.srt

7.72 KB

008 Function using parameters Part 2.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/008 Function using parameters Part 2.en.srt

7.55 KB

003 Function returning no values.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/003 Function returning no values.en.srt

7.13 KB

019 Drop a function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/019 Drop a function.en.srt

6.84 KB

002 Introducing dollar quoting.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/002 Introducing dollar quoting.en.srt

5.61 KB

006 Function returning a single value Part 3.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/006 Function returning a single value Part 3.en.srt

4.78 KB

013 Function - order matters!.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/013 Function - order matters!.en.srt

4.2 KB

016 Function parameter modes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/016 Function parameter modes.en.srt

4.2 KB

014 Function returning a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/33 Functions with SQL language/014 Function returning a table.en.srt

3.88 KB

31 Table Partitions

34 files • 798.1 MB

006 Partition by List.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/006 Partition by List.mp4

130.72 MB

005 Partition by Range.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/005 Partition by Range.mp4

102.76 MB

002 When a partition can be used_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/002 When a partition can be used_.mp4

86.44 MB

003 Table inheritance.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/003 Table inheritance.mp4

66.59 MB

007 Partition by Hash.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/007 Partition by Hash.mp4

63.02 MB

009 Multi-level partitioning.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/009 Multi-level partitioning.mp4

62.36 MB

011 ALTERing the partition bounds.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/011 ALTERing the partition bounds.mp4

38.5 MB

008 DEFAULT Partition.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/008 DEFAULT Partition.mp4

33.18 MB

014 Determining a field for partition over.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/014 Determining a field for partition over.mp4

32.52 MB

012 Partition Indexes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/012 Partition Indexes.mp4

31.69 MB

001 What is a partition.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/001 What is a partition.mp4

26.83 MB

010 Partition maintenance.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/010 Partition maintenance.mp4

26.72 MB

015 Sizing the partition.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/015 Sizing the partition.mp4

22.65 MB

016 Partitioning Advantages.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/016 Partitioning Advantages.mp4

22.1 MB

017 Common partitioning mistakes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/017 Common partitioning mistakes.mp4

21.64 MB

013 Partition pruning.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/013 Partition pruning.mp4

18.05 MB

004 Partition types.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/004 Partition types.mp4

12.07 MB

006 Partition by List.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/006 Partition by List.en.srt

36.94 KB

005 Partition by Range.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/005 Partition by Range.en.srt

30.15 KB

002 When a partition can be used_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/002 When a partition can be used_.en.srt

28.04 KB

003 Table inheritance.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/003 Table inheritance.en.srt

23.92 KB

007 Partition by Hash.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/007 Partition by Hash.en.srt

22.13 KB

009 Multi-level partitioning.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/009 Multi-level partitioning.en.srt

20.75 KB

011 ALTERing the partition bounds.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/011 ALTERing the partition bounds.en.srt

12.88 KB

014 Determining a field for partition over.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/014 Determining a field for partition over.en.srt

11.68 KB

012 Partition Indexes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/012 Partition Indexes.en.srt

10.73 KB

015 Sizing the partition.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/015 Sizing the partition.en.srt

9.44 KB

008 DEFAULT Partition.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/008 DEFAULT Partition.en.srt

9.35 KB

001 What is a partition.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/001 What is a partition.en.srt

8.04 KB

010 Partition maintenance.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/010 Partition maintenance.en.srt

7.13 KB

017 Common partitioning mistakes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/017 Common partitioning mistakes.en.srt

7.1 KB

016 Partitioning Advantages.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/016 Partitioning Advantages.en.srt

7.01 KB

013 Partition pruning.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/013 Partition pruning.en.srt

5.63 KB

004 Partition types.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/31 Table Partitions/004 Partition types.en.srt

4.02 KB

23 Indexes and Performance Optimization

66 files • 1.25 GB

030 Expression Index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/030 Expression Index.mp4

120.06 MB

027 Using organized vs random data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/027 Using organized vs random data.mp4

99.66 MB

032 Invalidating an index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/032 Invalidating an index.mp4

98.9 MB

002 Create an index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/002 Create an index.mp4

77.79 MB

019 The EXPLAIN statement.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/019 The EXPLAIN statement.mp4

74.74 MB

023 Index are not free.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/023 Index are not free.mp4

58.7 MB

003 Create unique indexes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/003 Create unique indexes.mp4

57.3 MB

022 Understanding query cost model.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/022 Understanding query cost model.mp4

56.56 MB

029 Partial indexes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/029 Partial indexes.mp4

55.83 MB

013 Index Nodes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/013 Index Nodes.mp4

41.9 MB

021 Using EXPLAIN ANALYZE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.mp4

39.23 MB

014 Join Nodes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/014 Join Nodes.mp4

37.11 MB

012 Sequential Nodes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/012 Sequential Nodes.mp4

36.48 MB

024 Indexes for sorted output.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/024 Indexes for sorted output.mp4

36.01 MB

010 The query optimizer.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/010 The query optimizer.mp4

34.85 MB

025 Using multiple indexes on a single query.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.mp4

32.43 MB

033 Rebuilding an index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/033 Rebuilding an index.mp4

29.46 MB

026 Execution plans depends on input values.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/026 Execution plans depends on input values.mp4

28.4 MB

009 SQL statement execution stages.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/009 SQL statement execution stages.mp4

28.13 MB

016 Hash Index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/016 Hash Index.mp4

24.25 MB

011 Optimizer node types.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/011 Optimizer node types.mp4

22.76 MB

005 Size of the table index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/005 Size of the table index.mp4

20.28 MB

006 List counts of all indexes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/006 List counts of all indexes.mp4

20.13 MB

015 Index Types - B-Tree Index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.mp4

19.45 MB

001 What is an index_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/001 What is an index_.mp4

18.21 MB

008 SQL Statement execution process.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/008 SQL Statement execution process.mp4

18.08 MB

004 List all indexes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/004 List all indexes.mp4

17.75 MB

028 Try to use index only scan.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/028 Try to use index only scan.mp4

16.37 MB

007 Drop a index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/007 Drop a index.mp4

14.99 MB

020 EXPLAIN output options.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/020 EXPLAIN output options.mp4

11.91 MB

031 Adding data while indexing.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/031 Adding data while indexing.mp4

11.62 MB

017 BRIN index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/017 BRIN index.mp4

8.94 MB

018 GIN Index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/018 GIN Index.mp4

7.05 MB

027 Using organized vs random data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/027 Using organized vs random data.en.srt

27.81 KB

002 Create an index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/002 Create an index.en.srt

22.9 KB

019 The EXPLAIN statement.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/019 The EXPLAIN statement.en.srt

22.53 KB

030 Expression Index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/030 Expression Index.en.srt

22.2 KB

022 Understanding query cost model.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/022 Understanding query cost model.en.srt

19.51 KB

023 Index are not free.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/023 Index are not free.en.srt

17.61 KB

029 Partial indexes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/029 Partial indexes.en.srt

14.85 KB

003 Create unique indexes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/003 Create unique indexes.en.srt

14.67 KB

021 Using EXPLAIN ANALYZE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.en.srt

14.28 KB

024 Indexes for sorted output.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/024 Indexes for sorted output.en.srt

12.59 KB

010 The query optimizer.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/010 The query optimizer.en.srt

12.25 KB

032 Invalidating an index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/032 Invalidating an index.en.srt

12.15 KB

025 Using multiple indexes on a single query.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.en.srt

11.83 KB

013 Index Nodes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/013 Index Nodes.en.srt

10.65 KB

033 Rebuilding an index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/033 Rebuilding an index.en.srt

10.58 KB

026 Execution plans depends on input values.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/026 Execution plans depends on input values.en.srt

9.74 KB

014 Join Nodes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/014 Join Nodes.en.srt

9.35 KB

009 SQL statement execution stages.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/009 SQL statement execution stages.en.srt

8.89 KB

012 Sequential Nodes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/012 Sequential Nodes.en.srt

8.73 KB

011 Optimizer node types.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/011 Optimizer node types.en.srt

7.78 KB

005 Size of the table index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/005 Size of the table index.en.srt

7.19 KB

006 List counts of all indexes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/006 List counts of all indexes.en.srt

6.58 KB

015 Index Types - B-Tree Index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.en.srt

6.19 KB

016 Hash Index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/016 Hash Index.en.srt

6.18 KB

008 SQL Statement execution process.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/008 SQL Statement execution process.en.srt

6.07 KB

028 Try to use index only scan.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/028 Try to use index only scan.en.srt

6.07 KB

004 List all indexes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/004 List all indexes.en.srt

5.97 KB

001 What is an index_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/001 What is an index_.en.srt

5.62 KB

007 Drop a index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/007 Drop a index.en.srt

5.4 KB

031 Adding data while indexing.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/031 Adding data while indexing.en.srt

4.44 KB

020 EXPLAIN output options.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/020 EXPLAIN output options.en.srt

4.36 KB

017 BRIN index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/017 BRIN index.en.srt

2.92 KB

018 GIN Index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/23 Indexes and Performance Optimization/018 GIN Index.en.srt

2.37 KB

48 Extended PostgreSQL

4 files • 166.72 MB

001 Create a custom index method.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/48 Extended PostgreSQL/001 Create a custom index method.mp4

119.53 MB

002 Create a user-defined aggregate function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/48 Extended PostgreSQL/002 Create a user-defined aggregate function.mp4

47.15 MB

001 Create a custom index method.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/48 Extended PostgreSQL/001 Create a custom index method.en.srt

28.7 KB

002 Create a user-defined aggregate function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/48 Extended PostgreSQL/002 Create a user-defined aggregate function.en.srt

17.67 KB

16 Using DATE_TIME functions

46 files • 877.79 MB

022 date_part function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/022 date_part function.mp4

119.18 MB

004 Strings to Dates conversions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/004 Strings to Dates conversions.mp4

61.01 MB

006 Formatting Dates.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/006 Formatting Dates.mp4

60.86 MB

021 How to handle timezones.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/021 How to handle timezones.mp4

60.64 MB

009 Using MAKE_TIMESTAMPTZ function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.mp4

57.78 MB

023 date_trunc function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/023 date_trunc function.mp4

48.22 MB

011 Using math operators with dates.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/011 Using math operators with dates.mp4

46.76 MB

001 Datetimes data types.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/001 Datetimes data types.mp4

44.3 MB

019 Using Date, time, timestamp in tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.mp4

44.05 MB

005 Using TO_TIMESTAMP function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.mp4

43.94 MB

018 Date accuracy with EPOCH.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/018 Date accuracy with EPOCH.mp4

38.83 MB

008 Using MAKE_INTERVAL function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.mp4

37.11 MB

010 Date Value Extractors functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/010 Date Value Extractors functions.mp4

36.21 MB

007 Date construction functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/007 Date construction functions.mp4

26.9 MB

013 Date _ Time Functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/013 Date _ Time Functions.mp4

26.76 MB

003 Time of day formats and inputs.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/003 Time of day formats and inputs.mp4

24.67 MB

017 CURRENT_TIME function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/017 CURRENT_TIME function.mp4

18.82 MB

014 PostgreSQL Date _ Time Functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.mp4

18.66 MB

012 OVERLAPS Operator.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/012 OVERLAPS Operator.mp4

16.22 MB

020 View and set timezones.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/020 View and set timezones.mp4

15.02 MB

015 AGE function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/015 AGE function.mp4

14.14 MB

002 System Month Date settings.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/002 System Month Date settings.mp4

12.84 MB

016 CURRENT_DATE function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/016 CURRENT_DATE function.mp4

4.64 MB

004 Strings to Dates conversions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/004 Strings to Dates conversions.en.srt

17.57 KB

022 date_part function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/022 date_part function.en.srt

16.97 KB

006 Formatting Dates.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/006 Formatting Dates.en.srt

16.1 KB

021 How to handle timezones.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/021 How to handle timezones.en.srt

15.55 KB

011 Using math operators with dates.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/011 Using math operators with dates.en.srt

15.26 KB

009 Using MAKE_TIMESTAMPTZ function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.en.srt

14.83 KB

005 Using TO_TIMESTAMP function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.en.srt

14.77 KB

001 Datetimes data types.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/001 Datetimes data types.en.srt

14.07 KB

023 date_trunc function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/023 date_trunc function.en.srt

13.09 KB

019 Using Date, time, timestamp in tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.en.srt

13.02 KB

018 Date accuracy with EPOCH.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/018 Date accuracy with EPOCH.en.srt

10.77 KB

008 Using MAKE_INTERVAL function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.en.srt

9.87 KB

007 Date construction functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/007 Date construction functions.en.srt

9.87 KB

010 Date Value Extractors functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/010 Date Value Extractors functions.en.srt

9.22 KB

003 Time of day formats and inputs.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/003 Time of day formats and inputs.en.srt

9.14 KB

013 Date _ Time Functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/013 Date _ Time Functions.en.srt

8.3 KB

014 PostgreSQL Date _ Time Functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.en.srt

6.65 KB

012 OVERLAPS Operator.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/012 OVERLAPS Operator.en.srt

6.14 KB

020 View and set timezones.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/020 View and set timezones.en.srt

5.48 KB

015 AGE function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/015 AGE function.en.srt

5.3 KB

017 CURRENT_TIME function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/017 CURRENT_TIME function.en.srt

5.03 KB

002 System Month Date settings.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/002 System Month Date settings.en.srt

4.53 KB

016 CURRENT_DATE function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/16 Using DATE_TIME functions/016 CURRENT_DATE function.en.srt

1.89 KB

27 Grouping sets

8 files • 275.77 MB

002 Subtotals on group sets.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/27 Grouping sets/002 Subtotals on group sets.mp4

114.61 MB

004 Using GROUPING with ROLLUP.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/27 Grouping sets/004 Using GROUPING with ROLLUP.mp4

112.57 MB

003 Adding subtotal with ROLLUP.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/27 Grouping sets/003 Adding subtotal with ROLLUP.mp4

32.51 MB

001 Introduction to summarization.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/27 Grouping sets/001 Introduction to summarization.mp4

16.02 MB

004 Using GROUPING with ROLLUP.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/27 Grouping sets/004 Using GROUPING with ROLLUP.en.srt

21.26 KB

002 Subtotals on group sets.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/27 Grouping sets/002 Subtotals on group sets.en.srt

17.54 KB

003 Adding subtotal with ROLLUP.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/27 Grouping sets/003 Adding subtotal with ROLLUP.en.srt

11.13 KB

001 Introduction to summarization.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/27 Grouping sets/001 Introduction to summarization.en.srt

4.78 KB

37 Using Cursors

20 files • 346.82 MB

010 Using a parametric cursor via function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/010 Using a parametric cursor via function.mp4

92.26 MB

009 Creating a PL_PGSQL Cursor.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/009 Creating a PL_PGSQL Cursor.mp4

45.77 MB

001 Understanding row by row operations.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/001 Understanding row by row operations.mp4

42.86 MB

005 Opening a cursor.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/005 Opening a cursor.mp4

42.63 MB

006 Using a cursor.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/006 Using a cursor.mp4

37.47 MB

004 Creating a cursor.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/004 Creating a cursor.mp4

35.27 MB

002 Cursors and procedural languages.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/002 Cursors and procedural languages.mp4

23.43 MB

003 Steps to create a cursor.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/003 Steps to create a cursor.mp4

13.53 MB

007 Updating data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/007 Updating data.mp4

7.65 MB

008 Closing a cursor.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/008 Closing a cursor.mp4

5.85 MB

010 Using a parametric cursor via function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/010 Using a parametric cursor via function.en.srt

20 KB

009 Creating a PL_PGSQL Cursor.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/009 Creating a PL_PGSQL Cursor.en.srt

14.91 KB

005 Opening a cursor.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/005 Opening a cursor.en.srt

14.1 KB

004 Creating a cursor.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/004 Creating a cursor.en.srt

13.02 KB

001 Understanding row by row operations.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/001 Understanding row by row operations.en.srt

9.68 KB

006 Using a cursor.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/006 Using a cursor.en.srt

9.38 KB

002 Cursors and procedural languages.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/002 Cursors and procedural languages.en.srt

7.11 KB

003 Steps to create a cursor.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/003 Steps to create a cursor.en.srt

3.94 KB

007 Updating data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/007 Updating data.en.srt

2.37 KB

008 Closing a cursor.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/37 Using Cursors/008 Closing a cursor.en.srt

2.09 KB

06 Filtering Data

34 files • 741.41 MB

009 Using Logical operators.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/009 Using Logical operators.mp4

90.42 MB

010 Using LIMIT and OFFSET.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/010 Using LIMIT and OFFSET.mp4

88.95 MB

014 Using LIKE and ILIKE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/014 Using LIKE and ILIKE.mp4

88.04 MB

011 Using FETCH.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/011 Using FETCH.mp4

83.8 MB

012 Using IN, NOT IN.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/012 Using IN, NOT IN.mp4

68.53 MB

002 AND operator.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/002 AND operator.mp4

61.62 MB

015 Using IS NULL and IS NOT NULL keywords.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.mp4

61.4 MB

013 Using BETWEEN and NOT BETWEEN.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.mp4

50.7 MB

016 Concatenation techniques.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/016 Concatenation techniques.mp4

34.08 MB

004 Combining AND, OR operators.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/004 Combining AND, OR operators.mp4

32.21 MB

017 Concatenation with __, CONCAT and CONCAT_WS.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.mp4

18.17 MB

003 OR operator.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/003 OR operator.mp4

15.71 MB

005 What goes before and after WHERE clause.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/005 What goes before and after WHERE clause.mp4

14.24 MB

006 Execution order with AND, OR operators.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/006 Execution order with AND, OR operators.mp4

9.35 MB

007 Can we use column aliases with WHERE_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/007 Can we use column aliases with WHERE_.mp4

9.16 MB

001 Comparison, Logical and Arithmetic operators.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/001 Comparison, Logical and Arithmetic operators.mp4

8.55 MB

008 Order of execution of WHERE, SELECT and ORDER BY clauses.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.mp4

6.31 MB

014 Using LIKE and ILIKE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/014 Using LIKE and ILIKE.en.srt

25.58 KB

010 Using LIMIT and OFFSET.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/010 Using LIMIT and OFFSET.en.srt

24.98 KB

009 Using Logical operators.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/009 Using Logical operators.en.srt

23.5 KB

015 Using IS NULL and IS NOT NULL keywords.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.en.srt

16.9 KB

013 Using BETWEEN and NOT BETWEEN.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.en.srt

14.67 KB

011 Using FETCH.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/011 Using FETCH.en.srt

13.85 KB

012 Using IN, NOT IN.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/012 Using IN, NOT IN.en.srt

12.99 KB

016 Concatenation techniques.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/016 Concatenation techniques.en.srt

11.1 KB

002 AND operator.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/002 AND operator.en.srt

10.73 KB

004 Combining AND, OR operators.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/004 Combining AND, OR operators.en.srt

6.89 KB

017 Concatenation with __, CONCAT and CONCAT_WS.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.en.srt

6.15 KB

003 OR operator.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/003 OR operator.en.srt

4.7 KB

005 What goes before and after WHERE clause.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/005 What goes before and after WHERE clause.en.srt

3.84 KB

007 Can we use column aliases with WHERE_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/007 Can we use column aliases with WHERE_.en.srt

3.4 KB

001 Comparison, Logical and Arithmetic operators.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/001 Comparison, Logical and Arithmetic operators.en.srt

2.99 KB

006 Execution order with AND, OR operators.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/006 Execution order with AND, OR operators.en.srt

2.26 KB

008 Order of execution of WHERE, SELECT and ORDER BY clauses.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.en.srt

1.82 KB

38 Creating Crosstab Reports

28 files • 569.33 MB

011 Dynamic pivot table columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/011 Dynamic pivot table columns.mp4

90.35 MB

012 Interactive client-side pivot.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/012 Interactive client-side pivot.mp4

77.88 MB

013 Handling missing values.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/013 Handling missing values.mp4

62.27 MB

003 Creating a crosstab report - Student Rankings.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.mp4

61.87 MB

008 Aggregate over filter.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/008 Aggregate over filter.mp4

57.54 MB

005 Pivoting with Rainfalls data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.mp4

46.07 MB

007 Matrix report via a query.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/007 Matrix report via a query.mp4

42.26 MB

010 Dynamic pivot query via JSON.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.mp4

40.65 MB

009 Static to dynamic pivots.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/009 Static to dynamic pivots.mp4

28.93 MB

006 Pivoting rows and columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/006 Pivoting rows and columns.mp4

21.39 MB

001 What is a crosstab report.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/001 What is a crosstab report.mp4

19.67 MB

004 Orders matters in crosstab reports.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/004 Orders matters in crosstab reports.mp4

12.47 MB

002 Installing the tablefunc extension.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/002 Installing the tablefunc extension.mp4

7.82 MB

011 Dynamic pivot table columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/011 Dynamic pivot table columns.en.srt

24.3 KB

003 Creating a crosstab report - Student Rankings.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.en.srt

21.49 KB

013 Handling missing values.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/013 Handling missing values.en.srt

15.74 KB

005 Pivoting with Rainfalls data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.en.srt

15.35 KB

007 Matrix report via a query.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/007 Matrix report via a query.en.srt

14.26 KB

503 rainfalldata.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/503 rainfalldata.sql

10.93 KB

010 Dynamic pivot query via JSON.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.en.srt

10.31 KB

009 Static to dynamic pivots.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/009 Static to dynamic pivots.en.srt

10.24 KB

012 Interactive client-side pivot.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/012 Interactive client-side pivot.en.srt

8.86 KB

008 Aggregate over filter.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/008 Aggregate over filter.en.srt

7.6 KB

006 Pivoting rows and columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/006 Pivoting rows and columns.en.srt

6.24 KB

001 What is a crosstab report.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/001 What is a crosstab report.en.srt

5.44 KB

004 Orders matters in crosstab reports.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/004 Orders matters in crosstab reports.en.srt

4.71 KB

002 Installing the tablefunc extension.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/002 Installing the tablefunc extension.en.srt

2.62 KB

509 pivotcode.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/38 Creating Crosstab Reports/509 pivotcode.sql

948 Bytes

46 PostgreSQL Internals

23 files • 405.55 MB

604 internal - view system administration functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/604 internal - view system administration functions.mp4

89.29 MB

011 File layout of PostgreSQL Tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.mp4

75.89 MB

006 View privileges information across tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/006 View privileges information across tables.mp4

48.72 MB

002 List all database and schemas.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/002 List all database and schemas.mp4

42.89 MB

003 List all tables and views.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/003 List all tables and views.mp4

39.95 MB

007 Using system Administration functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/007 Using system Administration functions.mp4

27.82 MB

008 Show all running queries.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/008 Show all running queries.mp4

21.54 MB

001 List database users, and database sizes with and without indexes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.mp4

17.77 MB

009 Terminate running and IDLE process.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/009 Terminate running and IDLE process.mp4

11.94 MB

004 List all columns from a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/004 List all columns from a table.mp4

11.89 MB

005 View system metadata via system information functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/005 View system metadata via system information functions.mp4

11.06 MB

010 How to check live and dead rows in tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/010 How to check live and dead rows in tables.mp4

6.72 MB

011 File layout of PostgreSQL Tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.en.srt

13.85 KB

003 List all tables and views.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/003 List all tables and views.en.srt

12.69 KB

006 View privileges information across tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/006 View privileges information across tables.en.srt

11.87 KB

007 Using system Administration functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/007 Using system Administration functions.en.srt

7.92 KB

008 Show all running queries.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/008 Show all running queries.en.srt

6.46 KB

002 List all database and schemas.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/002 List all database and schemas.en.srt

6.42 KB

001 List database users, and database sizes with and without indexes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.en.srt

5.98 KB

004 List all columns from a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/004 List all columns from a table.en.srt

4.09 KB

009 Terminate running and IDLE process.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/009 Terminate running and IDLE process.en.srt

3.86 KB

005 View system metadata via system information functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/005 View system metadata via system information functions.en.srt

3.83 KB

010 How to check live and dead rows in tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/46 PostgreSQL Internals/010 How to check live and dead rows in tables.en.srt

2.25 KB

12 Explore PostgreSQL Constraints

30 files • 532.35 MB

005 PRIMARY KEY Constraints.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.mp4

89.01 MB

003 UNIQUE constraint.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/003 UNIQUE constraint.mp4

60.32 MB

006 PRIMARY KEY Constraints on multiple columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.mp4

55.75 MB

008 Tables without foreign key constraints.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.mp4

51.55 MB

002 NOT NULL constraint.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/002 NOT NULL constraint.mp4

45.36 MB

014 CHECK constraint - Add to new table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.mp4

41.96 MB

015 CHECK constraint - Add, Rename, Drop on existing table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.mp4

39.71 MB

010 Foreign keys maintains referential data integrity.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.mp4

34.21 MB

009 Creating foreign key constraints.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.mp4

32.29 MB

004 DEFAULT constraint.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/004 DEFAULT constraint.mp4

22.22 MB

001 Introduction to constraints.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/001 Introduction to constraints.mp4

17.99 MB

007 FOREIGN KEY Constraints.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.mp4

17.56 MB

012 Add or update foreign key constraint on existing table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.mp4

11.76 MB

011 Drop a constraint.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/011 Drop a constraint.mp4

7.59 MB

013 CHECK constraint - An Introduction.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.mp4

4.9 MB

005 PRIMARY KEY Constraints.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.en.srt

29.96 KB

003 UNIQUE constraint.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/003 UNIQUE constraint.en.srt

22.21 KB

006 PRIMARY KEY Constraints on multiple columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.en.srt

19.41 KB

002 NOT NULL constraint.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/002 NOT NULL constraint.en.srt

15.45 KB

014 CHECK constraint - Add to new table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.en.srt

12.18 KB

015 CHECK constraint - Add, Rename, Drop on existing table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.en.srt

11.62 KB

009 Creating foreign key constraints.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.en.srt

11 KB

010 Foreign keys maintains referential data integrity.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.en.srt

10.97 KB

008 Tables without foreign key constraints.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.en.srt

9.9 KB

007 FOREIGN KEY Constraints.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.en.srt

9.19 KB

004 DEFAULT constraint.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/004 DEFAULT constraint.en.srt

6.44 KB

001 Introduction to constraints.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/001 Introduction to constraints.en.srt

5.3 KB

012 Add or update foreign key constraint on existing table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.en.srt

3.81 KB

011 Drop a constraint.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/011 Drop a constraint.en.srt

3.01 KB

013 CHECK constraint - An Introduction.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.en.srt

2.06 KB

18 Joining Multiple Tables

41 files • 848.89 MB

007 LEFT joins Part 1.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/007 LEFT joins Part 1.mp4

87.22 MB

001 INNER joins.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/001 INNER joins.mp4

82.69 MB

020 Append tables with different columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/020 Append tables with different columns.mp4

70.75 MB

014 Joining multiple tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/014 Joining multiple tables.mp4

60.96 MB

003 INNER joins with filter data Part 1.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/003 INNER joins with filter data Part 1.mp4

56.94 MB

017 CROSS Joins.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/017 CROSS Joins.mp4

55.75 MB

011 RIGHT joins.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/011 RIGHT joins.mp4

54.47 MB

009 LEFT joins Part 3.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/009 LEFT joins Part 3.mp4

51.16 MB

002 INNER joins with USING.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/002 INNER joins with USING.mp4

50.14 MB

008 LEFT joins Part 2.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/008 LEFT joins Part 2.mp4

42.91 MB

010 LEFT joins Part 4.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/010 LEFT joins Part 4.mp4

37.55 MB

015 Self Joins Part 1.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/015 Self Joins Part 1.mp4

35.48 MB

005 INNER joins with filter data Part 3.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/005 INNER joins with filter data Part 3.mp4

32.5 MB

018 Natural Joins Part 1.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/018 Natural Joins Part 1.mp4

24.06 MB

004 INNER joins with filter data Part 2.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/004 INNER joins with filter data Part 2.mp4

22.38 MB

013 FULL Joins.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/013 FULL Joins.mp4

22.09 MB

006 INNER joins with different data type columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/006 INNER joins with different data type columns.mp4

20.49 MB

012 RIGHT joins Part 2.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/012 RIGHT joins Part 2.mp4

15.08 MB

019 Natural Joins Part 2.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/019 Natural Joins Part 2.mp4

13.15 MB

016 Self Joins Part 2.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/016 Self Joins Part 2.mp4

12.92 MB

001 INNER joins.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/001 INNER joins.en.srt

29.24 KB

020 Append tables with different columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/020 Append tables with different columns.en.srt

18.34 KB

017 CROSS Joins.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/017 CROSS Joins.en.srt

14.42 KB

011 RIGHT joins.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/011 RIGHT joins.en.srt

14.35 KB

007 LEFT joins Part 1.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/007 LEFT joins Part 1.en.srt

13.07 KB

003 INNER joins with filter data Part 1.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/003 INNER joins with filter data Part 1.en.srt

12.95 KB

014 Joining multiple tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/014 Joining multiple tables.en.srt

12.22 KB

002 INNER joins with USING.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/002 INNER joins with USING.en.srt

11.93 KB

015 Self Joins Part 1.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/015 Self Joins Part 1.en.srt

11.76 KB

009 LEFT joins Part 3.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/009 LEFT joins Part 3.en.srt

11.72 KB

008 LEFT joins Part 2.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/008 LEFT joins Part 2.en.srt

10.15 KB

010 LEFT joins Part 4.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/010 LEFT joins Part 4.en.srt

8.17 KB

018 Natural Joins Part 1.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/018 Natural Joins Part 1.en.srt

8.09 KB

005 INNER joins with filter data Part 3.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/005 INNER joins with filter data Part 3.en.srt

7 KB

013 FULL Joins.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/013 FULL Joins.en.srt

6.98 KB

006 INNER joins with different data type columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/006 INNER joins with different data type columns.en.srt

6.74 KB

004 INNER joins with filter data Part 2.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/004 INNER joins with filter data Part 2.en.srt

5.47 KB

016 Self Joins Part 2.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/016 Self Joins Part 2.en.srt

4.71 KB

012 RIGHT joins Part 2.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/012 RIGHT joins Part 2.en.srt

4.45 KB

019 Natural Joins Part 2.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/019 Natural Joins Part 2.en.srt

3.37 KB

021 ON versus WHERE.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/18 Joining Multiple Tables/021 ON versus WHERE.html

1.92 KB

17 Grouping Data

14 files • 275.29 MB

004 Using HAVING.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/004 Using HAVING.mp4

85.07 MB

002 Using GROUP BY with multiple columns, ORDER BY.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.mp4

61.11 MB

001 Using GROUP BY.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/001 Using GROUP BY.mp4

55.77 MB

007 Handling NULL values with GROUP BY.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/007 Handling NULL values with GROUP BY.mp4

40.86 MB

006 HAVING vs WHERE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/006 HAVING vs WHERE.mp4

22.83 MB

003 Order of execution in GROUP BY clause.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/003 Order of execution in GROUP BY clause.mp4

5.48 MB

005 Order of execution in HAVING clause.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/005 Order of execution in HAVING clause.mp4

4.09 MB

002 Using GROUP BY with multiple columns, ORDER BY.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.en.srt

20.62 KB

004 Using HAVING.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/004 Using HAVING.en.srt

16.58 KB

001 Using GROUP BY.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/001 Using GROUP BY.en.srt

16.05 KB

007 Handling NULL values with GROUP BY.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/007 Handling NULL values with GROUP BY.en.srt

14.72 KB

006 HAVING vs WHERE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/006 HAVING vs WHERE.en.srt

7.84 KB

003 Order of execution in GROUP BY clause.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/003 Order of execution in GROUP BY clause.en.srt

1.99 KB

005 Order of execution in HAVING clause.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/17 Grouping Data/005 Order of execution in HAVING clause.en.srt

1.42 KB

36 PostgreSQL Triggers

47 files • 761.92 MB

014 Creating an audit trigger.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/014 Creating an audit trigger.mp4

84.59 MB

015 Creating conditional triggers.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/015 Creating conditional triggers.mp4

78.01 MB

022 Creating an audit event trigger.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/022 Creating an audit event trigger.mp4

75.2 MB

005 Pros and Cons of triggers.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/005 Pros and Cons of triggers.mp4

52.88 MB

010 Modify data at INSERT event.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/010 Modify data at INSERT event.mp4

49.46 MB

002 What is a trigger.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/002 What is a trigger.mp4

46.25 MB

008 Data auditing with a trigger.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/008 Data auditing with a trigger.mp4

45.93 MB

012 Disallow DELETE on a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/012 Disallow DELETE on a table.mp4

43.37 MB

023 Prevent schema changes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/023 Prevent schema changes.mp4

37.1 MB

009 Bind a function to a table with trigger.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/009 Bind a function to a table with trigger.mp4

35.52 MB

013 Disallow TRUNCATE on a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.mp4

30 MB

007 Steps to create a trigger.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/007 Steps to create a trigger.mp4

23.42 MB

016 Disallow data change on primary key.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/016 Disallow data change on primary key.mp4

23.3 MB

011 View triggers variables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/011 View triggers variables.mp4

22.73 MB

020 Creating event triggers.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/020 Creating event triggers.mp4

20.54 MB

021 Event trigger events and variables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/021 Event trigger events and variables.mp4

19.71 MB

017 Use triggers very cautiously.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/017 Use triggers very cautiously.mp4

14.2 MB

019 Event triggers usage scenarios.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/019 Event triggers usage scenarios.mp4

14.15 MB

003 Types of triggers.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/003 Types of triggers.mp4

11.81 MB

004 Trigger table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/004 Trigger table.mp4

11.18 MB

006 Trigger key points.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/006 Trigger key points.mp4

10.93 MB

018 What is an event trigger.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/018 What is an event trigger.mp4

7.48 MB

024 Dropping a trigger.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/024 Dropping a trigger.mp4

3.93 MB

014 Creating an audit trigger.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/014 Creating an audit trigger.en.srt

30.66 KB

022 Creating an audit event trigger.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/022 Creating an audit event trigger.en.srt

21.56 KB

015 Creating conditional triggers.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/015 Creating conditional triggers.en.srt

20.94 KB

010 Modify data at INSERT event.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/010 Modify data at INSERT event.en.srt

16.56 KB

005 Pros and Cons of triggers.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/005 Pros and Cons of triggers.en.srt

16.36 KB

008 Data auditing with a trigger.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/008 Data auditing with a trigger.en.srt

16.34 KB

012 Disallow DELETE on a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/012 Disallow DELETE on a table.en.srt

15.55 KB

002 What is a trigger.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/002 What is a trigger.en.srt

15.5 KB

009 Bind a function to a table with trigger.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/009 Bind a function to a table with trigger.en.srt

12.64 KB

023 Prevent schema changes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/023 Prevent schema changes.en.srt

11.7 KB

016 Disallow data change on primary key.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/016 Disallow data change on primary key.en.srt

8.24 KB

013 Disallow TRUNCATE on a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.en.srt

7.83 KB

011 View triggers variables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/011 View triggers variables.en.srt

7.51 KB

007 Steps to create a trigger.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/007 Steps to create a trigger.en.srt

7.38 KB

020 Creating event triggers.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/020 Creating event triggers.en.srt

6.62 KB

021 Event trigger events and variables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/021 Event trigger events and variables.en.srt

6.47 KB

017 Use triggers very cautiously.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/017 Use triggers very cautiously.en.srt

4.56 KB

019 Event triggers usage scenarios.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/019 Event triggers usage scenarios.en.srt

4.19 KB

006 Trigger key points.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/006 Trigger key points.en.srt

3.99 KB

004 Trigger table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/004 Trigger table.en.srt

3.92 KB

003 Types of triggers.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/003 Types of triggers.en.srt

3.56 KB

018 What is an event trigger.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/018 What is an event trigger.en.srt

2.46 KB

001 Introduction to triggers.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/001 Introduction to triggers.html

1.95 KB

024 Dropping a trigger.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/36 PostgreSQL Triggers/024 Dropping a trigger.en.srt

1.33 KB

45 PostgreSQL Utilities - psql

28 files • 231.33 MB

005 List all sequences, roles, data types, domain data types.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.mp4

83.5 MB

014 Turn on query execution time.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/014 Turn on query execution time.mp4

17.06 MB

010 Represent NULL values on psql terminal.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.mp4

16.03 MB

013 Represent NULL Visibly.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.mp4

16.03 MB

001 Connect to local or remote database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/001 Connect to local or remote database.mp4

15.78 MB

003 List all databases and tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/003 List all databases and tables.mp4

14.41 MB

004 List all table space, schemas, and indices.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.mp4

14.13 MB

008 Display command history, run commands from a file.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.mp4

12.41 MB

011 Make table layout funkey!.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/011 Make table layout funkey!.mp4

12.1 MB

012 Repeatedly Execute a Query.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.mp4

9.77 MB

002 Switch connection to a new database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/002 Switch connection to a new database.mp4

6.75 MB

007 Edit SQL commands in editor.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.mp4

4.98 MB

009 Built-in syntax reference for commands.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.mp4

4.39 MB

006 Describe a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/006 Describe a table.mp4

3.95 MB

005 List all sequences, roles, data types, domain data types.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.en.srt

10.65 KB

001 Connect to local or remote database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/001 Connect to local or remote database.en.srt

5.8 KB

010 Represent NULL values on psql terminal.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.en.srt

5.57 KB

013 Represent NULL Visibly.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.en.srt

5.57 KB

004 List all table space, schemas, and indices.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.en.srt

5.18 KB

003 List all databases and tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/003 List all databases and tables.en.srt

4.89 KB

008 Display command history, run commands from a file.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.en.srt

4.63 KB

014 Turn on query execution time.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/014 Turn on query execution time.en.srt

3.56 KB

011 Make table layout funkey!.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/011 Make table layout funkey!.en.srt

2.7 KB

002 Switch connection to a new database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/002 Switch connection to a new database.en.srt

2.6 KB

012 Repeatedly Execute a Query.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.en.srt

2.36 KB

006 Describe a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/006 Describe a table.en.srt

1.47 KB

007 Edit SQL commands in editor.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.en.srt

1.39 KB

009 Built-in syntax reference for commands.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.en.srt

1.3 KB

22 JSON with PostgreSQL

33 files • 546.15 MB

017 Indexing on JSONB.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/017 Indexing on JSONB.mp4

82.13 MB

013 Getting information from JSON documents.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/013 Getting information from JSON documents.mp4

68.46 MB

011 Null Values in JSON documents.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/011 Null Values in JSON documents.mp4

58.45 MB

006 Update and Delete JSON Data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/006 Update and Delete JSON Data.mp4

53.19 MB

002 JSON Syntax.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/002 JSON Syntax.mp4

33.91 MB

005 Create our first table with JSONB data type.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/005 Create our first table with JSONB data type.mp4

31.77 MB

008 Use json_agg to aggregate data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/008 Use json_agg to aggregate data.mp4

28.8 MB

007 Create JSON from tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/007 Create JSON from tables.mp4

28.35 MB

010 Creating a document from data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/010 Creating a document from data.mp4

27.84 MB

004 Exploring JSON objects.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/004 Exploring JSON objects.mp4

26.66 MB

001 What is JSON_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/001 What is JSON_.mp4

20.75 MB

003 JSON and JSONB data types.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/003 JSON and JSONB data types.mp4

20.49 MB

016 JSON search with PostgreSQL functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.mp4

18.47 MB

009 Build a JSON array.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/009 Build a JSON array.mp4

17.37 MB

015 The Containment Operator.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/015 The Containment Operator.mp4

16.97 MB

014 The Existence Operator.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/014 The Existence Operator.mp4

12.41 MB

006 Update and Delete JSON Data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/006 Update and Delete JSON Data.en.srt

17.46 KB

017 Indexing on JSONB.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/017 Indexing on JSONB.en.srt

17.45 KB

002 JSON Syntax.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/002 JSON Syntax.en.srt

13.96 KB

005 Create our first table with JSONB data type.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/005 Create our first table with JSONB data type.en.srt

11 KB

004 Exploring JSON objects.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/004 Exploring JSON objects.en.srt

10.18 KB

013 Getting information from JSON documents.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/013 Getting information from JSON documents.en.srt

8.98 KB

010 Creating a document from data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/010 Creating a document from data.en.srt

8.55 KB

007 Create JSON from tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/007 Create JSON from tables.en.srt

7.44 KB

008 Use json_agg to aggregate data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/008 Use json_agg to aggregate data.en.srt

7.32 KB

011 Null Values in JSON documents.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/011 Null Values in JSON documents.en.srt

7.22 KB

009 Build a JSON array.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/009 Build a JSON array.en.srt

6.68 KB

015 The Containment Operator.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/015 The Containment Operator.en.srt

6.05 KB

016 JSON search with PostgreSQL functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.en.srt

5.94 KB

003 JSON and JSONB data types.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/003 JSON and JSONB data types.en.srt

5.11 KB

001 What is JSON_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/001 What is JSON_.en.srt

5.05 KB

014 The Existence Operator.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/014 The Existence Operator.en.srt

4.34 KB

012 JSON nulls and SQL nulls.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/22 JSON with PostgreSQL/012 JSON nulls and SQL nulls.html

1.53 KB

47 Managing Tables

24 files • 428.21 MB

001 Using SELECT INTO to create a new table with joins.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/001 Using SELECT INTO to create a new table with joins.mp4

80.16 MB

012 Recovering unused space with VACUUM.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/012 Recovering unused space with VACUUM.mp4

58.52 MB

011 PostgreSQL autovacuum proces.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/011 PostgreSQL autovacuum proces.mp4

57.79 MB

013 Generated Columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/013 Generated Columns.mp4

55.14 MB

003 Import data from CSV files.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/003 Import data from CSV files.mp4

42.75 MB

010 Tracking table size.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/010 Tracking table size.mp4

31.38 MB

005 Deleting duplicate records.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/005 Deleting duplicate records.mp4

31.02 MB

004 Export Data to CSV files.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/004 Export Data to CSV files.mp4

30.17 MB

009 Database operations and table size.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/009 Database operations and table size.mp4

27.86 MB

002 Duplicate a table with or without data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/002 Duplicate a table with or without data.mp4

13.29 MB

001 Using SELECT INTO to create a new table with joins.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/001 Using SELECT INTO to create a new table with joins.en.srt

16.87 KB

013 Generated Columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/013 Generated Columns.en.srt

15.81 KB

012 Recovering unused space with VACUUM.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/012 Recovering unused space with VACUUM.en.srt

15.14 KB

011 PostgreSQL autovacuum proces.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/011 PostgreSQL autovacuum proces.en.srt

14.59 KB

611 countries_iso_codes.csv

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/611 countries_iso_codes.csv

11.45 KB

010 Tracking table size.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/010 Tracking table size.en.srt

11.32 KB

005 Deleting duplicate records.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/005 Deleting duplicate records.en.srt

10.78 KB

003 Import data from CSV files.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/003 Import data from CSV files.en.srt

10.6 KB

009 Database operations and table size.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/009 Database operations and table size.en.srt

8.54 KB

002 Duplicate a table with or without data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/002 Duplicate a table with or without data.en.srt

4.07 KB

004 Export Data to CSV files.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/004 Export Data to CSV files.en.srt

3.66 KB

006 Backup your databases regularly.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/006 Backup your databases regularly.html

1.75 KB

007 Test queries on a test database.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/007 Test queries on a test database.html

1.72 KB

008 Not documenting your process_.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/47 Managing Tables/008 Not documenting your process_.html

1.55 KB

07 PostgreSQL Data types

28 files • 627.01 MB

002 CHAR, VARCHAR and TEXT.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.mp4

77.28 MB

014 Network Addresses.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/014 Network Addresses.mp4

61.98 MB

008 TIME.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/008 TIME.mp4

60.8 MB

009 TIMESTAMP and TIMESTAMPTZ.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.mp4

54.88 MB

001 Boolean.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/001 Boolean.mp4

54.54 MB

013 JSON.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/013 JSON.mp4

52.38 MB

010 UUID.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/010 UUID.mp4

50.32 MB

003 NUMERIC.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/003 NUMERIC.mp4

43.22 MB

004 DECIMALS.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/004 DECIMALS.mp4

42.53 MB

012 hstore.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/012 hstore.mp4

31.75 MB

011 Array.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/011 Array.mp4

29.79 MB

007 DATE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/007 DATE.mp4

25.84 MB

005 Selecting Numbers data types.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/005 Selecting Numbers data types.mp4

25.61 MB

006 Date_Time data types.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/006 Date_Time data types.mp4

15.89 MB

002 CHAR, VARCHAR and TEXT.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.en.srt

28.42 KB

008 TIME.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/008 TIME.en.srt

21.13 KB

014 Network Addresses.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/014 Network Addresses.en.srt

20.42 KB

001 Boolean.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/001 Boolean.en.srt

19.42 KB

009 TIMESTAMP and TIMESTAMPTZ.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.en.srt

17.91 KB

013 JSON.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/013 JSON.en.srt

17.42 KB

003 NUMERIC.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/003 NUMERIC.en.srt

16.03 KB

004 DECIMALS.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/004 DECIMALS.en.srt

16.01 KB

010 UUID.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/010 UUID.en.srt

15.45 KB

012 hstore.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/012 hstore.en.srt

10.92 KB

011 Array.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/011 Array.en.srt

10.25 KB

007 DATE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/007 DATE.en.srt

9.04 KB

005 Selecting Numbers data types.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/005 Selecting Numbers data types.en.srt

8.49 KB

006 Date_Time data types.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/07 PostgreSQL Data types/006 Date_Time data types.en.srt

5.47 KB

26 Common Table Expressions (CTE)

13 files • 260.22 MB

007 Parent-child relationship via recursive CTE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.mp4

74.34 MB

002 CTE query examples.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/002 CTE query examples.mp4

73.64 MB

003 Combine CTE with a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/003 Combine CTE with a table.mp4

35.97 MB

005 Simultaneously DELETE INSERT via CTE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.mp4

32.42 MB

001 Introduction to CTEs.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/001 Introduction to CTEs.mp4

24.66 MB

006 Recursive CTEs.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/006 Recursive CTEs.mp4

19.1 MB

007 Parent-child relationship via recursive CTE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.en.srt

29.1 KB

002 CTE query examples.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/002 CTE query examples.en.srt

23.18 KB

005 Simultaneously DELETE INSERT via CTE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.en.srt

10.83 KB

003 Combine CTE with a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/003 Combine CTE with a table.en.srt

9.96 KB

001 Introduction to CTEs.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/001 Introduction to CTEs.en.srt

7.99 KB

006 Recursive CTEs.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/006 Recursive CTEs.en.srt

7.11 KB

004 Get the total revenues for each director.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/26 Common Table Expressions (CTE)/004 Get the total revenues for each director.html

1.57 KB

34 Functions with PL_pgSQL language

61 files • 842.08 MB

026 Using RETURN NEXT.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/026 Using RETURN NEXT.mp4

69.66 MB

030 Exception with data exception errors.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/030 Exception with data exception errors.mp4

67.57 MB

016 CASE Statement.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/016 CASE Statement.mp4

60.81 MB

024 Using RETURN QUERY.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/024 Using RETURN QUERY.mp4

56.95 MB

023 WHILE loop.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/023 WHILE loop.mp4

52.44 MB

017 Searched CASE statement.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/017 Searched CASE statement.mp4

46.14 MB

010 Assigning variables from query.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/010 Assigning variables from query.mp4

40.18 MB

015 Using IF with table data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/015 Using IF with table data.mp4

34.46 MB

014 Control Structures - IF statement.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/014 Control Structures - IF statement.mp4

32.71 MB

013 How to return query results.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/013 How to return query results.mp4

32.37 MB

029 Using SQLSTATE codes for exception handling.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.mp4

23.74 MB

027 Error and exception handling.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/027 Error and exception handling.mp4

23.58 MB

005 Declaring variables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/005 Declaring variables.mp4

23.46 MB

020 FOR Loops iterate over result set.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.mp4

23.43 MB

018 LOOP statement.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/018 LOOP statement.mp4

23.43 MB

028 Exception - Too many rows.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/028 Exception - Too many rows.mp4

22.98 MB

019 FOR Loops.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/019 FOR Loops.mp4

22.69 MB

007 Declaring variables in function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/007 Declaring variables in function.mp4

21.05 MB

021 CONTINUE statement.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/021 CONTINUE statement.mp4

19.7 MB

012 Variables in block and subblock.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/012 Variables in block and subblock.mp4

19.03 MB

003 Structure of a PL_pgSQL function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.mp4

18.99 MB

011 Using IN, OUT without RETURNS.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.mp4

18.37 MB

025 Returning a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/025 Returning a table.mp4

17.11 MB

022 FOREACH loop with arrays.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.mp4

15.1 MB

009 Copying data types.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/009 Copying data types.mp4

11.56 MB

002 PL_pgSQL vs SQL.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.mp4

10.78 MB

004 PL_pgSQL block structure.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.mp4

10.06 MB

008 Variable initializing timing.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/008 Variable initializing timing.mp4

8.85 MB

001 Introduction to PL_pgSQL language.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.mp4

8.19 MB

006 Declaring variables via ALIAS FOR.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.mp4

6.43 MB

026 Using RETURN NEXT.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/026 Using RETURN NEXT.en.srt

19.33 KB

023 WHILE loop.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/023 WHILE loop.en.srt

17.25 KB

017 Searched CASE statement.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/017 Searched CASE statement.en.srt

16.76 KB

016 CASE Statement.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/016 CASE Statement.en.srt

16.46 KB

024 Using RETURN QUERY.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/024 Using RETURN QUERY.en.srt

16.12 KB

010 Assigning variables from query.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/010 Assigning variables from query.en.srt

12.24 KB

014 Control Structures - IF statement.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/014 Control Structures - IF statement.en.srt

11.05 KB

030 Exception with data exception errors.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/030 Exception with data exception errors.en.srt

10.02 KB

019 FOR Loops.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/019 FOR Loops.en.srt

8.63 KB

018 LOOP statement.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/018 LOOP statement.en.srt

8.49 KB

005 Declaring variables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/005 Declaring variables.en.srt

8.44 KB

027 Error and exception handling.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/027 Error and exception handling.en.srt

8.14 KB

015 Using IF with table data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/015 Using IF with table data.en.srt

7.8 KB

028 Exception - Too many rows.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/028 Exception - Too many rows.en.srt

7.54 KB

021 CONTINUE statement.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/021 CONTINUE statement.en.srt

7.45 KB

003 Structure of a PL_pgSQL function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.en.srt

7.44 KB

007 Declaring variables in function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/007 Declaring variables in function.en.srt

7.3 KB

020 FOR Loops iterate over result set.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.en.srt

6.82 KB

011 Using IN, OUT without RETURNS.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.en.srt

6.67 KB

012 Variables in block and subblock.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/012 Variables in block and subblock.en.srt

6.66 KB

013 How to return query results.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/013 How to return query results.en.srt

6.52 KB

029 Using SQLSTATE codes for exception handling.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.en.srt

6.3 KB

025 Returning a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/025 Returning a table.en.srt

5.91 KB

022 FOREACH loop with arrays.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.en.srt

5.59 KB

009 Copying data types.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/009 Copying data types.en.srt

4 KB

002 PL_pgSQL vs SQL.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.en.srt

3.61 KB

008 Variable initializing timing.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/008 Variable initializing timing.en.srt

3.3 KB

004 PL_pgSQL block structure.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.en.srt

3.13 KB

001 Introduction to PL_pgSQL language.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.en.srt

3.08 KB

006 Declaring variables via ALIAS FOR.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.en.srt

2.35 KB

437 q_variable_initialization_timing.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/34 Functions with PL_pgSQL language/437 q_variable_initialization_timing.sql

192 Bytes

15 Aggregate functions

12 files • 272.07 MB

003 MIN and MAX functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/003 MIN and MAX functions.mp4

68.42 MB

005 Average with AVG function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/005 Average with AVG function.mp4

61.53 MB

006 Combining Columns using Mathematical operators.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/006 Combining Columns using Mathematical operators.mp4

45.11 MB

001 Counting results via COUNT function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/001 Counting results via COUNT function.mp4

38.06 MB

002 Sum with SUM function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/002 Sum with SUM function.mp4

37.84 MB

004 GREATEST AND LEAST functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/004 GREATEST AND LEAST functions.mp4

21.04 MB

005 Average with AVG function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/005 Average with AVG function.en.srt

18.74 KB

003 MIN and MAX functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/003 MIN and MAX functions.en.srt

17.85 KB

006 Combining Columns using Mathematical operators.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/006 Combining Columns using Mathematical operators.en.srt

15.93 KB

002 Sum with SUM function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/002 Sum with SUM function.en.srt

11.58 KB

001 Counting results via COUNT function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/001 Counting results via COUNT function.en.srt

8.23 KB

004 GREATEST AND LEAST functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/15 Aggregate functions/004 GREATEST AND LEAST functions.en.srt

7.15 KB

25 Fun with subqueries

24 files • 366.93 MB

002 Subqueries with WHERE Clause.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/002 Subqueries with WHERE Clause.mp4

66 MB

009 Correlated Queries.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/009 Correlated Queries.mp4

51.83 MB

004 Subquery with JOINs.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/004 Subquery with JOINs.mp4

47.44 MB

012 Using ALL with subquery.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/012 Using ALL with subquery.mp4

47.31 MB

011 Using ANY with subquery.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/011 Using ANY with subquery.mp4

40.43 MB

010 SELECT.. IN (Subquery).mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/010 SELECT.. IN (Subquery).mp4

39.29 MB

013 Subquery using EXISTS.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/013 Subquery using EXISTS.mp4

20.45 MB

003 Subquery with IN operator.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/003 Subquery with IN operator.mp4

19.66 MB

006 Order entries in UNION without using ORDER BY.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.mp4

17.32 MB

008 A SELECT without a FROM.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/008 A SELECT without a FROM.mp4

10.18 MB

007 Subquery with an alias.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/007 Subquery with an alias.mp4

6.92 MB

009 Correlated Queries.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/009 Correlated Queries.en.srt

18.11 KB

002 Subqueries with WHERE Clause.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/002 Subqueries with WHERE Clause.en.srt

18.07 KB

004 Subquery with JOINs.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/004 Subquery with JOINs.en.srt

12.23 KB

012 Using ALL with subquery.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/012 Using ALL with subquery.en.srt

11 KB

011 Using ANY with subquery.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/011 Using ANY with subquery.en.srt

10.8 KB

010 SELECT.. IN (Subquery).en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/010 SELECT.. IN (Subquery).en.srt

9.78 KB

013 Subquery using EXISTS.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/013 Subquery using EXISTS.en.srt

7 KB

003 Subquery with IN operator.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/003 Subquery with IN operator.en.srt

6.47 KB

006 Order entries in UNION without using ORDER BY.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.en.srt

6.26 KB

008 A SELECT without a FROM.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/008 A SELECT without a FROM.en.srt

3.63 KB

001 Introduction to subqueries.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/001 Introduction to subqueries.html

2.74 KB

007 Subquery with an alias.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/007 Subquery with an alias.en.srt

1.91 KB

005 Get total revenues for all 'English' films.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/25 Fun with subqueries/005 Get total revenues for all 'English' films.html

1.8 KB

24 All about Views

53 files • 693.56 MB

024 Using materialized view for websites page analysis.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/024 Using materialized view for websites page analysis.mp4

63.74 MB

019 Changing materialized view data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/019 Changing materialized view data.mp4

55.35 MB

002 Creating a view.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/002 Creating a view.mp4

54.55 MB

016 What is a Materialized View.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/016 What is a Materialized View.mp4

44.05 MB

014 Updatable views using WITH CHECK OPTION.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/014 Updatable views using WITH CHECK OPTION.mp4

42.53 MB

007 Connecting multiple tables with a single view.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/007 Connecting multiple tables with a single view.mp4

42.36 MB

005 Using filters with views.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/005 Using filters with views.mp4

40.67 MB

015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4

40.26 MB

021 Refreshing data in materialize views.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/021 Refreshing data in materialize views.mp4

37.8 MB

001 Introduction to views.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/001 Introduction to views.mp4

33.85 MB

013 An updatable view with CRUD operations.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/013 An updatable view with CRUD operations.mp4

29.25 MB

006 A view with UNION of multiple tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/006 A view with UNION of multiple tables.mp4

23.24 MB

017 Creating a materialized view.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/017 Creating a materialized view.mp4

18.63 MB

003 Rename a view.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/003 Rename a view.mp4

18.28 MB

022 Why not use a table instead of materialized view_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/022 Why not use a table instead of materialized view_.mp4

18.06 MB

026 List materialized views with no unique index.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/026 List materialized views with no unique index.mp4

17.08 MB

023 The downsides of using materialized views.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/023 The downsides of using materialized views.mp4

15.98 MB

012 What is an updatable view_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/012 What is an updatable view_.mp4

15.98 MB

018 Drop a materialized view.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/018 Drop a materialized view.mp4

15.6 MB

011 Regular views are dynamic.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/011 Regular views are dynamic.mp4

13.7 MB

008 Re-arrange columns in a view.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/008 Re-arrange columns in a view.mp4

12 MB

020 How to check if a materialized view is populated or not_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/020 How to check if a materialized view is populated or not_.mp4

11.78 MB

010 Add a column in a view.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/010 Add a column in a view.mp4

8.74 MB

009 Delete a column in a view.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/009 Delete a column in a view.mp4

7.21 MB

004 Delete a view.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/004 Delete a view.mp4

6.8 MB

025 List all materialized views by a SELECT statement.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/025 List all materialized views by a SELECT statement.mp4

5.88 MB

024 Using materialized view for websites page analysis.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/024 Using materialized view for websites page analysis.en.srt

16.5 KB

002 Creating a view.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/002 Creating a view.en.srt

16.02 KB

015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.en.srt

13.15 KB

016 What is a Materialized View.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/016 What is a Materialized View.en.srt

13.1 KB

014 Updatable views using WITH CHECK OPTION.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/014 Updatable views using WITH CHECK OPTION.en.srt

11.78 KB

007 Connecting multiple tables with a single view.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/007 Connecting multiple tables with a single view.en.srt

10.59 KB

001 Introduction to views.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/001 Introduction to views.en.srt

10.4 KB

005 Using filters with views.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/005 Using filters with views.en.srt

10.32 KB

021 Refreshing data in materialize views.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/021 Refreshing data in materialize views.en.srt

9.29 KB

019 Changing materialized view data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/019 Changing materialized view data.en.srt

9.04 KB

013 An updatable view with CRUD operations.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/013 An updatable view with CRUD operations.en.srt

7.94 KB

006 A view with UNION of multiple tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/006 A view with UNION of multiple tables.en.srt

6.9 KB

017 Creating a materialized view.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/017 Creating a materialized view.en.srt

6.66 KB

003 Rename a view.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/003 Rename a view.en.srt

6.47 KB

022 Why not use a table instead of materialized view_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/022 Why not use a table instead of materialized view_.en.srt

6.21 KB

026 List materialized views with no unique index.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/026 List materialized views with no unique index.en.srt

5.94 KB

012 What is an updatable view_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/012 What is an updatable view_.en.srt

5.23 KB

008 Re-arrange columns in a view.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/008 Re-arrange columns in a view.en.srt

4.72 KB

018 Drop a materialized view.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/018 Drop a materialized view.en.srt

4.44 KB

011 Regular views are dynamic.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/011 Regular views are dynamic.en.srt

4.14 KB

023 The downsides of using materialized views.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/023 The downsides of using materialized views.en.srt

4.13 KB

010 Add a column in a view.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/010 Add a column in a view.en.srt

3.92 KB

020 How to check if a materialized view is populated or not_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/020 How to check if a materialized view is populated or not_.en.srt

3.62 KB

009 Delete a column in a view.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/009 Delete a column in a view.en.srt

3.11 KB

004 Delete a view.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/004 Delete a view.en.srt

3.01 KB

025 List all materialized views by a SELECT statement.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/025 List all materialized views by a SELECT statement.en.srt

2.16 KB

027 Quick queries for materialized views.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/24 All about Views/027 Quick queries for materialized views.html

1.6 KB

21 Exploring array functions

35 files • 541.16 MB

017 Array vs JSONB.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/017 Array vs JSONB.mp4

63.28 MB

008 Array comparison with IN, ALL, ANY and SOME.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.mp4

55.61 MB

016 Using Multi-dimensional arrays.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/016 Using Multi-dimensional arrays.mp4

47.56 MB

009 Formatting and converting an array.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/009 Formatting and converting an array.mp4

37.04 MB

005 Array metadata functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/005 Array metadata functions.mp4

36.75 MB

003 Using inclusion operators.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/003 Using inclusion operators.mp4

35.01 MB

002 Using comparison operators.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/002 Using comparison operators.mp4

34.19 MB

001 Constructing arrays and ranges.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/001 Constructing arrays and ranges.mp4

31.8 MB

007 Array modification functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/007 Array modification functions.mp4

30.13 MB

006 Array search functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/006 Array search functions.mp4

29.16 MB

012 Query array data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/012 Query array data.mp4

28.93 MB

011 Insert data into arrays.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/011 Insert data into arrays.mp4

23.46 MB

004 Array constructions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/004 Array constructions.mp4

21.3 MB

010 Using arrays in tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/010 Using arrays in tables.mp4

19.64 MB

014 Array Dimensions are ignored!.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/014 Array Dimensions are ignored!.mp4

18.33 MB

015 Display all array elements.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/015 Display all array elements.mp4

15.96 MB

013 Modifying array data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/013 Modifying array data.mp4

12.82 MB

017 Array vs JSONB.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/017 Array vs JSONB.en.srt

21.02 KB

008 Array comparison with IN, ALL, ANY and SOME.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.en.srt

20.96 KB

016 Using Multi-dimensional arrays.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/016 Using Multi-dimensional arrays.en.srt

16.58 KB

009 Formatting and converting an array.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/009 Formatting and converting an array.en.srt

13.69 KB

005 Array metadata functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/005 Array metadata functions.en.srt

12.46 KB

002 Using comparison operators.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/002 Using comparison operators.en.srt

11.62 KB

001 Constructing arrays and ranges.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/001 Constructing arrays and ranges.en.srt

11.05 KB

012 Query array data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/012 Query array data.en.srt

10.81 KB

006 Array search functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/006 Array search functions.en.srt

10.23 KB

007 Array modification functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/007 Array modification functions.en.srt

9.82 KB

011 Insert data into arrays.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/011 Insert data into arrays.en.srt

8.84 KB

004 Array constructions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/004 Array constructions.en.srt

8.03 KB

003 Using inclusion operators.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/003 Using inclusion operators.en.srt

6.74 KB

010 Using arrays in tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/010 Using arrays in tables.en.srt

6.26 KB

014 Array Dimensions are ignored!.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/014 Array Dimensions are ignored!.en.srt

6.23 KB

015 Display all array elements.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/015 Display all array elements.en.srt

5.7 KB

013 Modifying array data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/013 Modifying array data.en.srt

4.45 KB

018 Single and Multi-dimensional arrays.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/21 Exploring array functions/018 Single and Multi-dimensional arrays.html

3.65 KB

09 Data type conversions

8 files • 137.57 MB

002 Using CAST for data conversions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/09 Data type conversions/002 Using CAST for data conversions.mp4

59.56 MB

001 What is a data type conversion.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/09 Data type conversions/001 What is a data type conversion.mp4

31.21 MB

004 Table data conversion.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/09 Data type conversions/004 Table data conversion.mp4

29.67 MB

003 Implicit to Explicit conversions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/09 Data type conversions/003 Implicit to Explicit conversions.mp4

17.09 MB

002 Using CAST for data conversions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/09 Data type conversions/002 Using CAST for data conversions.en.srt

18.64 KB

004 Table data conversion.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/09 Data type conversions/004 Table data conversion.en.srt

11.5 KB

001 What is a data type conversion.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/09 Data type conversions/001 What is a data type conversion.en.srt

8.89 KB

003 Implicit to Explicit conversions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/09 Data type conversions/003 Implicit to Explicit conversions.en.srt

6.84 KB

39 Internationalization

4 files • 114.92 MB

001 Global Character Set Support.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/39 Internationalization/001 Global Character Set Support.mp4

57.67 MB

002 Client and Server Encoding.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/39 Internationalization/002 Client and Server Encoding.mp4

57.22 MB

002 Client and Server Encoding.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/39 Internationalization/002 Client and Server Encoding.en.srt

16.47 KB

001 Global Character Set Support.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/39 Internationalization/001 Global Character Set Support.en.srt

15.37 KB

03 Creating and Modifying Tables

29 files • 247.11 MB

011 Using pgAdmin - Rename, delete and change the data type of a column.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.mp4

56.81 MB

007 Install sample data for 'movies' database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/007 Install sample data for 'movies' database.mp4

41.02 MB

010 Using pgAdmin - View table structure, and create column.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.mp4

21.69 MB

009 Using pgAdmin - Create and modify a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.mp4

21.24 MB

002 Creating the movie database and a actors table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/002 Creating the movie database and a actors table.mp4

20.6 MB

004 Creating the movies table with a foreign key.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.mp4

20.51 MB

006 Creating a Junction table with movies and actors tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.mp4

15.66 MB

003 Creating the directors table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/003 Creating the directors table.mp4

14.45 MB

005 Creating the movies_revenues table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/005 Creating the movies_revenues table.mp4

13.14 MB

001 Movie Database Structure.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/001 Movie Database Structure.mp4

12.23 MB

012 Deleting tables from a database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/012 Deleting tables from a database.mp4

9.68 MB

011 Using pgAdmin - Rename, delete and change the data type of a column.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.en.srt

9.28 KB

007 Install sample data for 'movies' database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/007 Install sample data for 'movies' database.en.srt

7.76 KB

002 Creating the movie database and a actors table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/002 Creating the movie database and a actors table.en.srt

7.68 KB

010 Using pgAdmin - View table structure, and create column.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.en.srt

7.45 KB

004 Creating the movies table with a foreign key.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.en.srt

7.3 KB

009 Using pgAdmin - Create and modify a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.en.srt

6.67 KB

006 Creating a Junction table with movies and actors tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.en.srt

5.25 KB

001 Movie Database Structure.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/001 Movie Database Structure.en.srt

5.09 KB

005 Creating the movies_revenues table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/005 Creating the movies_revenues table.en.srt

4.33 KB

003 Creating the directors table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/003 Creating the directors table.en.srt

4.08 KB

012 Deleting tables from a database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/012 Deleting tables from a database.en.srt

3.46 KB

008 Create a sample Database _mydata_.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/008 Create a sample Database _mydata_.html

2.17 KB

017 q_creating the movies table with a foreign key.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/017 q_creating the movies table with a foreign key.sql

258 Bytes

016 q_creating the directors table.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/016 q_creating the directors table.sql

227 Bytes

018 q_creating the movies_revenues table.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/018 q_creating the movies_revenues table.sql

216 Bytes

015 q_creating movies database and actors table.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/015 q_creating movies database and actors table.sql

186 Bytes

019 q_creating a junction table with movies and actors table.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/019 q_creating a junction table with movies and actors table.sql

184 Bytes

025 q_deleting tables from a database.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/03 Creating and Modifying Tables/025 q_deleting tables from a database.sql

119 Bytes

40 PostgreSQL Transactions

18 files • 252.68 MB

005 Transaction analysis.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/005 Transaction analysis.mp4

56.24 MB

001 What is a transaction_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/001 What is a transaction_.mp4

39.79 MB

003 ACID Database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/003 ACID Database.mp4

38.33 MB

007 How to fix transactions on crash.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/007 How to fix transactions on crash.mp4

31.78 MB

009 Using SAVEPOINT with transaction.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.mp4

23.24 MB

002 How SQL protect database during transaction.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/002 How SQL protect database during transaction.mp4

22.89 MB

008 Partial transaction rollback with savepoints.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.mp4

15.34 MB

006 How to fix aborted transaction.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/006 How to fix aborted transaction.mp4

15.22 MB

004 Transaction setup.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/004 Transaction setup.mp4

9.77 MB

005 Transaction analysis.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/005 Transaction analysis.en.srt

22.96 KB

003 ACID Database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/003 ACID Database.en.srt

12.54 KB

001 What is a transaction_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/001 What is a transaction_.en.srt

11.41 KB

009 Using SAVEPOINT with transaction.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.en.srt

9.12 KB

007 How to fix transactions on crash.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/007 How to fix transactions on crash.en.srt

8.09 KB

002 How SQL protect database during transaction.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/002 How SQL protect database during transaction.en.srt

7.81 KB

006 How to fix aborted transaction.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/006 How to fix aborted transaction.en.srt

5.76 KB

008 Partial transaction rollback with savepoints.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.en.srt

5.46 KB

004 Transaction setup.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/40 PostgreSQL Transactions/004 Transaction setup.en.srt

3.73 KB

19 Combining queries together

10 files • 152.38 MB

001 Combine results sets with UNION.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/001 Combine results sets with UNION.mp4

54.4 MB

002 UNION with filters and conditions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/002 UNION with filters and conditions.mp4

44.77 MB

005 EXCEPT with tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/005 EXCEPT with tables.mp4

22.24 MB

004 INTERSECT with tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/004 INTERSECT with tables.mp4

17.11 MB

003 UNION tables with different number of columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/003 UNION tables with different number of columns.mp4

13.81 MB

001 Combine results sets with UNION.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/001 Combine results sets with UNION.en.srt

16.37 KB

002 UNION with filters and conditions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/002 UNION with filters and conditions.en.srt

14.01 KB

005 EXCEPT with tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/005 EXCEPT with tables.en.srt

8.13 KB

004 INTERSECT with tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/004 INTERSECT with tables.en.srt

6.43 KB

003 UNION tables with different number of columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/19 Combining queries together/003 UNION tables with different number of columns.en.srt

4.66 KB

05 Querying Data

20 files • 256.52 MB

003 Adding Aliases to columns in a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/003 Adding Aliases to columns in a table.mp4

48.49 MB

005 Using ORDER BY to sort records.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/005 Using ORDER BY to sort records.mp4

43.3 MB

001 Select all data from a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/001 Select all data from a table.mp4

39.24 MB

010 Using DISTINCT for selecting distinct values.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/010 Using DISTINCT for selecting distinct values.mp4

26.06 MB

009 Using ORDER BY with NULL values.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/009 Using ORDER BY with NULL values.mp4

22.92 MB

008 Using ORDER BY with column name or column number.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/008 Using ORDER BY with column name or column number.mp4

17.64 MB

002 Selecting specific columns from a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/002 Selecting specific columns from a table.mp4

15.91 MB

007 Using ORDER BY to sort rows by expressions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/007 Using ORDER BY to sort rows by expressions.mp4

15.79 MB

006 Using ORDER BY with alias column name.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/006 Using ORDER BY with alias column name.mp4

13.61 MB

004 Using SELECT statement for expressions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/004 Using SELECT statement for expressions.mp4

13.49 MB

003 Adding Aliases to columns in a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/003 Adding Aliases to columns in a table.en.srt

12.99 KB

005 Using ORDER BY to sort records.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/005 Using ORDER BY to sort records.en.srt

9.11 KB

001 Select all data from a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/001 Select all data from a table.en.srt

8.77 KB

009 Using ORDER BY with NULL values.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/009 Using ORDER BY with NULL values.en.srt

8.76 KB

010 Using DISTINCT for selecting distinct values.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/010 Using DISTINCT for selecting distinct values.en.srt

8.24 KB

002 Selecting specific columns from a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/002 Selecting specific columns from a table.en.srt

5.12 KB

008 Using ORDER BY with column name or column number.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/008 Using ORDER BY with column name or column number.en.srt

4.6 KB

007 Using ORDER BY to sort rows by expressions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/007 Using ORDER BY to sort rows by expressions.en.srt

4.53 KB

004 Using SELECT statement for expressions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/004 Using SELECT statement for expressions.en.srt

3.98 KB

006 Using ORDER BY with alias column name.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/05 Querying Data/006 Using ORDER BY with alias column name.en.srt

3.74 KB

41 Using Northwind Database

35 files • 385.85 MB

009 Freight analysis.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/009 Freight analysis.mp4

48.28 MB

014 Late shipped orders by employees.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/014 Late shipped orders by employees.mp4

42.87 MB

013 Orders with double entry line items.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/013 Orders with double entry line items.mp4

38.28 MB

018 First order from each country.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/018 First order from each country.mp4

37.69 MB

017 Customers with multiple orders.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/017 Customers with multiple orders.mp4

33.83 MB

016 Countries with customers or suppliers - Using CTE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.mp4

23.37 MB

010 Customers with no orders.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/010 Customers with no orders.mp4

22.74 MB

011 Top customers with total orders amount.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/011 Top customers with total orders amount.mp4

22.61 MB

005 Show total order amount for each order.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/005 Show total order amount for each order.mp4

18.76 MB

004 Orders shipped to latin america.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/004 Orders shipped to latin america.mp4

17.08 MB

007 Total products in each categories.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/007 Total products in each categories.mp4

15.07 MB

008 List products that needs re-ordering.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/008 List products that needs re-ordering.mp4

13.56 MB

012 Orders with many lines of ordered items.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/012 Orders with many lines of ordered items.mp4

10.57 MB

015 Countries with customers or suppliers.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/015 Countries with customers or suppliers.mp4

10.25 MB

003 Total numbers of orders shipped to USA or France.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.mp4

9.19 MB

002 Orders shipping to USA or France.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/002 Orders shipping to USA or France.mp4

9.18 MB

006 First the oldest and latest order date.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/006 First the oldest and latest order date.mp4

8.35 MB

001 Using Northwind database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/001 Using Northwind database.mp4

4.06 MB

014 Late shipped orders by employees.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/014 Late shipped orders by employees.en.srt

15.9 KB

013 Orders with double entry line items.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/013 Orders with double entry line items.en.srt

15.19 KB

009 Freight analysis.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/009 Freight analysis.en.srt

14.4 KB

018 First order from each country.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/018 First order from each country.en.srt

10.8 KB

017 Customers with multiple orders.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/017 Customers with multiple orders.en.srt

10.33 KB

016 Countries with customers or suppliers - Using CTE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.en.srt

8.79 KB

010 Customers with no orders.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/010 Customers with no orders.en.srt

7.91 KB

011 Top customers with total orders amount.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/011 Top customers with total orders amount.en.srt

6.65 KB

007 Total products in each categories.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/007 Total products in each categories.en.srt

5.62 KB

008 List products that needs re-ordering.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/008 List products that needs re-ordering.en.srt

4.79 KB

012 Orders with many lines of ordered items.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/012 Orders with many lines of ordered items.en.srt

4.27 KB

015 Countries with customers or suppliers.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/015 Countries with customers or suppliers.en.srt

4.21 KB

004 Orders shipped to latin america.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/004 Orders shipped to latin america.en.srt

4.07 KB

006 First the oldest and latest order date.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/006 First the oldest and latest order date.en.srt

2.82 KB

002 Orders shipping to USA or France.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/002 Orders shipping to USA or France.en.srt

2.69 KB

003 Total numbers of orders shipped to USA or France.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.en.srt

2.4 KB

001 Using Northwind database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/41 Using Northwind Database/001 Using Northwind database.en.srt

1.54 KB

10 Conversion Functions

8 files • 126.34 MB

001 to_char.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/10 Conversion Functions/001 to_char.mp4

43.98 MB

004 to_timestamp.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/10 Conversion Functions/004 to_timestamp.mp4

30.95 MB

003 to_date.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/10 Conversion Functions/003 to_date.mp4

28.47 MB

002 to_number.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/10 Conversion Functions/002 to_number.mp4

22.91 MB

001 to_char.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/10 Conversion Functions/001 to_char.en.srt

12.14 KB

002 to_number.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/10 Conversion Functions/002 to_number.en.srt

8.68 KB

003 to_date.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/10 Conversion Functions/003 to_date.en.srt

8.36 KB

004 to_timestamp.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/10 Conversion Functions/004 to_timestamp.en.srt

7.09 KB

08 Modifying Table Structures, Add constraints

6 files • 95.4 MB

003 Add constraints to columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/08 Modifying Table Structures, Add constraints/003 Add constraints to columns.mp4

43.08 MB

002 Modify Table Structures, Add_Modify Columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.mp4

34.95 MB

001 Creating sample database 'mydata', adding columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.mp4

17.34 MB

003 Add constraints to columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/08 Modifying Table Structures, Add constraints/003 Add constraints to columns.en.srt

11.47 KB

002 Modify Table Structures, Add_Modify Columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.en.srt

9.68 KB

001 Creating sample database 'mydata', adding columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.en.srt

5.26 KB

32 Server Programming

12 files • 136.48 MB

001 PostgreSQL as a development platform_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/001 PostgreSQL as a development platform_.mp4

42.05 MB

003 Keep the data on the server!.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/003 Keep the data on the server!.mp4

26.71 MB

002 Procedural languages.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/002 Procedural languages.mp4

22.01 MB

004 Functions vs stored procedures.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/004 Functions vs stored procedures.mp4

17.44 MB

005 User-defined functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/005 User-defined functions.mp4

16.53 MB

006 Structure of a function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/006 Structure of a function.mp4

11.7 MB

001 PostgreSQL as a development platform_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/001 PostgreSQL as a development platform_.en.srt

14.58 KB

003 Keep the data on the server!.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/003 Keep the data on the server!.en.srt

8.94 KB

002 Procedural languages.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/002 Procedural languages.en.srt

8.11 KB

004 Functions vs stored procedures.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/004 Functions vs stored procedures.en.srt

6 KB

005 User-defined functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/005 User-defined functions.en.srt

4.77 KB

006 Structure of a function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/32 Server Programming/006 Structure of a function.en.srt

4.02 KB

14 String Functions

24 files • 268.12 MB

002 LEFT and RIGHT.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/002 LEFT and RIGHT.mp4

40.45 MB

004 SPLIT_PART.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/004 SPLIT_PART.mp4

32.95 MB

009 STRPOS.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/009 STRPOS.mp4

32.56 MB

006 LPAD and RPAD.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/006 LPAD and RPAD.mp4

32.36 MB

005 TRIM, BTRIM, LTRIM and RTRIM.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.mp4

27.26 MB

001 UPPER, LOWER and INITCAP.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/001 UPPER, LOWER and INITCAP.mp4

20.09 MB

012 REPLACE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/012 REPLACE.mp4

17.13 MB

010 SUBSTRING.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/010 SUBSTRING.mp4

17.01 MB

007 LENGTH.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/007 LENGTH.mp4

16.66 MB

008 POSITION.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/008 POSITION.mp4

14.74 MB

011 REPEAT.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/011 REPEAT.mp4

8.73 MB

003 REVERSE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/003 REVERSE.mp4

8.08 MB

002 LEFT and RIGHT.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/002 LEFT and RIGHT.en.srt

12.48 KB

004 SPLIT_PART.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/004 SPLIT_PART.en.srt

10.38 KB

005 TRIM, BTRIM, LTRIM and RTRIM.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.en.srt

10.12 KB

006 LPAD and RPAD.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/006 LPAD and RPAD.en.srt

8.37 KB

009 STRPOS.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/009 STRPOS.en.srt

7.23 KB

001 UPPER, LOWER and INITCAP.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/001 UPPER, LOWER and INITCAP.en.srt

6.77 KB

010 SUBSTRING.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/010 SUBSTRING.en.srt

5.93 KB

007 LENGTH.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/007 LENGTH.en.srt

5.86 KB

012 REPLACE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/012 REPLACE.en.srt

5.69 KB

008 POSITION.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/008 POSITION.en.srt

4.83 KB

011 REPEAT.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/011 REPEAT.en.srt

3.62 KB

003 REVERSE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/14 String Functions/003 REVERSE.en.srt

3.18 KB

04 Modifying Data in the tables

22 files • 141.11 MB

009 Using UPSERT.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/009 Using UPSERT.mp4

38.42 MB

005 Update data in a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/005 Update data in a table.mp4

18.89 MB

001 Insert a data into table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/001 Insert a data into table.mp4

18.36 MB

008 Delete data from a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/008 Delete data from a table.mp4

13.16 MB

007 Updating all records in a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/007 Updating all records in a table.mp4

13.12 MB

004 Use RETURNING to get info on added rows.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.mp4

11.11 MB

006 Updating a row and returning the updated row.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/006 Updating a row and returning the updated row.mp4

10.87 MB

002 Insert multiple records into a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/002 Insert multiple records into a table.mp4

9.59 MB

003 Insert a data that had quotes.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/003 Insert a data that had quotes.mp4

7.55 MB

009 Using UPSERT.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/009 Using UPSERT.en.srt

13.98 KB

001 Insert a data into table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/001 Insert a data into table.en.srt

5.9 KB

005 Update data in a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/005 Update data in a table.en.srt

4.18 KB

007 Updating all records in a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/007 Updating all records in a table.en.srt

4.13 KB

008 Delete data from a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/008 Delete data from a table.en.srt

4.04 KB

004 Use RETURNING to get info on added rows.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.en.srt

3.93 KB

002 Insert multiple records into a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/002 Insert multiple records into a table.en.srt

3.19 KB

006 Updating a row and returning the updated row.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/006 Updating a row and returning the updated row.en.srt

2.9 KB

003 Insert a data that had quotes.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/003 Insert a data that had quotes.en.srt

2.54 KB

026 q_insert data into table.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/026 q_insert data into table.sql

267 Bytes

029 q_use RETURNING to get info on added rows.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/029 q_use RETURNING to get info on added rows.sql

224 Bytes

027 q_insert multiple records into a table.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/027 q_insert multiple records into a table.sql

137 Bytes

028 q_insert a data that had quotes.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/04 Modifying Data in the tables/028 q_insert a data that had quotes.sql

93 Bytes

13 PostgreSQL Sequences

20 files • 188.04 MB

007 Attach a sequence to a table column.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/007 Attach a sequence to a table column.mp4

36.5 MB

010 Create an alphanumeric sequence.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/010 Create an alphanumeric sequence.mp4

31.71 MB

001 Create a sequence, advance a sequence, get current value, set value.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.mp4

30.21 MB

005 Creating a descending sequence, and CYCLE sequence.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.mp4

18.92 MB

002 Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4

17.82 MB

009 Share one sequence between two tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/009 Share one sequence between two tables.mp4

16.09 MB

003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4

13.52 MB

004 Create a sequence using a specific data type.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/004 Create a sequence using a specific data type.mp4

11.57 MB

008 List all sequences in a database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/008 List all sequences in a database.mp4

6.01 MB

006 Delete a sequence.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/006 Delete a sequence.mp4

5.63 MB

007 Attach a sequence to a table column.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/007 Attach a sequence to a table column.en.srt

10.51 KB

010 Create an alphanumeric sequence.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/010 Create an alphanumeric sequence.en.srt

9.88 KB

001 Create a sequence, advance a sequence, get current value, set value.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.en.srt

9.14 KB

005 Creating a descending sequence, and CYCLE sequence.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.en.srt

6.38 KB

002 Restart, rename a sequence, and use pgAdmin to alter a sequence.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.en.srt

5.3 KB

009 Share one sequence between two tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/009 Share one sequence between two tables.en.srt

5.05 KB

003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.en.srt

4.3 KB

004 Create a sequence using a specific data type.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/004 Create a sequence using a specific data type.en.srt

2.86 KB

006 Delete a sequence.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/006 Delete a sequence.en.srt

1.8 KB

008 List all sequences in a database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/13 PostgreSQL Sequences/008 List all sequences in a database.en.srt

1.78 KB

35 Exploring Stored Procedures

10 files • 117.37 MB

002 Create a transactions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/002 Create a transactions.mp4

34.08 MB

004 Returning a value.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/004 Returning a value.mp4

26.31 MB

003 Understanding the use of stored procedures.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/003 Understanding the use of stored procedures.mp4

25.54 MB

001 Functions vs Stored Procedures.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/001 Functions vs Stored Procedures.mp4

24.63 MB

005 Drop a procedure.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/005 Drop a procedure.mp4

6.77 MB

002 Create a transactions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/002 Create a transactions.en.srt

11.4 KB

001 Functions vs Stored Procedures.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/001 Functions vs Stored Procedures.en.srt

8.58 KB

003 Understanding the use of stored procedures.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/003 Understanding the use of stored procedures.en.srt

7.65 KB

004 Returning a value.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/004 Returning a value.en.srt

5.35 KB

005 Drop a procedure.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/35 Exploring Stored Procedures/005 Drop a procedure.en.srt

2.77 KB

11 User-defined Data Types

30 files • 260.12 MB

013 Update an ENUM data in production server.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/013 Update an ENUM data in production server.mp4

32.27 MB

001 CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4

28.79 MB

008 CREATE TYPE - Create a composite address object.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.mp4

26.96 MB

007 CREATE DOMAIN - How to drop a domain data type.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.mp4

20.95 MB

011 ALTER TYPE - Alter a composite data type, change schema and more.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.mp4

17.38 MB

005 CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4

17.32 MB

014 An ENUM with a DEFAULT value in a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.mp4

17.21 MB

009 CREATE TYPE - Create a composite inventory_item data type.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.mp4

16.87 MB

010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4

16.85 MB

004 CREATE DOMAIN - Create a domain data type for an email validation.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.mp4

14.47 MB

012 ALTER TYPE - Alter an ENUM data type.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.mp4

13.75 MB

003 CREATE DOMAIN - Create a postal code validation data type.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.mp4

11.2 MB

006 CREATE DOMAIN - Get the list of all DOMAIN data types.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.mp4

9.32 MB

002 CREATE DOMAIN - Create a data type for a positive number.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.mp4

8.57 MB

015 Create a type if not exists using a PL_pgSQL function.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.mp4

8.12 MB

013 Update an ENUM data in production server.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/013 Update an ENUM data in production server.en.srt

9.88 KB

001 CREATE DOMAIN - Create a DOMAIN data type, create an address.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.en.srt

9.06 KB

008 CREATE TYPE - Create a composite address object.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.en.srt

7.88 KB

007 CREATE DOMAIN - How to drop a domain data type.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.en.srt

7.2 KB

005 CREATE DOMAIN - Create a Enum or Set of values domain data type.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.en.srt

5.63 KB

009 CREATE TYPE - Create a composite inventory_item data type.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.en.srt

4.87 KB

010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.en.srt

4.69 KB

011 ALTER TYPE - Alter a composite data type, change schema and more.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.en.srt

4.49 KB

004 CREATE DOMAIN - Create a domain data type for an email validation.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.en.srt

4.05 KB

014 An ENUM with a DEFAULT value in a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.en.srt

4.02 KB

012 ALTER TYPE - Alter an ENUM data type.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.en.srt

3.76 KB

003 CREATE DOMAIN - Create a postal code validation data type.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.en.srt

3.67 KB

006 CREATE DOMAIN - Get the list of all DOMAIN data types.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.en.srt

3.25 KB

015 Create a type if not exists using a PL_pgSQL function.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.en.srt

2.88 KB

002 CREATE DOMAIN - Create a data type for a positive number.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.en.srt

2.64 KB

42 Using Human Resource (hr) database

48 files • 258.11 MB

013 Discard characters from employees email address.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/013 Discard characters from employees email address.mp4

32.13 MB

002 Quick overview of all tables.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/002 Quick overview of all tables.mp4

20.08 MB

004 Get highest, lowest, total, and average salaries of employees.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.mp4

14.7 MB

019 Select employees not in range.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/019 Select employees not in range.mp4

13.94 MB

003 Quick overview of all tables Part 2.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.mp4

13.7 MB

014 List all employees with first_name starts with letters _A_, _C_ or _M_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.mp4

12.61 MB

001 Human Resources Database Structure.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/001 Human Resources Database Structure.mp4

12.52 MB

011 Compute 15% of salary for all employees.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.mp4

12.25 MB

021 Update phone_number with your strings.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/021 Update phone_number with your strings.mp4

11.55 MB

020 Find Letter _C_ in last_name at 3rd or greater position.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.mp4

10.24 MB

007 Average salary for each department with more than 10 employees.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.mp4

9.98 MB

009 Maximum salary for each post where salary is at or above $5000.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.mp4

9.29 MB

018 Select employees with particular department id only.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/018 Select employees with particular department id only.mp4

8.95 MB

022 Get the monthly salary of each employees.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.mp4

8.72 MB

024 find employees whose names contains exactly six characters.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.mp4

8.63 MB

017 Get unique designations in employees table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/017 Get unique designations in employees table.mp4

8.62 MB

006 Get lowest paid salaries by each manager.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.mp4

8.35 MB

008 Average salary for each post excluding programmer.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.mp4

7.78 MB

015 String manipulation with upper, lower and initcap functions.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.mp4

7.18 MB

010 Using an alias name with columns.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/010 Using an alias name with columns.mp4

6.82 MB

023 Calculate average salary with total number of employees.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.mp4

6.72 MB

005 Difference b_w highest and lowest salaries by job_id.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.mp4

5.29 MB

012 To list all employees IDs within each job_id group.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.mp4

5.16 MB

016 Using SUBSTRING to get portion of string data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.mp4

2.82 MB

002 Quick overview of all tables.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/002 Quick overview of all tables.en.srt

7.14 KB

013 Discard characters from employees email address.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/013 Discard characters from employees email address.en.srt

7.03 KB

019 Select employees not in range.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/019 Select employees not in range.en.srt

4.95 KB

004 Get highest, lowest, total, and average salaries of employees.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.en.srt

4.91 KB

001 Human Resources Database Structure.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/001 Human Resources Database Structure.en.srt

4.54 KB

014 List all employees with first_name starts with letters _A_, _C_ or _M_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.en.srt

4.31 KB

003 Quick overview of all tables Part 2.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.en.srt

4.19 KB

021 Update phone_number with your strings.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/021 Update phone_number with your strings.en.srt

3.82 KB

011 Compute 15% of salary for all employees.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.en.srt

3.34 KB

024 find employees whose names contains exactly six characters.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.en.srt

3.32 KB

020 Find Letter _C_ in last_name at 3rd or greater position.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.en.srt

3.15 KB

018 Select employees with particular department id only.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/018 Select employees with particular department id only.en.srt

3.14 KB

007 Average salary for each department with more than 10 employees.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.en.srt

2.98 KB

022 Get the monthly salary of each employees.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.en.srt

2.9 KB

006 Get lowest paid salaries by each manager.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.en.srt

2.85 KB

009 Maximum salary for each post where salary is at or above $5000.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.en.srt

2.72 KB

017 Get unique designations in employees table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/017 Get unique designations in employees table.en.srt

2.53 KB

015 String manipulation with upper, lower and initcap functions.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.en.srt

2.48 KB

010 Using an alias name with columns.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/010 Using an alias name with columns.en.srt

2.23 KB

023 Calculate average salary with total number of employees.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.en.srt

2.09 KB

008 Average salary for each post excluding programmer.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.en.srt

1.94 KB

005 Difference b_w highest and lowest salaries by job_id.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.en.srt

1.6 KB

012 To list all employees IDs within each job_id group.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.en.srt

1.44 KB

016 Using SUBSTRING to get portion of string data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.en.srt

1.12 KB

02 Introduction to PostgreSQL

26 files • 177.59 MB

010 Install northwind database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/010 Install northwind database.mp4

31.65 MB

009 Install sample stocks market data.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/009 Install sample stocks market data.mp4

28.33 MB

002 Installing PostgreSQL on Windows.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.mp4

25.73 MB

001 Installing PostgreSQL on Mac.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.mp4

20.88 MB

011 Drop a database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/011 Drop a database.mp4

13.59 MB

004 Creating a Database User.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/004 Creating a Database User.mp4

11.59 MB

005 Creating a Database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/005 Creating a Database.mp4

10.58 MB

007 Install sample data files on server.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/007 Install sample data files on server.mp4

10.54 MB

008 Install Human Resources (hr) database.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.mp4

8.2 MB

003 Configure pgAdmin 4 client.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.mp4

7.56 MB

006 Running a query in pgAdmin tool.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.mp4

5.73 MB

010 sample_data.zip

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/010 sample_data.zip

1.41 MB

011 sample_data.zip

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/011 sample_data.zip

1.41 MB

012 northwind.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/012 northwind.sql

341.51 KB

002 Installing PostgreSQL on Windows.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.en.srt

8.45 KB

010 Install northwind database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/010 Install northwind database.en.srt

7.97 KB

004 Creating a Database User.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/004 Creating a Database User.en.srt

6.34 KB

011 Drop a database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/011 Drop a database.en.srt

5.02 KB

005 Creating a Database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/005 Creating a Database.en.srt

3.92 KB

007 Install sample data files on server.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/007 Install sample data files on server.en.srt

3.58 KB

008 Install Human Resources (hr) database.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.en.srt

3.14 KB

006 Running a query in pgAdmin tool.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.en.srt

3.12 KB

001 Installing PostgreSQL on Mac.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.en.srt

3.06 KB

003 Configure pgAdmin 4 client.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.en.srt

2.99 KB

009 Install sample stocks market data.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/009 Install sample stocks market data.en.srt

2.94 KB

009 sample_data.zip

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/02 Introduction to PostgreSQL/009 sample_data.zip

2.83 KB

43 Exploring Stock Markets Data

7 files • 51.37 MB

002 Select first or last records in a table.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/43 Exploring Stock Markets Data/002 Select first or last records in a table.mp4

24.2 MB

003 Get first or last record per each group.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/43 Exploring Stock Markets Data/003 Get first or last record per each group.mp4

20.3 MB

004 How to calculate cube root in PostgreSQL_.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.mp4

6.85 MB

003 Get first or last record per each group.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/43 Exploring Stock Markets Data/003 Get first or last record per each group.en.srt

5.18 KB

002 Select first or last records in a table.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/43 Exploring Stock Markets Data/002 Select first or last records in a table.en.srt

5.11 KB

004 How to calculate cube root in PostgreSQL_.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.en.srt

2.02 KB

001 Introduction To stock market data.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/43 Exploring Stock Markets Data/001 Introduction To stock market data.html

1.45 KB

01 Welcome

7 files • 7.83 MB

001 Course Introduction.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/01 Welcome/001 Course Introduction.mp4

5.58 MB

002 sample_data.zip

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/01 Welcome/002 sample_data.zip

1.41 MB

002 trades.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/01 Welcome/002 trades.sql

510.16 KB

002 northwind.sql

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/01 Welcome/002 northwind.sql

341.51 KB

002 countries_iso_codes.csv

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/01 Welcome/002 countries_iso_codes.csv

11.45 KB

001 Course Introduction.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/01 Welcome/001 Course Introduction.en.srt

1.72 KB

002 Sample Data Files.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/01 Welcome/002 Sample Data Files.html

1.31 KB

49 Thank You!

4 files • 2.41 MB

003 Thank You!.mp4

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/49 Thank You!/003 Thank You!.mp4

2.41 MB

001 Your feedback is very valuable.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/49 Thank You!/001 Your feedback is very valuable.html

1.48 KB

002 Upcoming course - Advanced Time Series Analysis.html

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/49 Thank You!/002 Upcoming course - Advanced Time Series Analysis.html

1.31 KB

003 Thank You!.en.srt

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]/49 Thank You!/003 Thank You!.en.srt

1.01 KB

Trackers (1)

udp://tracker.opentrackr.org:1337/announce

0 0

Similar Torrents 15

Based on tags and category

[ CourseHulu.com ] Udemy - Super Affiliate Playbook - Insider CPA Marketing Secrets 2021.zip

Video

2.38 GB

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]

Torrent Information

Global Parameters

Identification Hash

Community Trust & Feedback

Files (1260)

Trackers (1)

Similar Torrents 15

[ CourseHulu.com ] Udemy - Super Affiliate Playbook - Insider CPA Marketing Secrets 2021.zip

[ CourseLala.com ] Udemy - PHP Build a Complete API.zip

Advanced SystemCare Pro 18.0.1.158

DAEMON Tools Pro Advanced v13.4.0. 0354 Including Crack

DAEMON Tools Pro Advanced v14.8.0. 0357 Including Crack

IObit Advanced System Care Pro v20.2.7.1378 Setup + Serial

IObit Advanced System Care Pro v19.8.3.1361 + Fast Install.zip

IObit Advanced System Care Pro v21.15.0.1209 Setup + Serial

IObit Advanced System Care Pro v19.8.3.1361 Setup + Serial

Advanced SystemCare Ultimate v16.1.01.16 +Patch [New Veresion]

Advanced SystemCare Ultimate 13.1.0.119 Multilingual + Medicine

IObit Advanced System Care Pro v20.2.7.1378 Setup + Serial

FTL: Faster Than Light Advanced Edition v1.5.13a-GOG

iZotope RX 10 Audio Editor Advanced 2024 v10.5.0 Pre-Activated [New 2024]

Enter the Gungeon Advanced Gungeons and Draguns-TiNYiSO