Part A: Course Overview

Program: C5402 Diploma of Information Technology

Course Title: Apply structured query language in relational databases

Portfolio: Vocational Education

Nominal Hours: 60

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Important Information:

Please note that this course may include compulsory in-person attendance requirements for some or all teaching activities.

It is recommended that you check your Canvas course shell closer to the course start date for details about any mandatory in-person attendance requirements.

Please be aware that the course delivery method may need to change quickly in response to evolving course requirements. Students must maintain regular communication with their teachers to stay informed about any updates.

Terms

Course Code	Campus	Career	School	Learning Mode	Teaching Period(s)
COSC7395C	City Campus	TAFE	520T Future Technologies	Face-to-Face or Internet	Term2 2022, Term1 2024, Term2 2024, Term1 2025

Course Contact: Trevor Stone

Course Contact Phone: +61 3 9925 4612

Course Contact Email: trevor.stone@rmit.edu.au

Course Description

In this course you will gain 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.

This course is clustered for delivery and assessment with the following unit: 

ICTDBS506 Design databases 

Pre-requisite Courses and Assumed Knowledge and Capabilities

None

National Competency Codes and Titles

National Element Code & Title:	ICTWEB451 Apply structured query language in relational databases
Elements:	1. Identify database requirements 2. Build and implement SQL in relational databases 3. Test and verify SQL results

Learning Outcomes

On successful completion of this course the candidate will demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit.

Overview of Assessment

Assessment for this course is ongoing throughout the semester. Your knowledge and understanding of course content is assessed through participation in class exercises and various types of assessments.

Full assessment briefs will be provided and can be found on CANVAS.