Google SQL BigQuery Beginner + Intermediate Online Bootcamp

Learn how to extract data using Google BigQuery

All Bootcamps are held online due to COVID-19
This Bootcamp is live and instructor led
Price $199
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 Google BigQuery as our SQL software for class use.

Course Schedule
Course Dates: March 15th - April 7th
Days of the week: Weeknight (Monday - Wednesday)
Time (EST): 730p - 830p EST

            Course 1: Database and Table Review

Monday, March 15th | 730p - 830p

  • Review of databases, data types, and table files

Course 2: Sorting Data

Tuesday, March 16th | 730p - 830p

  • Sorting data
  • Retrieve Data from a Single Table

Course 3: Filtering Data

Wednesday, March 17th | 730p - 830p

  • Utilize conditional operators to filter data using WHERE

Course 4: Recap, Calculations, and Aggregations

Monday, March 22nd | 730p - 830p

  • Calculate formulas using mathematical operations and aggregate functions
  • More data filtering

Course 5: Summarizing Data

Tuesday, March 23rd | 730p - 830p

  • Summarizing data using GROUP BY function

Course 6: Retrieving Data from Multiple Tables (Part 1)

Wednesday, March 24th | 730p - 830p

  • Extract data from multiple tables at once using joins

Course 7: Retrieving Data from Multiple Tables (Part 2)*

Monday, March 29th | 730p - 830p

  • Extract data from multiple tables at once using joins

Course 8: Full Joins

Tuesday, March 30th | 730p - 830p


Course 9: Left + Right Joins

Wednesday, March 31st | 730p - 830p


Course 10: Text + Date Functions + Totals

Monday, April 5th | 730p - 830p

  • Utilization of various text and date functions
    • Text location functions
    • Date interval functions
    • Perform subtotals and grand totals within data

Course 11: If Statements

Tuesday, April 6th | 730p - 830p

  • Write if/then statements based on certain conditions

Course 12: Having

Wednesday, April 7th | 730p - 830p

  • Filter aggregated columns using having statements

 

 

 

Course materials (including installation guides), access codes, and reminders will be sent 7 days prior to the start of the first course of the Bootcamp.

 

What's Included:

Certificate of Completion
You will receive a certificate of completion upon submission of all homework assignments and portfolio by the specified deadline.

 

 

 

Refund Policy: No Refunds

 

$199.00
Out of stock