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