This unit describes the skills and knowledge required to use a structured query language (SQL) to define, create, and manipulate database structures, and the associated data in a relational database.  It applies to individuals in a wide variety of information and communications technology (ICT) roles, where relational databases and SQL are being used.

Unit details

Study level:
Vocational and further education (TAFE)
Unit code:
ICTPRG425

Assessment

Assessment tasks will be designed to reinforce and extend knowledge and skill competence within set and controlled parameters in accordance with each unit's learning outcomes and performance criteria requirements, including the setting of work based practical application tasks designed to provide evidence of competence outcomes, within periodic and scheduled timelines. Students will be expected to demonstrate the following required skills: - write a simple, structured query language (SQL) statement to retrieve and sort data; - write an SQL statement that selectively retrieves data, and; - write SQL statements that: use functions and operators; use aggregation and filtering; retrieve data from multiple tables; write and execute SQL sub-queries; create and manipulate tables to meet specific requirements; create and use views that satisfy information requirements, and; create and use stored procedures.Students will also be expected to demonstrate the following knowledge: - explain client-server concepts; - explain data-integrity concepts; - describe data-modelling structures; - explain databases and database objects, including data types, data structures, identifiers and metadata; - summarise programming concepts; - give an overview of query design; - give an overview of relational database design; - describe the SQL client environment, and; - describe the SQL server architecture.

Where to next?

VU takes care to ensure the accuracy of this unit information, but reserves the right to change or withdraw courses offered at any time. Please check that unit information is current with the Student Contact Centre.