< Back to GIM Suite Practitioner - Coal
203

Introduction to SQL

Learn how to use SQL, a database programming language, to enhance your GIM Suite configuration and optimise your data querying capabilities.

Who should attend?

Anyone who may be involved in creating acQuire 4 objects where a basic level of SQL is required.

Learning Outcomes
1. Define SQL and use SQL Server Management Studio to write and execute SQL queries. 

  • Define SQL, including its nature and purpose.
  • Open SQL Server Management Studio and connect to a database.
  • Open Query Analyser within SQL Server Management Studio.
  • Explain the various components of Query Analyser.
  • Write and execute SQL queries and view the results in the data grid.
  • Interpret error messages after executing a SQL query.
  • Show how to save and open a saved SQL query.

2. Demonstrate how to write a simple SELECT statement with relevance to the acQuire Data Model (ADM). 

  • Demonstrate how to retrieve data from a table using SELECT and recognise when to use the *, TOP, DISTINCT keywords.
  • Explain and use field name aliasing.
  • Explain and use calculated fields including concatenation.
  • Use common in-built functions such as CAST, LEFT, RIGHT and mathematical functions such as ABS, ROUND.
  • Demonstrate how to sort results.
  • Explain filters and combined filters, and apply them.
  • Apply advanced filtering (including IS NULL, IS NOT NULL, IN, BETWEEN, LIKE).
  • Group results and summarise/aggregate using common system functions such as COUNT, MIN, MAX.

3. Retrieve data from more than one table within the ADM. 

  • Explain common JOIN (INNER, LEFT, RIGHT) types and recognise when to use each.
  • Explain aliasing tables and recognise when to use them.
  • Distinguish the two types of UNION and when to use each.

4. Demonstrate how to modify data using Data Manipulation Language (DML) elements in the ADM. 

  • Compare and explain INSERT, UPDATE and DELETE statements.
  • Demonstrate how to insert data using the INSERT statement.
  • Demonstrate how to modify data using the UPDATE statement and explain the impact of cascade update.
  • Demonstrate how to create a DELETE statement and explain the impact of cascade delete.

5. Write structured and self-documented SQL code. 

  • Write a SQL query which follows a recommended coding standard.
  • Demonstrate how to add and use comments effectively when writing SQL.

You can participate in this unit at one of these upcoming courses:
04 - 05 Nov 2019
Introduction to SQL
Santiago,
Chile
13 - 14 Nov 2019
Introduction to SQL
Perth,
Australia
25 - 26 Nov 2019
Introduction to SQL
Calgary,
Canada
13 - 14 Feb 2020
Introduction to SQL
Phoenix,
United States of America
Code
203
Duration
2 days
Medium
Face-to-face
Virtual Classroom
Back to top
×