| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| [1] Calculate the median value of a dataset.mp4 | 14.4 MB | ||
| [1] Calculate the median value of a dataset.srt | 10.7 KB | ||
| [1] Create a window function with an OVER clause.mp4 | 9.3 MB | ||
| [1] Create a window function with an OVER clause.srt | 6.8 KB | ||
| [1] Define values with CASE statements.mp4 | 14.9 MB | ||
| [1] Define values with CASE statements.srt | 11.5 KB | ||
| [1] Gain additional insights from your PostgreSQL data.mp4 | 5.1 MB | ||
| [1] Gain additional insights from your PostgreSQL data.srt | 1.7 KB | ||
| [1] Next steps.mp4 | 2 MB | ||
| [1] Next steps.srt | 1.7 KB | ||
| [1] Output row numbers with query results.mp4 | 5.8 MB | ||
| [1] Output row numbers with query results.srt | 4.1 KB | ||
| [1] Rank rows with a window function.mp4 | 15.3 MB | ||
| [1] Rank rows with a window function.srt | 10.6 KB | ||
| [1] Using GROUP BY to aggregate data rows.mp4 | 17.8 MB | ||
| [1] Using GROUP BY to aggregate data rows.srt | 12.9 KB | ||
| [2] Calculate the first and third quartiles of a dataset.mp4 | 15.4 MB | ||
| [2] Calculate the first and third quartiles of a dataset.srt | 9.5 KB | ||
| [2] Cast values to a different data type.mp4 | 5 MB | ||
| [2] Cast values to a different data type.srt | 3.8 KB | ||
| [2] Find a hypothetical rank.mp4 | 10.2 MB | ||
| [2] Find a hypothetical rank.srt | 7 KB | ||
| [2] Merge columns with COALESCE.mp4 | 9 MB | ||
| [2] Merge columns with COALESCE.srt | 6.1 KB | ||
| [2] Obtain general-purpose aggregate statistics.mp4 | 13.5 MB | ||
| [2] Obtain general-purpose aggregate statistics.srt | 9 KB | ||
| [2] Partition rows within a window.mp4 | 11.1 MB | ||
| [2] Partition rows within a window.srt | 7.2 KB | ||
| [2] What you should know.mp4 | 1.6 MB | ||
| [2] What you should know.srt | 1.4 KB | ||
| [3] Convert values to null with NULLIF.mp4 | 7.6 MB | ||
| [3] Convert values to null with NULLIF.srt | 5.4 KB | ||
| [3] Evaluate columns with Boolean aggregates.mp4 | 11 MB | ||
| [3] Evaluate columns with Boolean aggregates.srt | 7.7 KB | ||
| [3] Find the most frequent value within a dataset with MODE.mp4 | 7 MB | ||
| [3] Find the most frequent value within a dataset with MODE.srt | 4.5 KB | ||
| [3] Move rows within a result with LEAD and LAG.mp4 | 15.9 MB | ||
| [3] Move rows within a result with LEAD and LAG.srt | 9.7 KB | ||
| [3] Streamline partition queries with a WINDOW clause.mp4 | 7 MB | ||
| [3] Streamline partition queries with a WINDOW clause.srt | 4.8 KB | ||
| [3] Using the exercise files.mp4 | 6.2 MB | ||
| [3] Using the exercise files.srt | 4.9 KB | ||
| [3] View top performers with percentile ranks.mp4 | 13.1 MB | ||
| [3] View top performers with percentile ranks.srt | 8.5 KB | ||
| [4] Determine the range of values within a dataset.mp4 | 5.1 MB | ||
| [4] Determine the range of values within a dataset.srt | 3.8 KB | ||
| [4] Evaluate probability with cumulative distribution.mp4 | 7.4 MB | ||
| [4] Evaluate probability with cumulative distribution.srt | 4.7 KB | ||
| [4] Find the standard deviation and variance of a dataset.mp4 | 13.5 MB | ||
| [4] Find the standard deviation and variance of a dataset.srt | 8.8 KB | ||
| [4] Ordering data within a partition.mp4 | 13.2 MB | ||
| [4] Ordering data within a partition.srt | 8.3 KB | ||
| [4] Use an IN function with a subquery.mp4 | 10.5 MB | ||
| [4] Use an IN function with a subquery.srt | 6.8 KB | ||
| [5] Calculate a moving average with a sliding window.mp4 | 11.6 MB | ||
| [5] Calculate a moving average with a sliding window.srt | 7.4 KB | ||
| [5] Challenge Evaluate rankings within a dataset.mp4 | 1.4 MB | ||
| [5] Challenge Evaluate rankings within a dataset.srt | 1 KB | ||
| [5] Challenge Retrieve statistics of a dataset with groups.mp4 | 1.8 MB | ||
| [5] Challenge Retrieve statistics of a dataset with groups.srt | 1.4 KB | ||
| [5] Define WHERE criteria with a series.mp4 | 10.8 MB | ||
| [5] Define WHERE criteria with a series.srt | 7.8 KB | ||
| [5] Include overall aggregates with ROLLUP.mp4 | 11.3 MB | ||
| [5] Include overall aggregates with ROLLUP.srt | 7.8 KB | ||
| [6] Challenge Calculations across rows.mp4 | 1.4 MB | ||
| [6] Challenge Calculations across rows.srt | 921.6 B | ||
| [6] Return all possible combinations of groups with CUBE.mp4 | 9.5 MB | ||
| [6] Return all possible combinations of groups with CUBE.srt | 6.2 KB | ||
| [6] Return values at specific locations within a window.mp4 | 20.2 MB | ||
| [6] Return values at specific locations within a window.srt | 13 KB | ||
| [6] Solution Evaluate rankings within a dataset.mp4 | 15.1 MB | ||
| [6] Solution Evaluate rankings within a dataset.srt | 9.9 KB | ||
| [6] Solution Retrieve statistics of a dataset with groups.mp4 | 15 MB | ||
| [6] Solution Retrieve statistics of a dataset with groups.srt | 10 KB | ||
| [7] Challenge Leverage window functions.mp4 | 2.2 MB | ||
| [7] Challenge Leverage window functions.srt | 1.6 KB | ||
| [7] Segmenting groups with aggregate filters.mp4 | 12.9 MB | ||
| [7] Segmenting groups with aggregate filters.srt | 8 KB | ||
| [7] Solution Calculations across rows.mp4 | 12.7 MB | ||
| [7] Solution Calculations across rows.srt | 8.4 KB | ||
| [8] Challenge Group statistics.mp4 | 2.7 MB | ||
| [8] Challenge Group statistics.srt | 2 KB | ||
| [8] Solution Leverage window functions.mp4 | 12.5 MB | ||
| [8] Solution Leverage window functions.srt | 9 KB | ||
| [9] Solution Group statistics.mp4 | 19.2 MB | ||
| [9] Solution Group statistics.srt | 13.4 KB | ||
| aggregate_function_complete.txt | 307.2 B | ||
| boolean_complete.txt | 204.8 B | ||
| case_complete.txt | 307.2 B | ||
| cast_complete.txt | 102.4 B | ||
| challenge_five_complete.txt | 307.2 B | ||
| challenge_four_complete.txt | 409.6 B | ||
| challenge_one_complete.txt | 512 B | ||
| challenge_three_complete.txt | 409.6 B | ||
| challenge_two_complete.txt | 204.8 B | ||
| coalesce_complete.txt | 204.8 B | ||
| cube_complete.txt | 204.8 B | ||
| cumulative_distribution_complete.txt | 204.8 B | ||
| filters_complete.txt | 409.6 B | ||
| group_by_complete.txt | 204.8 B | ||
| in_function_complete.txt | 512 B | ||
| lead_lag_complete.txt | 409.6 B | ||
| locations_complete.txt | 819.2 B | ||
| median_complete.txt | 204.8 B | ||
| mode_complete.txt | 204.8 B | ||
| moving_average_complete.txt | 409.6 B | ||
| nullif_complete.txt | 204.8 B | ||
| order_window_complete.txt | 512 B | ||
| over_complete.txt | 102.4 B | ||
| partition_complete.txt | 307.2 B | ||
| people_heights.txt | 12.2 KB | ||
| quartile_complete.txt | 512 B | ||
| range_complete.txt | 102.4 B | ||
| rank_hypothetical_complete.txt | 307.2 B | ||
| rank_percentile_complete.txt | 409.6 B | ||
| rank_window_complete.txt | 307.2 B | ||
| rollup_complete.txt | 204.8 B | ||
| row_numbers_complete.txt | 204.8 B | ||
| series_complete.txt | 204.8 B | ||
| standard_deviation_complete.txt | 204.8 B | ||
| two_trees_database.txt | 14.8 KB | ||
| window_complete.txt | 204.8 B | ||
| ▲ 124 total files | |||
PostgreSQL: Advanced Queries
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.7 GB | freecoursewb | 1 week | 0 | 0 | |
| 2 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 1.5 GB | freecoursewb | 3 weeks | 0 | 0 | |
| 1.4 GB | freecoursewb | 1 month | 4 | 2 | |
|
Linkedin - AWS Certified Advanced Networking Specialty ANS-C01 Cert Prep Posted by
xHOBBiTx in Other
|
3 GB | xHOBBiTx | 5 months | 16 | 6 |
All Comments