Category: Milestones

Completed Course: Statistics for Data Science and Business Analysis

Course Details:

Concepts Covered:

  • Understand the fundamentals of statistics
  • Learn how to work with different types of data
  • How to plot different types of data
  • Calculate the measures of central tendency, asymmetry, and variability
  • Calculate correlation and covariance
  • Distinguish and work with different types of distributions
  • Estimate confidence intervals
  • Perform hypothesis testing
  • Make data driven decisions
  • Understand the mechanics of regression analysis
  • Carry out regression analysis
  • Use and understand dummy variables
  • Understand the concepts needed for data science even with Python and R!

Completed Course: PostgreSQL: Advanced Queries

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()

Completed Course: Advanced SQL

Course Details:

Concepts Covered:

  • JOINs and UNIONs: Combine information from multiple tables
  • Analytic Functions: Perform complex calculations on groups of rows
  • Nested and Repeated Data: Learn to query complex datatypes in BigQuery
  • Writing Efficient Queries: Write queries to run faster and use less data