Page 284 - aREA ix eXHIBITS

CORE COMPETENCIES

UNIT OF COMPETENCY: PERFORM RELATIONAL DATABASE MANAGEMENT IN
ORACLE DATABASE TECHNOLOGY

UNIT CODE : ICT313361
UNIT DESCRIPTOR : This unit introduces the fundamentals of SQL using Oracle
Database technology. Specifically it teaches the concepts of
relational databases and the SQL programming language. It
teaches how to write queries against single and multiple tables,
manipulate data in tables, and create database objects. It also
teaches how to use single row functions to customize output, use
conversion functions and conditional expressions.
This unit also focuses on how to effectively use SQL commands
against business data. It teaches features that will help query and
data manipulation within the database and also how to use the
dictionary views to retrieve metadata and create reports about their
schema objects. Further, it also teaches features on how to set
user access level and usage of scalar and correlated sub-queries.

ELEMENT PERFORMANCE CRITERIA
Italicized terms are elaborated in the Range of Variables
1. Retrieve Data 1.1 Capabilities of SQL SELECT statements are listed in accordance
Using the SQL with PL/SQL framework
SELECT Statement 1.2 Report of data from the output of a basic SELECT statement is
generated in accordance with PL/SQL framework
1.3 Arithmetic expressions and NULL values are used in accordance
with PL/SQL framework
1.4 Column aliases are implemented in accordance with PL/SQL
framework
1.5 Concatenation operator, literal character strings, alternative
quote operator, and the DISTINCT keyword are described in
accordance with PL/SQL framework
1.6 Data is Sorted and Restricted in accordance with PL/SQL
framework
2. Use Single-Row 2.1 Single row and multiple row functions are differentiated in
Functions to accordance with PL/SQL framework
Customize Output 2.2 Strings using character functions are manipulated in accordance
with PL/SQL framework
2.3 Numbers with the ROUND, TRUNC, and MOD functions are
manipulated in accordance with PL/SQL framework
2.4 Arithmetic with date data are performed in accordance with
PL/SQL framework
2.5 Dates with the DATE functions are manipulated in
accordance with PL/SQL framework
2.6 Functions and Conditional Expressions are converted
in accordance with PL/SQL framework

_________________________________________________________________________________ 29
TR – Programming (Oracle Database) NC III Promulgated – December 2013