SAQA

All qualifications and part qualifications registered on the National Qualifications Framework are public property. Thus the only payment that can be made for them is for service and reproduction. It is illegal to sell this material for profit. If the material is reproduced or quoted, the South African Qualifications Authority (SAQA) should be acknowledged as the source.

SOUTH AFRICAN QUALIFICATIONS AUTHORITY

REGISTERED UNIT STANDARD THAT HAS PASSED THE END DATE:

Develop simple SQL queries

SAQA US ID	UNIT STANDARD TITLE
258642	Develop simple SQL queries
ORIGINATOR
SGB Geographical Information Sciences
PRIMARY OR DELEGATED QUALITY ASSURANCE FUNCTIONARY
-
FIELD			SUBFIELD
Field 12 - Physical Planning and Construction			Physical Planning, Design and Management
ABET BAND	UNIT STANDARD TYPE	PRE-2009 NQF LEVEL	NQF LEVEL	CREDITS
Undefined	Regular	Level 6	Level TBA: Pre-2009 was L6	4
REGISTRATION STATUS		REGISTRATION START DATE	REGISTRATION END DATE	SAQA DECISION NUMBER
Passed the End Date - Status was "Reregistered"		2018-07-01	2023-06-30	SAQA 06120/18
LAST DATE FOR ENROLMENT		LAST DATE FOR ACHIEVEMENT
2024-06-30		2027-06-30

In all of the tables in this document, both the pre-2009 NQF Level and the NQF Level is shown. In the text (purpose statements, qualification rules, etc), any references to NQF Levels are to the pre-2009 levels unless specifically stated otherwise.

This unit standard does not replace any other unit standard and is not replaced by any other unit standard.

PURPOSE OF THE UNIT STANDARD

This unit standard has been developed for the GIS occupational area and is intended for persons who aim to achieve career advancement by gaining GIS skills leading to qualification based on unit standards. A person who has successfully completed this unit standard will be able to create, store, execute SQL queries and retrieve results from such queries.

A person credited with this unit standard is able to:

Create and execute a simple SQL query under supervision.

Create and execute combinations of simple alphanumeric queries under supervision.

Multiple alphanumeric selection queries are created, executed and stored under supervision.

LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING

The credit calculation is based on the assumption that learners are already competent in terms of the:

Communication at NQF Level 5.

Mathematical Literacy at NQF Level 5.

ID 116936: Use a Graphical User Interface based database application to work with simple databases.

ID 117927: Use a Graphical User Interface-based database application to solve a given problem.

UNIT STANDARD RANGE

The following scope and context applies to the whole unit standard:

Including SELECT and WHERE statements.

Specific range statements are provided in the body of the unit standard where they apply to particular specific outcomes or assessment criteria.

Specific Outcomes and Assessment Criteria:

SPECIFIC OUTCOME 1

Create and execute a simple SQL query under supervision.

ASSESSMENT CRITERIA

ASSESSMENT CRITERION 1

1 A SELECT SQL clause is used in a query.

ASSESSMENT CRITERION RANGE

E.g. SELECT * FROM PARCELS.

ASSESSMENT CRITERION 2

Fields are specified in the select statement.

ASSESSMENT CRITERION RANGE

E.g. SELECT OWNERID, OCCUPANTID FROM PARCELS.

ASSESSMENT CRITERION 3

Fields are aliased in the select statement.

ASSESSMENT CRITERION RANGE

E.g. SELECT OWNERID O, OCCUPANTID ID FROM PARCELS.

ASSESSMENT CRITERION 4

A WHERE SQL clause is used in a query.

ASSESSMENT CRITERION RANGE

E.g. SELECT * FROM parcels WHERE ownerid = '12345'.

ASSESSMENT CRITERION 5

An SQL wildcard clause is used in a query.

ASSESSMENT CRITERION RANGE

E.g. SELECT * FROM parcels WHERE ownerid LIKE '12%'.

SPECIFIC OUTCOME 2

Create and execute combinations of simple alphanumeric queries under supervision.

ASSESSMENT CRITERIA

ASSESSMENT CRITERION 1

Use Boolean operators in a SQL query.

ASSESSMENT CRITERION RANGE

AND, OR, NOT, XOR.

