Linkedin Learning PostgreSQL Advanced Queries-XQZT

Another exquisit release
Linkedin.Learning.PostgreSQL.Advanced.Queries-XQZT
     Title: PostgreSQL: Advanced Queries
 Publisher: Linkedin Learning
  Category: N/A
      Size: 420M
     Files: 9F
      Date: 2021-09-29
  Course #: 2889116
 Published: Linkedin.Learning
   Updated: N/A
       URL: https://linkedin.com/learning/postgresql-advanced-queries
    Author: Adam Wilbert
  Duration: 2:50:40
 Exer/Code: [X]
Installation:
Unpack that shit, run that shit
Description:
Find out about the range of statistical functions and
techniques that are available for analyzing data stored within a
PostgreSQL database.

5.0M	01.01-gain_additional_insights_from_your_postgresql_data.mkv
1.6M	01.02-what_you_should_know.mkv
6.0M	01.03-using_the_exercise_files.mkv
18M	02.01-using_group_by_to_aggregate_data_rows.mkv
14M	02.02-obtain_general-purpose_aggregate_statistics.mkv
11M	02.03-evaluate_columns_with_boolean_aggregates.mkv
14M	02.04-find_the_standard_deviation_and_variance_of_a_dataset.mkv
12M	02.05-include_overall_aggregates_with_rollup.mkv
9.3M	02.06-return_all_possible_combinations_of_groups_with_cube.mkv
13M	02.07-segmenting_groups_with_aggregate_filters.mkv
2.6M	02.08-challenge_group_statistics.mkv
19M	02.09-solution_group_statistics.mkv
9.0M	03.01-create_a_window_function_with_an_over_clause.mkv
11M	03.02-partition_rows_within_a_window.mkv
6.8M	03.03-streamline_partition_queries_with_a_window_clause.mkv
13M	03.04-ordering_data_within_a_partition.mkv
12M	03.05-calculate_a_moving_average_with_a_sliding_window.mkv
20M	03.06-return_values_at_specific_locations_within_a_window.mkv
2.2M	03.07-challenge_leverage_window_functions.mkv
13M	03.08-solution_leverage_window_functions.mkv
14M	04.01-calculate_the_median_value_of_a_dataset.mkv
16M	04.02-calculate_the_first_and_third_quartiles_of_a_dataset.mkv
6.8M	04.03-find_the_most_frequent_value_within_a_dataset_with_mode.mkv
5.0M	04.04-determine_the_range_of_values_within_a_dataset.mkv
1.8M	04.05-challenge_retrieve_statistics_of_a_dataset_with_groups.mkv
15M	04.06-solution_retrieve_statistics_of_a_dataset_with_groups.mkv
15M	05.01-rank_rows_with_a_window_function.mkv
10M	05.02-find_a_hypothetical_rank.mkv
13M	05.03-view_top_performers_with_percentile_ranks.mkv
7.3M	05.04-evaluate_probability_with_cumulative_distribution.mkv
1.4M	05.05-challenge_evaluate_rankings_within_a_dataset.mkv
15M	05.06-solution_evaluate_rankings_within_a_dataset.mkv
15M	06.01-define_values_with_case_statements.mkv
8.8M	06.02-merge_columns_with_coalesce.mkv
7.4M	06.03-convert_values_to_null_with_nullif.mkv
5.7M	07.01-output_row_numbers_with_query_results.mkv
5.0M	07.02-cast_values_to_a_different_data_type.mkv
16M	07.03-move_rows_within_a_result_with_lead_and_lag.mkv
11M	07.04-use_an_in_function_with_a_subquery.mkv
11M	07.05-define_where_criteria_with_a_series.mkv
1.4M	07.06-challenge_calculations_across_rows.mkv
13M	07.07-solution_calculations_across_rows.mkv
2.0M	08.01-next_steps.mkv
28K	Ex_Files_PostgreSQL_Advanced_Queries.zip
417M	total