|
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
| [1] Calculate the median value of a dataset.mp4 |
14.41Мб |
| [1] Calculate the median value of a dataset.srt |
10.69Кб |
| [1] Create a window function with an OVER clause.mp4 |
9.30Мб |
| [1] Create a window function with an OVER clause.srt |
6.77Кб |
| [1] Define values with CASE statements.mp4 |
14.87Мб |
| [1] Define values with CASE statements.srt |
11.48Кб |
| [1] Gain additional insights from your PostgreSQL data.mp4 |
5.06Мб |
| [1] Gain additional insights from your PostgreSQL data.srt |
1.74Кб |
| [1] Next steps.mp4 |
1.97Мб |
| [1] Next steps.srt |
1.74Кб |
| [1] Output row numbers with query results.mp4 |
5.85Мб |
| [1] Output row numbers with query results.srt |
4.14Кб |
| [1] Rank rows with a window function.mp4 |
15.31Мб |
| [1] Rank rows with a window function.srt |
10.59Кб |
| [1] Using GROUP BY to aggregate data rows.mp4 |
17.78Мб |
| [1] Using GROUP BY to aggregate data rows.srt |
12.93Кб |
| [2] Calculate the first and third quartiles of a dataset.mp4 |
15.43Мб |
| [2] Calculate the first and third quartiles of a dataset.srt |
9.49Кб |
| [2] Cast values to a different data type.mp4 |
5.05Мб |
| [2] Cast values to a different data type.srt |
3.76Кб |
| [2] Find a hypothetical rank.mp4 |
10.22Мб |
| [2] Find a hypothetical rank.srt |
6.98Кб |
| [2] Merge columns with COALESCE.mp4 |
9.00Мб |
| [2] Merge columns with COALESCE.srt |
6.05Кб |
| [2] Obtain general-purpose aggregate statistics.mp4 |
13.52Мб |
| [2] Obtain general-purpose aggregate statistics.srt |
9.01Кб |
| [2] Partition rows within a window.mp4 |
11.08Мб |
| [2] Partition rows within a window.srt |
7.22Кб |
| [2] What you should know.mp4 |
1.64Мб |
| [2] What you should know.srt |
1.43Кб |
| [3] Convert values to null with NULLIF.mp4 |
7.57Мб |
| [3] Convert values to null with NULLIF.srt |
5.36Кб |
| [3] Evaluate columns with Boolean aggregates.mp4 |
11.04Мб |
| [3] Evaluate columns with Boolean aggregates.srt |
7.73Кб |
| [3] Find the most frequent value within a dataset with MODE.mp4 |
6.96Мб |
| [3] Find the most frequent value within a dataset with MODE.srt |
4.54Кб |
| [3] Move rows within a result with LEAD and LAG.mp4 |
15.88Мб |
| [3] Move rows within a result with LEAD and LAG.srt |
9.73Кб |
| [3] Streamline partition queries with a WINDOW clause.mp4 |
6.95Мб |
| [3] Streamline partition queries with a WINDOW clause.srt |
4.79Кб |
| [3] Using the exercise files.mp4 |
6.15Мб |
| [3] Using the exercise files.srt |
4.93Кб |
| [3] View top performers with percentile ranks.mp4 |
13.10Мб |
| [3] View top performers with percentile ranks.srt |
8.51Кб |
| [4] Determine the range of values within a dataset.mp4 |
5.12Мб |
| [4] Determine the range of values within a dataset.srt |
3.84Кб |
| [4] Evaluate probability with cumulative distribution.mp4 |
7.43Мб |
| [4] Evaluate probability with cumulative distribution.srt |
4.74Кб |
| [4] Find the standard deviation and variance of a dataset.mp4 |
13.50Мб |
| [4] Find the standard deviation and variance of a dataset.srt |
8.85Кб |
| [4] Ordering data within a partition.mp4 |
13.22Мб |
| [4] Ordering data within a partition.srt |
8.33Кб |
| [4] Use an IN function with a subquery.mp4 |
10.49Мб |
| [4] Use an IN function with a subquery.srt |
6.82Кб |
| [5] Calculate a moving average with a sliding window.mp4 |
11.64Мб |
| [5] Calculate a moving average with a sliding window.srt |
7.39Кб |
| [5] Challenge Evaluate rankings within a dataset.mp4 |
1.42Мб |
| [5] Challenge Evaluate rankings within a dataset.srt |
1.01Кб |
| [5] Challenge Retrieve statistics of a dataset with groups.mp4 |
1.85Мб |
| [5] Challenge Retrieve statistics of a dataset with groups.srt |
1.38Кб |
| [5] Define WHERE criteria with a series.mp4 |
10.75Мб |
| [5] Define WHERE criteria with a series.srt |
7.82Кб |
| [5] Include overall aggregates with ROLLUP.mp4 |
11.31Мб |
| [5] Include overall aggregates with ROLLUP.srt |
7.80Кб |
| [6] Challenge Calculations across rows.mp4 |
1.35Мб |
| [6] Challenge Calculations across rows.srt |
886б |
| [6] Return all possible combinations of groups with CUBE.mp4 |
9.46Мб |
| [6] Return all possible combinations of groups with CUBE.srt |
6.24Кб |
| [6] Return values at specific locations within a window.mp4 |
20.24Мб |
| [6] Return values at specific locations within a window.srt |
13.02Кб |
| [6] Solution Evaluate rankings within a dataset.mp4 |
15.14Мб |
| [6] Solution Evaluate rankings within a dataset.srt |
9.93Кб |
| [6] Solution Retrieve statistics of a dataset with groups.mp4 |
14.98Мб |
| [6] Solution Retrieve statistics of a dataset with groups.srt |
10.01Кб |
| [7] Challenge Leverage window functions.mp4 |
2.21Мб |
| [7] Challenge Leverage window functions.srt |
1.55Кб |
| [7] Segmenting groups with aggregate filters.mp4 |
12.89Мб |
| [7] Segmenting groups with aggregate filters.srt |
8.03Кб |
| [7] Solution Calculations across rows.mp4 |
12.67Мб |
| [7] Solution Calculations across rows.srt |
8.39Кб |
| [8] Challenge Group statistics.mp4 |
2.66Мб |
| [8] Challenge Group statistics.srt |
1.99Кб |
| [8] Solution Leverage window functions.mp4 |
12.54Мб |
| [8] Solution Leverage window functions.srt |
8.99Кб |
| [9] Solution Group statistics.mp4 |
19.16Мб |
| [9] Solution Group statistics.srt |
13.36Кб |
| Ex_Files_PostgreSQL_Advanced_Queries.zip |
25.13Кб |