Learning Outcomes

This course will teach the following from a practical, on the job, perspective:

Basic:

  1. Joins (inner, left, right, cross)
  2. Aggregation functions (min, max, count, count distinct, average) & aggregation by group
  3. Filtering (is, is not, equal, not equal, in, not in, greater than, less than, and, or)
  4. Create table from a select statement
  5. Remove a table from the database

Intermediate:

  • Case statements
  • Combinations of everything learned prior

Advanced:

  • Window Functions
  • Complex combinations of everything learned prior

Feature Engineering:

  • SQL queries to create features, preparing data for various machine learning algorithms