Advanced SQL + DBA Functions Online Bootcamp

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

All Bootcamps are held online due to COVID-19
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 Microsoft SQL Server as our SQL software for class use.

Course Schedule + Curriculum
Course Dates: February 15th - March 30th
Days of the week: Weeknight (Monday - Wednesday)
Time (EST): 530p - 630p EST

Course 1: Create, Insert, Update, and Delete (Part 1)

Monday, February 15th | 5:30p – 6:30p

  • Learn how to create a table, insert, and update data into the table

Course 2: Create, Insert, Update, and Delete (Part 2)

Tuesday, February 16th | 5:30p – 6:30p

  • Learn how to create a table, insert, and update data into the table

Course 3: Create, Insert, Update, and Delete (Part 3)

Wednesday, February 17th | 5:30p – 6:30p

  • Learn how to create a table, insert, and update data into the table

Course 4: Primary Key

Monday, February 22nd | 5:30p – 6:30p

  • Assign primary key to a table

Course 5: Foreign Key

Tuesday, February 23rd | 5:30p – 6:30p

  • Assign foreign key to a table

Course 6: Primary vs. Foreign Key

Wednesday, February 24th | 5:30p – 6:30p

  • Review the differences between primary vs. foreign key

Course 7: Join Types (Part 1)

Monday, March 1st | 5:30p – 6:30p

  • Overview of various join types
    • Full
    • Inner

Course 8: Join Types (Part 2)

Tuesday, March 2nd | 5:30p – 6:30p

  • Overview of various join types
    • Left
    • Right

Course 9: Join Types (Part 3)

Wednesday, March 3rd | 5:30p – 6:30p

  • Overview of various join types
    • Cross Joins vs Inner Joins

Course 10: Unions (Part 1)

Monday, March 8th | 5:30p – 6:30p

  • Overview of unions vs. joins

Course 11: Unions (Part 2)

Tuesday, March 9th | 5:30p – 6:30p

  • Union All

Course 12: Coalesce

Wednesday, March 10th | 5:30p – 6:30p


Course 13: Subqueries - Select Statement

Monday, March 15th | 5:30p – 6:30p

  • Write queries within a query inside of the select statement

Course 14: Subqueries - From Statement

Tuesday, March 16th | 5:30p – 6:30p

  • Learn how to create a table by writing a query in your From statement

Course 15: Subqueries - Exists (Part 1)

Wednesday, March 17th | 5:30p – 6:30p

  • Learn how to create a table by writing a query in your Where statement

Course 16: Subqueries - Exists (Part 2)

Monday, March 22nd | 5:30p – 6:30p

  • Learn to utilize the EXIST function in your Where statement

Course 17: Text + Date Functions + Totals (Part 1)

Tuesday, March 23rd | 5:30p – 6:30p

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

Course 18: Text + Date Functions + Totals (Part 2)

Wednesday, March 24th | 5:30p – 6:30p

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

Course 19: If Statements - Case Statements (Part 1)

Monday, March 29th | 5:30p – 6:30p

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

Course 20: If Statements - IIF Statements (Part 2)

Tuesday, March 30th | 5:30p – 6:30p

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

 

Refund Policy: No Refunds

 

$199.00