*All three course dates are included in the Bootcamp

Course I: Retrieving Data

Thursday, February 7th | 6:30p – 9:00p

  • Overview of relational databases and data flow
  • Database, Schema, and Tables Overview
  • Retrieve Data from a Single Table
  • Conversion and explanation of various data types

Course II: Filtering, Sorting, and Aggregating Data

Tuesday, February 12th | 6:30p – 9:00p

  • Utilize conditional operators to filter data
  • Sorting data
  • Aggregate data using aggregate functions (MIN, MAX, SUM, AVERAGE, COUNT)

Course III: Summarizing the Data

Tuesday, February 19th | 6:30p – 9:00p

  • Summarizing data using GROUP BY function
  • Overview of previously learned functions