Download Linkedin - PostgreSQL - Advanced Queries torrent

Linkedin - PostgreSQL - Advanced Queries

Torrent:	Linkedin - PostgreSQL - Advanced Queries
Description:	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.
Downloads:	69
Category:	Other /Tutorials
Size:	428.5 MB
Show Files »	[ CourseBoat.com ] Linkedin - PostgreSQL - Advanced Queries Get Bonus Downloads Here.url (0.2 KB) ~Get Your Files Here ! Bonus Resources.txt (0.3 KB) Ex_Files_PostgreSQL_Advanced_Queries Exercise Files Chapter 0 two_trees_database.txt (14.8 KB) Chapter 1 aggregate_function_complete.txt (0.3 KB) boolean_complete.txt (0.2 KB) challenge_one_complete.txt (0.5 KB) cube_complete.txt (0.2 KB) filters_complete.txt (0.4 KB) group_by_complete.txt (0.2 KB) people_heights.txt (12.2 KB) rollup_complete.txt (0.2 KB) standard_deviation_complete.txt (0.2 KB) Chapter 2 challenge_two_complete.txt (0.2 KB) locations_complete.txt (0.8 KB) moving_average_complete.txt (0.4 KB) order_window_complete.txt (0.5 KB) over_complete.txt (0.1 KB) partition_complete.txt (0.3 KB) window_complete.txt (0.2 KB) Chapter 3 challenge_three_complete.txt (0.4 KB) median_complete.txt (0.2 KB) mode_complete.txt (0.2 KB) quartile_complete.txt (0.5 KB) range_complete.txt (0.1 KB) Chapter 4 challenge_four_complete.txt (0.4 KB) cumulative_distribution_complete.txt (0.2 KB) rank_hypothetical_complete.txt (0.3 KB) rank_percentile_complete.txt (0.4 KB) rank_window_complete.txt (0.3 KB) Chapter 5 case_complete.txt (0.3 KB) coalesce_complete.txt (0.2 KB) nullif_complete.txt (0.2 KB) Chapter 6 cast_complete.txt (0.1 KB) challenge_five_complete.txt (0.3 KB) in_function_complete.txt (0.5 KB) lead_lag_complete.txt (0.4 KB) row_numbers_complete.txt (0.2 KB) series_complete.txt (0.2 KB) [1] Introduction [1] Gain additional insights from your PostgreSQL data.mp4 (5.1 MB) [1] Gain additional insights from your PostgreSQL data.srt (1.7 KB) [2] What you should know.mp4 (1.6 MB) [2] What you should know.srt (1.4 KB) [3] Using the exercise files.mp4 (6.2 MB) [3] Using the exercise files.srt (4.9 KB) [2] 1. Obtain Summary Statistics by Grouping Rows [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] Obtain general-purpose aggregate statistics.mp4 (13.5 MB) [2] Obtain general-purpose aggregate statistics.srt (9.0 KB) [3] Evaluate columns with Boolean aggregates.mp4 (11.0 MB) [3] Evaluate columns with Boolean aggregates.srt (7.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) [5] Include overall aggregates with ROLLUP.mp4 (11.3 MB) [5] Include overall aggregates with ROLLUP.srt (7.8 KB) [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) [7] Segmenting groups with aggregate filters.mp4 (12.9 MB) [7] Segmenting groups with aggregate filters.srt (8.0 KB) [8] Challenge Group statistics.mp4 (2.7 MB) [8] Challenge Group statistics.srt (2.0 KB) [9] Solution Group statistics.mp4 (19.2 MB) [9] Solution Group statistics.srt (13.4 KB) [3] 2. Use Window Functions to Perform Calculations across Row Sets [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) [2] Partition rows within a window.mp4 (11.1 MB) [2] Partition rows within a window.srt (7.2 KB) [3] Streamline partition queries with a WINDOW clause.mp4 (7.0 MB) [3] Streamline partition queries with a WINDOW clause.srt (4.8 KB) [4] Ordering data within a partition.mp4 (13.2 MB) [4] Ordering data within a partition.srt (8.3 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) [6] Return values at specific locations within a window.mp4 (20.2 MB) [6] Return values at specific locations within a window.srt (13.0 KB) [7] Challenge Leverage window functions.mp4 (2.2 MB) [7] Challenge Leverage window functions.srt (1.6 KB) [8] Solution Leverage window functions.mp4 (12.5 MB) [8] Solution Leverage window functions.srt (9.0 KB) [4] 3. Statistics Based on Sorted Data within Groups [1] Calculate the median value of a dataset.mp4 (14.4 MB) [1] Calculate the median value of a dataset.srt (10.7 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) [3] Find the most frequent value within a dataset with MODE.mp4 (7.0 MB) [3] Find the most frequent value within a dataset with MODE.srt (4.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) [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) [6] Solution Retrieve statistics of a dataset with groups.mp4 (15.0 MB) [6] Solution Retrieve statistics of a dataset with groups.srt (10.0 KB) [5] 4. Ranking Data with Windows and Hypothetical Sets [1] Rank rows with a window function.mp4 (15.3 MB) [1] Rank rows with a window function.srt (10.6 KB) [2] Find a hypothetical rank.mp4 (10.2 MB) [2] Find a hypothetical rank.srt (7.0 KB) [3] View top performers with percentile ranks.mp4 (13.1 MB) [3] View top performers with percentile ranks.srt ( files
Added:	2021-10-02 11:03:56
Language:	English
Peers:	Seeders : 9 , Leechers : 1
Release name:	Linkedin - PostgreSQL - Advanced Queries
Trackers:	udp://tracker.torrent.eu.org:451/announce udp://tracker.tiny-vps.com:6969/announce http://tracker.foreverpirates.co:80/announce udp://tracker.cyberia.is:6969/announce udp://exodus.desync.com:6969/announce udp://explodie.org:6969/announce udp://tracker.opentrackr.org:1337/announce udp://9.rarbg.to:2780/announce udp://tracker.internetwarriors.net:1337/announce udp://ipv4.tracker.harry.lu:80/announce udp://open.stealth.si:80/announce udp://9.rarbg.to:2900/announce udp://9.rarbg.me:2720/announce udp://opentor.org:2710/announce