SQL for Statistics Essential Training

Learn how to use SQL for descriptive statistics: to summarize data sets, derive insights, and make predictions.

Introduction

• Welcome
• What you should know
• Exercise files

1. Basic Descriptive Statistics

• Installing PostgreSQL
• Load data into PostgreSQL
• Basics: Count, minimum, and maximum
• Basics: Sum and average
• Variance and standard deviation

2. Percentiles and Frequencies

• Introduction to percentiles
• Discrete percentiles
• Continuous percentiles
• Summary of percentiles

3. Correlations and Ranks

• Introduction to correlation
• Correlations between variables
• ROW_NUMBER
• Mode
• Summary of correlations

4. Linear Models

• Introduction to linear regression
• Minimizing error
• Computing intercept
• Computing slope

Conclusion

• Overview of SQL for statistics