17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Skill Level: Advanced | Genre: eLearning | Language: English + srt | Duration: 2h 50m | Size: 386.6 MB In this course, database expert Adam Wilbert introduces you to a number of advanced query techniques that you can use to better understand your data. Statistical analyses involve understanding the shape and size of the full data set, and deeper insights can be gained by grouping data together to obtain some very useful metrics. Adam shows you how to create basic groups and apply aggregate calculations, then moves into window functions that create subgroups for more granular analysis. He goes over statistics that are based on sorted data within groups, such as the median value, the first and third quartiles of a dataset, the most frequent value, and more. Adam also covers ranking, hypothetical sets, percentile functions, and conditional expressions for further manipulating query result sets. He concludes with some additional querying techniques that you may find useful in solving common problems.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/Bonus Resources.txt
357 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 0/two_trees_database.txt
14.8 KB
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 1/aggregate_function_complete.txt
300 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 1/boolean_complete.txt
227 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 1/challenge_one_complete.txt
542 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 1/cube_complete.txt
225 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 1/filters_complete.txt
431 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 1/group_by_complete.txt
242 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 1/people_heights.txt
12.2 KB
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 1/rollup_complete.txt
251 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 1/standard_deviation_complete.txt
236 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 2/challenge_two_complete.txt
245 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 2/locations_complete.txt
801 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 2/moving_average_complete.txt
369 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 2/order_window_complete.txt
486 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 2/over_complete.txt
89 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 2/partition_complete.txt
334 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 2/window_complete.txt
221 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 3/challenge_three_complete.txt
452 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 3/median_complete.txt
234 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 3/mode_complete.txt
192 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 3/quartile_complete.txt
495 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 3/range_complete.txt
130 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 4/challenge_four_complete.txt
391 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 4/cumulative_distribution_complete.txt
195 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 4/rank_hypothetical_complete.txt
266 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 4/rank_percentile_complete.txt
417 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 4/rank_window_complete.txt
270 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 5/case_complete.txt
285 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 5/coalesce_complete.txt
237 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 5/nullif_complete.txt
167 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 6/cast_complete.txt
70 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 6/challenge_five_complete.txt
264 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 6/in_function_complete.txt
488 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 6/lead_lag_complete.txt
403 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 6/row_numbers_complete.txt
155 B
~Get Your Files Here !/Ex_Files_PostgreSQL_Advanced_Queries/Exercise Files/Chapter 6/series_complete.txt
159 B
~Get Your Files Here !/[1] Introduction/[1] Gain additional insights from your PostgreSQL data.mp4
5.1 MB
~Get Your Files Here !/[1] Introduction/[1] Gain additional insights from your PostgreSQL data.srt
1.7 KB
~Get Your Files Here !/[1] Introduction/[2] What you should know.mp4
1.6 MB
~Get Your Files Here !/[1] Introduction/[2] What you should know.srt
1.4 KB
~Get Your Files Here !/[1] Introduction/[3] Using the exercise files.mp4
6.2 MB
~Get Your Files Here !/[1] Introduction/[3] Using the exercise files.srt
4.9 KB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[1] Using GROUP BY to aggregate data rows.mp4
17.8 MB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[1] Using GROUP BY to aggregate data rows.srt
12.9 KB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[2] Obtain general-purpose aggregate statistics.mp4
13.5 MB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[2] Obtain general-purpose aggregate statistics.srt
9 KB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[3] Evaluate columns with Boolean aggregates.mp4
11 MB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[3] Evaluate columns with Boolean aggregates.srt
7.7 KB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[4] Find the standard deviation and variance of a dataset.mp4
13.5 MB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[4] Find the standard deviation and variance of a dataset.srt
8.8 KB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[5] Include overall aggregates with ROLLUP.mp4
11.3 MB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[5] Include overall aggregates with ROLLUP.srt
7.8 KB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[6] Return all possible combinations of groups with CUBE.mp4
9.5 MB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[6] Return all possible combinations of groups with CUBE.srt
6.2 KB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[7] Segmenting groups with aggregate filters.mp4
12.9 MB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[7] Segmenting groups with aggregate filters.srt
8 KB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[8] Challenge Group statistics.mp4
2.7 MB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[8] Challenge Group statistics.srt
2 KB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[9] Solution Group statistics.mp4
19.2 MB
~Get Your Files Here !/[2] 1. Obtain Summary Statistics by Grouping Rows/[9] Solution Group statistics.srt
13.4 KB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[1] Create a window function with an OVER clause.mp4
9.3 MB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[1] Create a window function with an OVER clause.srt
6.8 KB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[2] Partition rows within a window.mp4
11.1 MB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[2] Partition rows within a window.srt
7.2 KB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[3] Streamline partition queries with a WINDOW clause.mp4
7 MB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[3] Streamline partition queries with a WINDOW clause.srt
4.8 KB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[4] Ordering data within a partition.mp4
13.2 MB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[4] Ordering data within a partition.srt
8.3 KB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[5] Calculate a moving average with a sliding window.mp4
11.6 MB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[5] Calculate a moving average with a sliding window.srt
7.4 KB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[6] Return values at specific locations within a window.mp4
20.2 MB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[6] Return values at specific locations within a window.srt
13 KB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[7] Challenge Leverage window functions.mp4
2.2 MB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[7] Challenge Leverage window functions.srt
1.6 KB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[8] Solution Leverage window functions.mp4
12.5 MB
~Get Your Files Here !/[3] 2. Use Window Functions to Perform Calculations across Row Sets/[8] Solution Leverage window functions.srt
9 KB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[1] Calculate the median value of a dataset.mp4
14.4 MB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[1] Calculate the median value of a dataset.srt
10.7 KB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[2] Calculate the first and third quartiles of a dataset.mp4
15.4 MB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[2] Calculate the first and third quartiles of a dataset.srt
9.5 KB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[3] Find the most frequent value within a dataset with MODE.mp4
7 MB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[3] Find the most frequent value within a dataset with MODE.srt
4.5 KB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[4] Determine the range of values within a dataset.mp4
5.1 MB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[4] Determine the range of values within a dataset.srt
3.8 KB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[5] Challenge Retrieve statistics of a dataset with groups.mp4
1.8 MB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[5] Challenge Retrieve statistics of a dataset with groups.srt
1.4 KB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[6] Solution Retrieve statistics of a dataset with groups.mp4
15 MB
~Get Your Files Here !/[4] 3. Statistics Based on Sorted Data within Groups/[6] Solution Retrieve statistics of a dataset with groups.srt
10 KB
~Get Your Files Here !/[5] 4. Ranking Data with Windows and Hypothetical Sets/[1] Rank rows with a window function.mp4
15.3 MB
~Get Your Files Here !/[5] 4. Ranking Data with Windows and Hypothetical Sets/[1] Rank rows with a window function.srt
10.6 KB
~Get Your Files Here !/[5] 4. Ranking Data with Windows and Hypothetical Sets/[2] Find a hypothetical rank.mp4
10.2 MB
~Get Your Files Here !/[5] 4. Ranking Data with Windows and Hypothetical Sets/[2] Find a hypothetical rank.srt
7 KB
~Get Your Files Here !/[5] 4. Ranking Data with Windows and Hypothetical Sets/[3] View top performers with percentile ranks.mp4
13.1 MB
~Get Your Files Here !/[5] 4. Ranking Data with Windows and Hypothetical Sets/[3] View top performers with percentile ranks.srt
8.5 KB
~Get Your Files Here !/[5] 4. Ranking Data with Windows and Hypothetical Sets/[4] Evaluate probability with cumulative distribution.mp4
7.4 MB
~Get Your Files Here !/[5] 4. Ranking Data with Windows and Hypothetical Sets/[4] Evaluate probability with cumulative distribution.srt
4.7 KB
~Get Your Files Here !/[5] 4. Ranking Data with Windows and Hypothetical Sets/[5] Challenge Evaluate rankings within a dataset.mp4
![[ CourseBoat.com ] Linkedin - PostgreSQL - Advanced Queries](https://f.0c.mom/cover/40068092.webp)
