Advanced SQL + DBA Functions Online Bootcamp

About the Bootcamp

This Bootcamp is best for those with previous SQL knowledge. To make sure you have the adequate knowledge prior to taking this course, check out the topics here. If you are comfortable with the topics from our beginner bootcamp, then you are all set for registering for this bootcamp. In this Bootcamp, we will use MySQL as our SQL software for class use.

Course Schedule

Course Dates: May 18th - May 26th

Days of the week: Weeknight (Tuesdays + Wednesdays)

Time (EST): 600p - 900p EST

Course 1: Join Types

Tuesday, May 18th | 6:00p – 9:00p

• Overview of various join types
  • Full
  • Inner
  • Left
  • Right

Course 2: Subqueries

Wednesday, May 19th | 6:00p – 9:00p

• Write queries within a query inside of the select statement
• Learn how to create a table by writing a query in your From statement

Course 3: Text + Date Functions + Totals 

Tuesday, May 25th | 6:00p – 9:00p

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

Course 4: Case Statements and IIF Statements

Wednesday, May 26th | 6:00p – 9:00p

• Write if/then statements based on certain conditions using the CASE function
• Write if/then statements based on certain conditions using the IIF function

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 individual completion and submission of all homework assignments and portfolio by the specified deadline.

Refund Policy: No Refunds