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