Skip to content
Course Details:
Concepts Covered:
- Obtain summary statistics and employ stddev_samp(), stddev_pop(), var_samp(), var_pop() to get standard deviations and variance
- Create subgroups (using window functions) for more granular analysis
- Apply statistics based on sorted data within groups, such as the median value, the first and third quartiles of a dataset, the most frequent value, etc.
- Convert values to null with nullif()
- Understand the limits of the mode() function
- Further manipulate query result sets using ranking, hypothetical sets, percentile functions, and conditional expressions
- Additional querying techniques such as row_number() over() and generate_series()