SQL Bootcamp Beginner and Intermediate Level (Weeknights)

*All five course dates are included in the Bootcamp

Course I: Retrieving Data

Tuesday, March 19th | 6:30p – 8:30p

  • 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

Thursday, March 21st | 6:30p – 8:30p

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

Course III: Summarizing the Data

Tuesday, March 26th | 6:30p – 8:30p

  • Summarizing data using GROUP BY function
  • Perform mathematical operations on multiple fields

Course IV: Calculating Intermediate Mathematical Operations and Formulas

Thursday, March 28th | 6:30p – 8:30p

  • Perform mathematical operations on multiple fields
  • Calculate formulas using mathematical operations and aggregate function
  • Filter aggregated data with HAVING statement

Course V: Retrieving Data from Multiple Tables

Tuesday, April 2nd | 6:30p – 8:30p

  • Retrieve data from at least 4 tables using Joins

Course VI: Concepts Recap

Thursday, April 4th | 6:30p – 8:30p

  • Recap of all concepts taught in previous 5 courses

PC Laptops Required

Please Note: Order confirmation email with download instructions and case study will be sent at 8PM EST on the date of purchase. If your order is received after the 8PM EST cutoff time, then the material will be sent by 8PM EST the next business day.

Disclaimer: If there are 3 or less students enrolled in the course, the course will be cancelled and students will be notified and refunded 24 hours prior to the original start date of the course session.

Refund Policy: No Refunds

$259.00
Processing ...
SQL Bootcamp (Beginner and Intermediate Level - Weekends)

*All five course dates are included in the Bootcamp

Course I: Retrieving Data

Saturday, February 9th | 10:30a – 12:30p

  • 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

Saturday, February 16th | 10:30a – 12:30p

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

Course III: Summarizing the Data

Saturday, February 23rd | 10:30a – 12:30p

  • Summarizing data using GROUP BY function
  • Perform mathematical operations on multiple fields

Course IV: Calculating Intermediate Mathematical Operations and Formulas

Saturday, March 2nd | 10:30a – 12:30p

  • Perform mathematical operations on multiple fields
  • Calculate formulas using mathematical operations and aggregate function
  • Filter aggregated data with HAVING statement

Course V: Retrieving Data from Multiple Tables

Saturday, March 9th | 10:30a – 12:30p

  • Retrieve data from at least 4 tables using Joins

PC Laptops Required

Please Note: Order confirmation email with download instructions and case study will be sent at 8PM EST on the date of purchase. If your order is received after the 8PM EST cutoff time, then the material will be sent by 8PM EST the next business day.

Disclaimer: If there are 3 or less students enrolled in the course, the course will be cancelled and students will be notified and refunded 24 hours prior to the original start date of the course session.

Refund Policy: No Refunds

$259.00
Processing ...