|
RAR-files |
| linkedin.learning.postgresql.advanced.queries-xqzt.rar |
50,000,000 |
40B40791 |
| linkedin.learning.postgresql.advanced.queries-xqzt.r00 |
50,000,000 |
1FF57CFA |
| linkedin.learning.postgresql.advanced.queries-xqzt.r01 |
50,000,000 |
17D3275C |
| linkedin.learning.postgresql.advanced.queries-xqzt.r02 |
50,000,000 |
F11C1899 |
| linkedin.learning.postgresql.advanced.queries-xqzt.r03 |
50,000,000 |
AB5D3D2D |
| linkedin.learning.postgresql.advanced.queries-xqzt.r04 |
50,000,000 |
90421508 |
| linkedin.learning.postgresql.advanced.queries-xqzt.r05 |
50,000,000 |
F747E288 |
| linkedin.learning.postgresql.advanced.queries-xqzt.r06 |
50,000,000 |
115A7462 |
| linkedin.learning.postgresql.advanced.queries-xqzt.r07 |
36,907,622 |
44D7EF59 |
|
| Total size: |
436,907,622 |
|
|
| Archived
files |
|
01.01-gain_additional_insights_from_your_postgresql_data.mkv
[13d896e061a5df1d]
|
5,238,325 |
09E939CD |
|
01.02-what_you_should_know.mkv
[96518c51a0a2eb6c]
|
1,673,016 |
9681D7E9 |
|
01.03-using_the_exercise_files.mkv
[8a54a02d07ed76e9]
|
6,267,330 |
A6BF63F3 |
|
02.01-using_group_by_to_aggregate_data_rows.mkv
[1067dda31621a304]
|
18,145,270 |
24B5B3A8 |
|
02.02-obtain_general-purpose_aggregate_statistics.mkv
[c1a5633ab7c73495]
|
13,799,279 |
1272E1D5 |
|
02.03-evaluate_columns_with_boolean_aggregates.mkv
[e536eecfa34e18bb]
|
11,253,695 |
FF5EA8DE |
|
02.04-find_the_standard_deviation_and_variance_of_a_dataset.mkv
[86fc026233005e13]
|
13,755,421 |
2196C225 |
|
02.05-include_overall_aggregates_with_rollup.mkv
[d1a6d241367cbfa1]
|
11,569,209 |
4D8767FF |
|
02.06-return_all_possible_combinations_of_groups_with_cube.mkv
[28e15fb990402f16]
|
9,668,167 |
86B39E40 |
|
02.07-segmenting_groups_with_aggregate_filters.mkv
[9df12fdf9d39317c]
|
13,159,135 |
7D8B44D1 |
|
02.08-challenge_group_statistics.mkv
[754055cd58a72494]
|
2,712,809 |
9126EB83 |
|
02.09-solution_group_statistics.mkv
[6c1acbddfa85bab5]
|
19,532,027 |
FC09F0D7 |
|
03.01-create_a_window_function_with_an_over_clause.mkv
[95d07e6e816b9336]
|
9,436,500 |
25BA611C |
|
03.02-partition_rows_within_a_window.mkv
[b15d684fb390c165]
|
11,331,624 |
113A8B18 |
|
03.03-streamline_partition_queries_with_a_window_clause.mkv
[90a2000a458b8e04]
|
7,101,176 |
F8B8AC81 |
|
03.04-ordering_data_within_a_partition.mkv
[aefc52e4f6da628e]
|
13,501,298 |
88B72357 |
|
03.05-calculate_a_moving_average_with_a_sliding_window.mkv
[b06b72a8c32479ca]
|
11,853,816 |
F2651FBA |
|
03.06-return_values_at_specific_locations_within_a_window.mkv
[9aa07598aa44341c]
|
20,660,141 |
A2E8C06A |
|
03.07-challenge_leverage_window_functions.mkv
[185b0a4c21811a19]
|
2,260,857 |
2021CF43 |
|
03.08-solution_leverage_window_functions.mkv
[130ee6824abb8f03]
|
12,780,434 |
43226199 |
|
04.01-calculate_the_median_value_of_a_dataset.mkv
[65d27390f2a59b46]
|
14,646,173 |
23249C38 |
|
04.02-calculate_the_first_and_third_quartiles_of_a_dataset.mkv
[89aacfd3664c7e30]
|
15,777,811 |
C6FCA42B |
|
04.03-find_the_most_frequent_value_within_a_dataset_with_mode.mkv
[41f7d4af786af954]
|
7,095,586 |
B8A562DD |
|
04.04-determine_the_range_of_values_within_a_dataset.mkv
[e1005a0e1904ec73]
|
5,216,100 |
3F4C835A |
|
04.05-challenge_retrieve_statistics_of_a_dataset_with_groups.mkv
[e2b6b13980e8045b]
|
1,883,503 |
963580FA |
|
04.06-solution_retrieve_statistics_of_a_dataset_with_groups.mkv
[e19f0e00d4f29658]
|
15,299,429 |
C59FC185 |
|
05.01-rank_rows_with_a_window_function.mkv
[f89a89097f492fdb]
|
15,634,064 |
C225FED6 |
|
05.02-find_a_hypothetical_rank.mkv
[36733e6b889c5474]
|
10,420,741 |
593FD791 |
|
05.03-view_top_performers_with_percentile_ranks.mkv
[960050be9bcc6084]
|
13,376,967 |
6D58BCAC |
|
05.04-evaluate_probability_with_cumulative_distribution.mkv
[a18f267418b4fc5c]
|
7,593,124 |
1ED1DE9E |
|
05.05-challenge_evaluate_rankings_within_a_dataset.mkv
[c26d4f01e77863c9]
|
1,445,661 |
B1466FE3 |
|
05.06-solution_evaluate_rankings_within_a_dataset.mkv
[778ad4a73b293c89]
|
15,454,662 |
6492A2DF |
|
06.01-define_values_with_case_statements.mkv
[9d5e11e922460cfc]
|
15,128,747 |
7292B5FD |
|
06.02-merge_columns_with_coalesce.mkv
[84f381779316e82e]
|
9,175,920 |
BCE5099B |
|
06.03-convert_values_to_null_with_nullif.mkv
[ff6d1ec714ff3931]
|
7,723,545 |
67C7371A |
|
07.01-output_row_numbers_with_query_results.mkv
[ee97d31aa64582cf]
|
5,955,029 |
4FAE7C0A |
|
07.02-cast_values_to_a_different_data_type.mkv
[5fbdda245ff7eebb]
|
5,138,665 |
C9D3B867 |
|
07.03-move_rows_within_a_result_with_lead_and_lag.mkv
[d8330e324261a661]
|
16,237,704 |
FADF54C6 |
|
07.04-use_an_in_function_with_a_subquery.mkv
[5aa21e5ea09bcb9]
|
10,713,381 |
C087B1E0 |
|
07.05-define_where_criteria_with_a_series.mkv
[83e7e250455e2cf6]
|
10,951,301 |
A4B2E199 |
|
07.06-challenge_calculations_across_rows.mkv
[48bd888c707122e0]
|
1,384,181 |
3F0BFEE2 |
|
07.07-solution_calculations_across_rows.mkv
[d121083778f16eec]
|
12,925,633 |
52E45C1F |
|
08.01-next_steps.mkv
[90b9ea05166d4848]
|
1,999,614 |
CD913495 |
|
Ex_Files_PostgreSQL_Advanced_Queries.zip |
25,731 |
04C48AA2 |
|
| Total size: |
436,902,801 |
|
|
