Advanced SQL Query Writing + Web Reports Online Bootcamp

Learn how to write and troubleshoot complex SQL reports in this query writing bootcamp!

This Bootcamp is live and instructor led (online)
Price $349
What the heck is complex SQL query writing?
Let’s say that you need data from multiple tables and the data you need can’t just come from one simple query. What if the data you need needs to be written from a 10 to 20-page query to pull all required data? That is not easy task. That’s where this bootcamp comes in to help save the day. In this Bootcamp, you will learn to write queries up to 20 pages. Then, you will convert these queries into a user friendly web application report via SSRS.
This Bootcamp is best for those with intermediate SQL experience and would like to kick up their SQL skills 100 notches. All students will have three hours of prerequisite material provided prior to the start of class to help prep them for the first day of the Bootcamp. In this Bootcamp, we will use Microsoft SQL Server and SSRS as our SQL software and reporting tool for class use. Prerequisite knowledge: Joins, Group By, Aggregate Functions, and Filtering

Taught by: Whitney Pettis, MBA


Course Schedule
Course Dates: January 24th - March 2nd
Days of the week: Mondays + Wednesdays
Time (EST): 600p - 800p EST

Course 1: Mapping Out Your Report Criteria 

Monday, January 24th | 6:00p - 8:00p

  • Review of databases, data types, and table files
  • Gather report requirements

Course 2: Temporary Tables

Wednesday, January 26th | 6:00p - 8:00p

  • Create temporary tables to extract queried data
  • Temporary tables vs. derived tables
  • Joining temporary tables

Course 3: Derived Tables

Monday, January 31st | 6:00p – 8:00p

  • Transform derived tables into temporary tables

Course 4: Variables

Wednesday, February 2nd | 6:00p - 8:00p

  • Declaring variables

Course 5: Advanced Filtering + Date Conversions

Monday, February 7th | 6:00p - 8:00p

  • Filter data using advanced filtering techniques
  • Convert data to custom text and date formats

Course 6: Advanced Case Statements 

Wednesday, February 9th | 6:00p - 8:00p

  • Write if/then logic statements with complex condition requirements

Course 7: Unions

Monday, February 14th | 6:00p - 8:00p

  • Combine queried data using unions

Course 8: Pivoting Data 

Wednesday, February 16th | 6:00p - 8:00p

  • Turn queried data into a pivot format

Course 9: Bringing It All Together! (Part 1)

Monday, February 21st | 6:00p - 8:00p

  • Let's break down the first 5 - 10 pages of our complex SQL query

Course 10: Bringing It All Together! (Part 2)

Wednesday, February 23rd | 6:00p - 8:00p

  • Write another 3 – 5 pages of queries based on report requirements (solo)
  • Troubleshoot your query (if needed)

Course 11: Build Report via Report Builder

Monday, February 28th | 6:00p - 8:00p

  • Transform query into a template report
    • Connect data source
    • Format template report

Course 12: Build Web Application Report 

Wednesday, March 2nd | 6:00p - 8:00p

  • Learn the formatting basics of SSRS
  • Incorporate report parameters

 

 

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 and/or transfers

 

$349.00