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.
- 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.
- 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.
- 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.
- 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.
- 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: