During this portion of the training, you will receive 2.5 hours of training that will teach you how to extract partial match data using advanced filtering techniques in SQL.
PLEASE REVIEW THE REQUIRED EXCEL SKILLS IN THE CURRICULUM PRIOR TO REGISTERING FOR THE TRAINING.
During this portion of the training, you will receive 12 hours of training that will teach you how to utilize various join types (INNER, FULL, LEFT, and RIGHT) and extract data from multiple databases in SQL.
Saturday, November 22nd:8:00am – 11:00am
Sunday, November 23rd:8:00am – 11:00am
Monday, November 24th:6:30pm – 9:30pm
Tuesday, November 25th:6:30pm – 9:30pm
Part 4: Complex SQL Queries Boot Camp (24 Hours)
During this portion of the training, you will receive 24 hours of training on how to write multi-page queries using JOINS, UNIONs, and subqueries.
Monday, December 1st - Wednesday, December 3rd:8:00pm – 10:00pm
Saturday, December 6th:8:00am – 10:00am
Monday, December 8th - Wednesday, December 10th:8:00pm – 10:00pm
Saturday, December 13th:8:00am – 10:00am
Monday, December 15th - Wednesday, December 17th:8:00pm – 10:00pm
Saturday, December 20th:8:00am – 10:00am
Excel Data Analysis (10 Hours)
In this portion of the training, you’ll learn how to export data from SQL into Excel and generate analysis notes based on the findings within a prepared Excel report. NOTE: This boot camp will not review Excel formulas. The Excel report will already be created.
PLEASE REVIEW THE REQUIRED EXCEL SKILLS IN THE CURRICULUM PRIOR TO REGISTERING FOR THE TRAINING.
Monday, January 5th:8:00pm – 10:00 pm
Tuesday, January 6th:8:00pm – 10:00 pm
Wednesday, January 7th:8:00pm – 10:00 pm
Saturday, January 10th:9:00am – 11:00 am
Sunday, January 11th:9:00am – 11:00 am
Important Information
No refunds. No exceptions.
A Snowflake registration will be required. Average monthly subscription price of $20-$35/month after 30 day free trial. Registration details will be provided no later than 2 to 3 days prior to the start of the first day of training.
Please review the course's skills prerequisites prior to registering (see Prerequisites section above)