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:
Code
203
Duration
2 days
Medium
Face-to-face 
Virtual Classroom Prerequisites
