Elements and Performance Criteria
- Write a simple SQL statement to retrieve and sort data
- Write an SQL statement that selectively retrieves data
- 2.1 Restrict the number of rows retrieved by placing criteria in the 'where' clause
- Restrict the number of rows retrieved by placing specific criteria in the select statement
- 2.3 Use comparison operators in the 'where' clause to compare numeric, character, string, date and time data
- Use Boolean operators with the correct precedence
- 2.5 Use criteria in the 'where' clause to check for a range of values, to select values from a list, and to check for values that match a pattern
- Use SQL syntax to suppress duplicate values from query results
- Take action to exclude null values from a query result
- Write SQL statements that use functions
- Use arithmetical operators with the correct precedence
- Use string functions and operators to obtain the required query output
- Use mathematical functions to obtain the required output, where required
- Use date functions to obtain the required output
- Use SQL aggregate functions to obtain the required output
- Write SQL statements that use aggregation and filtering
- Write SQL statements that retrieve data from multiple tables
- Employ the inner join syntax to retrieve data from two or more tables
- 5.2 Use 'left outer', 'right outer' and 'full outer' syntax to join tables in the select statement
- 5.3 Use correct syntax in the 'where' clause to retrieve data from multiple tables
- Write a union query that retrieves data from more than one table
- Write and execute SQL sub-queries
- Create and manipulate tables
- Create and use views
- Create and use stored procedures
- Create and execute stored procedures that use SQL to retrieve, insert or modify data according to information requirements
- Create and execute stored procedures that use one or more parameters
- Drop a stored procedure from the database
- Create and test database triggers that automate data management or perform specific required data-related functions