ASSESSMENT CRITERION 2

A SQL query that includes fields from two tables is created under supervision.

ASSESSMENT CRITERION RANGE

E.g. SELECT a.ownerid, b.ownername FROM parcels a, person b WHERE a.ownerid = b.id.

SPECIFIC OUTCOME 3

Multiple alphanumeric selection queries are created, executed and stored under supervision.

ASSESSMENT CRITERIA

ASSESSMENT CRITERION 1

The results of an SQL query are spooled to an ASCII file.

ASSESSMENT CRITERION 2

A group of queries are created and stored to be executed from the command line.

ASSESSMENT CRITERION 3

BATCH files are created to execute queries and to obtain repeated results.

UNIT STANDARD ACCREDITATION AND MODERATION OPTIONS

Anyone assessing a learner against this unit standard must be registered as an assessor with the relevant ETQA.

Any institution offering learning that will enable achievement of this unit standard must be accredited as a provider through the relevant ETQA by SAQA.

Moderation of assessment will be overseen by the relevant ETQA according to the moderation guidelines and the agreed ETQA procedures.

UNIT STANDARD ESSENTIAL EMBEDDED KNOWLEDGE

Essential embedded knowledge will be assessed through assessment of the specific outcomes in terms of the stipulated assessment criteria. Candidates are unlikely to achieve all the specific outcomes, to the standards described in the assessment criteria, without knowledge of the listed embedded knowledge. This means that for the most part, the possession or lack of the knowledge can be directly inferred from the quality of the candidate's performance. Where direct assessment of knowledge is required, assessment criteria have been included in the body of the unit standard.

UNIT STANDARD DEVELOPMENTAL OUTCOME

N/A

UNIT STANDARD LINKAGES

N/A

Critical Cross-field Outcomes (CCFO):

UNIT STANDARD CCFO IDENTIFYING

Solve problems.

UNIT STANDARD CCFO WORKING

Work effectively with others as a member of a team/group/organisation or community.

UNIT STANDARD CCFO ORGANISING

Organise and manage oneself and one`s activities responsibly and effectively.

UNIT STANDARD CCFO COLLECTING

Collect, organise and critically evaluate information.

UNIT STANDARD CCFO COMMUNICATING

Communicate effectively using visual, mathematics and language skills in the modes of oral and written presentations.

UNIT STANDARD CCFO SCIENCE

Use science and technology effectively and critically (showing responsibility towards the environment and health of others).

UNIT STANDARD CCFO DEMONSTRATING

Display an understanding of the world as a set of related systems.

UNIT STANDARD CCFO CONTRIBUTING

Contribute to the full development of each learner and the social and economic development of society at large.

UNIT STANDARD ASSESSOR CRITERIA

N/A

REREGISTRATION HISTORY

As per the SAQA Board decision/s at that time, this unit standard was Reregistered in 2012; 2015.

UNIT STANDARD NOTES

Notes to Assessors:

A simple database with a number of one to many relationships and enough data must be prepared and provided to learners.

QUALIFICATIONS UTILISING THIS UNIT STANDARD:

	ID	QUALIFICATION TITLE	PRE-2009 NQF LEVEL	NQF LEVEL	STATUS	END DATE	PRIMARY OR DELEGATED QA FUNCTIONARY
Core	63689	Bachelor of Arts: Geographical Information Science	Level 6	Level TBA: Pre-2009 was L6	Passed the End Date - Status was "Reregistered"	2018-06-30
Elective	63589	National Diploma: Geographical Information Science	Level 5	NQF Level 05	Passed the End Date - Status was "Reregistered"	2023-06-30	CETA

PROVIDERS CURRENTLY ACCREDITED TO OFFER THIS UNIT STANDARD:

This information shows the current accreditations (i.e. those not past their accreditation end dates), and is the most complete record available to SAQA as of today. Some Primary or Delegated Quality Assurance Functionaries have a lag in their recording systems for provider accreditation, in turn leading to a lag in notifying SAQA of all the providers that they have accredited to offer qualifications and unit standards, as well as any extensions to accreditation end dates. The relevant Primary or Delegated Quality Assurance Functionary should be notified if a record appears to be missing from here.

1.	ESRI SOUTH AFRICA