Education: SQL Advanced - Live Training

Interested in creating advanced reports using SQL in SSRS and Crystal? Fill out this training request form.

Objectives

• Be able to create Advanced SQL queries.

Audience

• Report Writers
• System Administrators

Standard Agenda

• Apply filters in your join statements to return only relevant data. example - to return all students and any permanent exclusions within the current academic year.
• Use subqueries example - list all involvements and the number of reasons recorded for each of them
• ‘Self-joining’ tables example - find all other people with the same correspondence address as a student
• Use ‘Union’ to return all data from multiple subqueries as rows example - total cases by caseworker and total for the whole authority
• Return previous or next field values example - end date of previous school for each student
• Restrict records to a number of rows example – a student’s current school and the previous school they attended
• Pivot rows of data into a single (comma) separated column example - all outcomes rows recorded against an involvement as absingle column within the involvement row
• Other useful SQL functions

Outcomes

• Create Advanced SQL queries for use in Reports and Alerts
• Run quick queries on the MRI Education data to troubleshoot any data problems