Education: SQL Basic - Live Training

Interested in learning the fundamentals of SQL? Fill out this training request form.

SQL is the basis of all reporting options within the MRI Education system. A working knowledge is a  significant advantage to anyone required to extract information from the database. This session talks delegates through the fundamentals of SQL using MRI Education data, providing an overview of how SQL can help with your wider report writing or alert requirements.

Pre-requisites

• An SQL program such as SQL tools SQL Developer, Toad or similar.
• Oracle client
• Log on to the MRI Education database

Objectives

• Be able to create and understand basic SQL queries
  
  Audience
  
  
• Report Writers
• System Administrators
  
  Standard Agenda
  
  
• What is SQL and where is it used
  • An overview on “Structured Query Language” (SQL) and how it is used with MRI Education Reporting
• Simple SQL queries
  • Understand how to extract simple information from the database
• Sort and filter data
  • How to sort and filter your information in SQL to make it easier to view and to remove unwanted records
• Group and aggregate data
  • Summarising your data by grouping particular data and applying counts
• Linking tables
  • Take data from multiple areas of the system and join it together to produce more complex SQL queries

Outcomes

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