This unit describes the skills and knowledge required to produce structured query language (SQL) statements to work with server-side scripts, enabling web designers to interact with web server databases.

Unit details

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

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: - identify structured query language (SQL) requirements; - create the databases and tables; - generate queries for one or more tables, to provide the required data; - add, modify and delete records from the database tables, and; - test and verify SQL statements. Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.Students will also be expected to demonstrate the following knowledge: - explain the features and application of the following aggregate functions: MIN; MAX; SUM; AVG; COUNT; COUNT(*); - explain the features and application of the following clause functions: GROUP BY; HAVING; ORDER BY; dates and times; SQL data types; numbers; text; SQL syntax; SELECT; FROM; WHERE; LIKE; DISTINCT; CREATE; ALTER TABLE; INSERT INTO; UPDATE; DELETE; DROP, and; - describe the principles of "combining and/or condition" in SQL statements and Boolean operators: IN and BETWEEN conditional operators; mathematical operators; table joins (relationships).

Where to next?

As part of a course

This unit is studied as part of the following courses. Refer to the course page for information on how to apply for the course.

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.