Course Title: Use structured query language

Part A: Course Overview

Program: C5341 Diploma of Information Technology

Course Title: Use structured query language

Portfolio: BUS Portfolio Office

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.

Terms

Course Code

Campus

Career

School

Learning Mode

Teaching Period(s)

COSC7373C

City Campus

TAFE

650T Vocational Business Education

Face-to-Face or Internet

Term1 2016,
Term2 2016,
Term1 2017,
Term2 2017

Course Contact: Val Christou

Course Contact Phone: +61 3 9925 5076

Course Contact Email: val.christou@rmit.edu.au



Course Description

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.

Pre-requisite Courses and Assumed Knowledge and Capabilities

None



National Competency Codes and Titles

National Element Code & Title:

ICTPRG425 Use structured query language

Elements:

1. Write a simple SQL statement to retrieve and sort data

2. Write an SQL statement that selectively retrieves data

3. Write SQL statements that use functions

4. Write SQL statements that use aggregation and filtering

5. Write SQL statements that retrieve data from multiple tables

6. Write and execute SQL sub-queries

7. Create and manipulate tables

8. Create and use views

9. Create and use stored procedures


Learning Outcomes


Overview of Assessment

In order to achieve competency in this unit, you must provide:

Performance Evidence

Evidence of the ability to:

  • write a simple, structured query language (SQL) statement to retrieve and sort data
  • write an SQL statement that selectively retrieves data
  • 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
  • create and use stored procedures. 

Knowledge Evidence

To complete the unit requirements safely and effectively, you must:

  • 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
  • describe the SQL server architecture.

 Assessment Conditions

Assessment must be conducted in a safe environment where evidence gathered demonstrates consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the programming and software development, and include access to:

  • special purpose tools, equipment and materials
  • industry software packages.

You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.

Feedback

Feedback will be provided throughout the semester in class and/or online discussions.  You are encouraged to ask and answer questions during class time and online sessions so that you can obtain feedback on your understanding of the concepts and issues being discussed. Finally, you can email or arrange an appointment with your teacher to gain more feedback on your progress.

You should take note of all feedback received and use this information to improve your learning outcomes and final performance in the course.