SQL for Statistics Essential Training

SQL for Statistics Essential Training
SQL for Statistics Essential Training
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 49m | 100 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 PostgreSQL
  • Variance and standard deviation
  • Percentiles
  • Correlations
  • Linear models, such as linear regression