SQL for Statistics Essential Training
MP4 | Video: 720p | Duration: 49:14 | English | Subtitles: VTT | 94.0 MB

Descriptive statistics help us understand the overall structure of data, and SQL is the most widely used language for manipulating it. Together, they can help data analysts derive better insights and make far-reaching predictions. This course provides an overview of basic descriptive statistics and the SQL commands you need to know to summarize data sets, find averages, and calculate variance and standard deviation. Instructor Dan Sullivan also introduces more detailed analysis techniques using discreet and continuous percentiles to help segment data, and correlations between variables to identify relationships. He concludes with an introduction to linear regression, a widely used predictive analytics technique.

Topics include:
Loading data into PostgreSQLVariance and standard deviationPercentilesCorrelationsLinear models, such as linear regression