SQL for Statistics Essential Training
This post was published 8 years ago. Download links are most likely obsolete. If that's the case, try asking the uploader to re-upload.
MP4 | Video:1280x720 | Duration: 49m 14s | 94 MB
Genre: eLearning | Language: English | Level: Intermediate
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 PostgreSQL
Variance and standard deviation
Percentiles
Correlations
Linear models, such as linear regression
Screenshots
Quick check before we show the links
Helps us keep automated scrapers from hammering the filehosts.