Tag: SQL

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