Advanced SQL + DBA Functions Online Bootcamp

Take your SQL skills to the next level with this live advanced SQL bootcamp

This Bootcamp is live and instructor led
Price $199
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

 

$199.00