ICTWEB451 - Apply structured query language in relational databases

TAFE Victoria logo
Unit code: ICTWEB451 | Study level: TAFE
Credit points
N/A
Location
Footscray Nicholson
Sunshine
Prerequisites
N/A
Overview
Enquire

Overview

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

The unit applies to individuals in a range of roles who are responsible for creating server-side interaction with dynamic web pages, using SQL as a means of communicating with databases.

Assessment

For Melbourne campuses

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:
*apply structured query language (SQL) to a relational database and gather required information according to task requirements.

In the course of the above, the candidate must:
*generate queries for one or more tables and provide required data
*add, modify, retrieve and delete records from database tables as required test and verify SQL statements.

Students will also be expected to demonstrate the following knowledge:
*organisational policies and procedures relating to SQL application including:

  • identifying SQL requirements from job specifications
  • testing and verifying SQL results
    *features and application of primary and foreign keys in database tables, aggregate functions and clause functions required in SQL application
    *principles of "combining and/or condition" in SQL statements and Boolean operators
  • IN and BETWEEN conditional operators
  • mathematical operators
  • table joins (relationships)
    *documentation techniques relevant to applying structured query language in relational databases
    *SQL statement testing methodologies.

Required reading

The qualified trainer and assessor will provide teaching and learning materials as required in the form of workbooks produced by the VU Polytechnic and/or via the Victoria University Polytechnic e-learning system.

As part of a course

This unit is studied as part of the following course(s):

Certificate IV in Information Technology
ICT40120 | Certificate iv | Duration:

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.

Search for units, majors & minors