Linkedin Learning Intermediate SQL for Data Scientists-XQZT

Another exquisit release
Linkedin.Learning.Intermediate.SQL.for.Data.Scientists-XQZT
     Title: Intermediate SQL for Data Scientists
 Publisher: Linkedin Learning
  Category: N/A
      Size: 421M
     Files: 9F
      Date: 2021-07-20
  Course #: 2875265
 Published: Linkedin.Learning
   Updated: N/A
       URL: https://linkedin.com/learning/intermediate-sql-for-data-scientists
    Author: Dan Sullivan
  Duration: 2:38:49
 Exer/Code: [X]
Installation:
Unpack that shit, run that shit
Description:
Dive into one of the most important data science tools: SQL.
Learn how to use joins and subqueries, statistical
functions, window functions, and much more.

2.9M	01.01-the_need_for_sql_in_data_science.mkv
1.1M	01.02-what_you_should_know.mkv
18M	02.01-overview_of_data_science_operations.mkv
6.0M	02.02-data_manipulation_commands.mkv
7.8M	02.03-data_definition_commands.mkv
3.5M	02.04-sql_standards.mkv
7.2M	02.05-installing_postgresql.mkv
21M	03.01-loading_data.mkv
16M	03.02-basic_aggregate_functions.mkv
17M	03.03-statistical_aggregate_functions.mkv
16M	03.04-grouping_and_filtering_data.mkv
22M	03.05-joining_and_filtering_data.mkv
548K	03.06-challenge_test_an_attribute_for_normal_distribution.mkv
2.5M	03.07-solution_test_an_attribute_for_normal_distribution.mkv
23M	04.01-reformat_character_data.mkv
18M	04.02-extract_strings_from_character_data.mkv
19M	04.03-filter_with_regular_expressions.mkv
11M	04.04-reformat_numeric_data.mkv
20M	04.05-use_soundex_with_misspelled_text.mkv
840K	04.06-challenge_prepare_a_data_set_for_analysis.mkv
860K	04.07-solution_prepare_a_data_set_for_analysis.mkv
16M	05.01-use_the_having_clause_to_find_subgroups.mkv
12M	05.02-subqueries_for_column_values.mkv
9.2M	05.03-subqueries_in_from_clauses.mkv
7.2M	05.04-subqueries_in_where_clauses.mkv
14M	05.05-use_rollup_to_create_subtotals.mkv
23M	05.06-use_cube_to_total_across_dimensions.mkv
6.0M	05.07-use_top-n_queries_to_find_top_results.mkv
816K	05.08-challenge_filter_and_aggregate_a_data_set.mkv
2.8M	05.09-solution_filter_and_aggregate_a_data_set.mkv
14M	06.01-introduction_to_window_functions.mkv
18M	06.02-nth_value_and_ntile.mkv
15M	06.03-rank_lead_and_lag.mkv
22M	06.04-width_bucket_and_cume_dist.mkv
696K	06.05-challenge_segment_a_data_set_using_window_functions.mkv
1.2M	06.06-solution_segment_a_data_set_using_window_functions.mkv
1.7M	07.01-introduction_to_common_table_expressions_(ctes).mkv
12M	07.02-multiple_table_common_table_expressions.mkv
5.4M	07.03-hierarchical_tables.mkv
9.2M	07.04-recursive_common_table_expressions.mkv
1.3M	07.05-challenge_rewrite_a_complex_query_to_use_ctes.mkv
1.3M	07.06-solution_rewrite_a_complex_query_to_use_ctes.mkv
1.5M	08.01-next_steps.mkv
48K	Ex_Files_Intermediate_SQL_for_Data_Scientists.zip
419M	total