UNIT CODE

DITSQL619

UNIT TITLE

Use SQL to communicate with databases

APPLICATION

This unit describes the performance outcomes, skills and knowledge required to communicate with databases by means of structured query language (SQL).

This unit of competency is applied by technicians who have to update data on a database or retrieve data on a database. Some common relational database management systems that use SQL include Oracle, Sybase, Microsoft SQL Server, Access, and Ingres.

No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ELEMENT

Elements describe the outcome of a unit of competency.

PERFORMANCE CRITERIA

Performance criteria specify the level of performance required to demonstrate achievement of the Elements. Terms in italics are elaborated in the Range Statement.

1.    Establish the fundamentals of SQL

1.1.      Establish the fundamentals of structured query language (SQL) and databases

1.2.      Establish relevant ANSI/ISO standards

1.3.      Identify and explain fundamental SQL building blocks

1.4.      Explain SQL terminology and syntax

2.    Use SQL statements to create and modify tables

2.1.      Use SQL syntax to add, remove and restrict rows

2.2.      Write SQL statements to retrieve data

2.3.      Perform queries using the SQL statements.

2.4.      Sort and verify results

2.5.      Handle NULL values in expressions and filter conditions

3.    Write SQL statements to construct nested queries

3.1.      Explain the difference between correlated and non-correlated sub-queries

3.2.      Construct queries that test for the existence of rows

3.3.      Apply sub-queries under various conditions

FOUNDATION SKILLS

Foundation skills essential to performance are explicit in the performance criteria of this unit of competency.

UNIT MAPPING INFORMATION

No equivalent unit.

TITLE

Assessment requirements for DITSQL619 – Use SQL to communicate with databases

PERFORMANCE EVIDENCE

To achieve competency in this unit a person must satisfy the requirements of the elements and performance criteria included in the unit. The person must also:

• Identify SQL requirements
• Create and modify database content and tables
• Generate queries
• Test and verify SQL statements

KNOWLEDGE EVIDENCE

To achieve competency in this unit a person must satisfy the requirements of the elements and performance criteria included in the unit. This includes knowledge of:

• Relevant ANSI/ISO standards
• Tables
• Columns
• Primary keys
• Foreign keys
• SQL generating tools
• Adding table rows
• Changing row content
• Removing rows
• Writing single table queries
• Retrieving data
• Including columns and expressions in query results
• Restricting rows
• Sorting results
• Handling NULL values in expressions
• Avoiding NULL value pitfalls in filter conditions
• Testing the existence of rows
• Performing sub-queries
• Debugging SQL statements generated by code
• Performing perform SQL queries of Google Sheets
• Performing SQL queries of Excel spreadsheets 
• Security issues

ASSESSMENT CONDITIONS

There are no specific industry mandated conditions for this assessment.

All assessment must be completed in accordance with work health and safety standards

Assessor Requirements:
Assessors must:

• hold the appropriate assessor competency standards as outlined in regulations; and
• be able to demonstrate vocational competencies at least to the level being  assessed; and
• be able demonstrate how they are continuing to develop their VET knowledge and skills as well as maintaining their industry currency and assessor competence