Learn beginner to intermediate SQL functions in this in person Masterclass!
This Bootcamp is live and instructor led
What the heck is SQL?
Think about all of the data that a company collects and has access to. Ever wonder how that data gets used? With the use of SQL, analysts are able to extract this data and analyze it in every way possible. The analysis, derived from data using SQL, can help drive strategic business decisions.
This Bootcamp is best for those with little to no SQL experience and would like to prep for any role that uses beginner to intermediate level SQL. All students will have three hours of prerequisite material provided prior to the start of class to help prep them for the first day of the Bootcamp. In this Bootcamp, we will use Oracle MySQL as our SQL software for class use.
Course Dates: August 7th + August 8th (*Prerequisite course will be held virtually online on Thursday, August 6th)
Days of the week: Weekends
Time (EST): 900a - 100p EST
Pre-Bootcamp Prerequisite Course: Intro to SQL (Online)
*This is a prerequisite course that will be held virtually that will cover just the basics of SQL. All remaining courses in the Bootcamp will be held in person.
Thursday, August 5th | 6:00p - 9:00p
- Intro to SQL
- Review of databases, data types, and table files
Part 1: Sorting, Filtering, and Aggregating
Saturday, August 7th | 9:00a - 1:00p
- Sorting data
- Retrieve Data from a Single Table
- Filtering data
- Aggregate functions
Part 2: Calculating, Grouping, and Joining
Sunday, August 8th | 9:00a - 1:00p
- Calculate formulas using mathematical operations
- Summarizing data using GROUP BY function
- Extract data from multiple tables at once using joins
Course materials (including installation guides) and reminders will be sent 7 days prior to the start of the first course of the Bootcamp.
Certificate of Completion
You will receive a certificate of completion upon individual completion and submission of all homework assignments and portfolio by the specified deadline.
Class Recordings + Practice Exercises
You will receive class recordings and practice exercises for each course in the Bootcamp.
Refund Policy: No refunds and/or transfers