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: 

Use the SQL language to create, modify, query and manage a database application 
SAQA US ID UNIT STANDARD TITLE
258777  Use the SQL language to create, modify, query and manage a database application 
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 7  Level TBA: Pre-2009 was L7  8 
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 is useful for people who aim to achieve career advancement in the GIS field and provides them with essential knowledge in relation to the SQL language.

A person credited with this unit standard is able to:
  • Understand the SQL language structure.
  • Use SQL to define a relational database environment.
  • Use SQL to manipulate data in a relational database environment.
  • Use SQL to query a database.
  • Understand advanced concepts in SQL needed to perform query and database management tasks. 
    		•

    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 following outcomes or areas of learning when starting to learn towards this unit standard:
  • Design and develop a simple database.
  • Communication at NQF Level 6.
  • Mathematical Literacy at NQF Level 6. 
    		•

    UNIT STANDARD RANGE 
    The following scope and context applies to the whole unit standard:
  • This unit standard is focused on the international SQL: 2003 standard. Syntax or expressions herein refer specifically to compliant platforms only.

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

    Range statements are included with specific outcomes as necessary. 
    		•

    Specific Outcomes and Assessment Criteria: 

    SPECIFIC OUTCOME 1 
    Understand and explain the SQL language structure in the context of international SQL: 2003 standards. 

    ASSESSMENT CRITERIA     

    ASSESSMENT CRITERION 1 
    The basic syntax of the language is understood and explained in the context of international SQL: 2003 standards. 

    ASSESSMENT CRITERION 2 
    The basic data types used in the SQL language is understood and explained in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Including but not limited to:
  • Numeric types.
  • Character types.
  • Date types.
  • Currency types.
     
    		•

    ASSESSMENT CRITERION 3 
    The basic types of operators used in the SQL language is understood and explained in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Including operators in the following groups:
  • Logical Operators.
  • Comparison Operators.
  • Mathematical Functions and Operators.
     
    		•

    ASSESSMENT CRITERION 4 
    Special characters used in the SQL language is understood and explained in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
  • A dollar sign.
  • Parentheses.
  • Brackets.
  • Commas.
  • The semicolon.
  • The colon.
  • The asterisk.
  • The period.
     
    		•

    ASSESSMENT CRITERION 5 
    Lexical precedences of operators used in the SQL language is understood and explained in the context of international SQL: 2003 standards. 

    SPECIFIC OUTCOME 2 
    Use SQL to define a relational database environment in the context of international SQL: 2003 standards. 

    ASSESSMENT CRITERIA     

    ASSESSMENT CRITERION 1 
    The command to modify database objects using SQL statements is understood and explained in the context of the following range statement. 
    ASSESSMENT CRITERION RANGE 
    Including but not limited to Modify, Databases, Schemas, Tables, Fields, Indexes, Relationships and Views.
     

    ASSESSMENT CRITERION 2 
    The command to drop database objects using SQL statements is understood and explained in the context of the following range statement. 
    ASSESSMENT CRITERION RANGE 
    Including but not limited to Drop, Databases, Schemas, Tables, Fields, Indexes, Relationships and Views.
     

    ASSESSMENT CRITERION 3 
    The command to create database objects using SQL statements is understood and explained in the context of the following range statement. 
    ASSESSMENT CRITERION RANGE 
    Including but not limited to Create, Databases, Schemas, Tables, Fields, Indexes, Relationships and Views.
     

    ASSESSMENT CRITERION 4 
    Data structures are constrained using SQL statements in the context of the following range statement. 
    ASSESSMENT CRITERION RANGE 
    Including Pimary Keys, foreign keys (References), Unique, Not Null and Check constraints.
     

    SPECIFIC OUTCOME 3 
    Use SQL to manipulate data in a relational database environment in the context of international SQL: 2003 standards. 

    ASSESSMENT CRITERIA     

    ASSESSMENT CRITERION 1 
    Data are inserted using SQL statements in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Insert.
     

    ASSESSMENT CRITERION 2 
    Data are deleted using SQL statements in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Delete.
     

    ASSESSMENT CRITERION 3 
    Data are modified using SQL statements in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Modify.
     

    ASSESSMENT CRITERION 4 
    Data are inserted using bulk SQL statements in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Copy, data Dumps.
     

    SPECIFIC OUTCOME 4 
    Use SQL to query a database in the context of international SQL: 2003 standards. 

    ASSESSMENT CRITERIA     

    ASSESSMENT CRITERION 1 
    Data are extracted using basic SQL queries in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Using the Select statement.
     

    ASSESSMENT CRITERION 2 
    Data are summarised using SQL queries in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Min, Max, Count, Avg, Sum, Distinct and As statements.
     

    ASSESSMENT CRITERION 3 
    Data subsets are extracted using conditional SQL queries in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Where statement.
     

    ASSESSMENT CRITERION 4 
    Data are extracted from multiple tables using SQL queries in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Including Where, Inner Join and Outer Join statements.
     

    ASSESSMENT CRITERION 5 
    Conditional statements in SQL queries are optimised in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Group By, Having and indexing considerations.
     

    ASSESSMENT CRITERION 6 
    Pattern Matching in SQL queries are optimised in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    And, Not, Like and Similar To.
     

    SPECIFIC OUTCOME 5 
    Understand advanced concepts in SQL needed to perform query and database management tasks in the context of international SQL: 2003 standards. 

    ASSESSMENT CRITERIA     

    ASSESSMENT CRITERION 1 
    Indexes are understood and explained in the context of international SQL: 2003 standards. 

    ASSESSMENT CRITERION 2 
    Type Conversion are understood and explained in the context of international SQL: 2003 standards. 

    ASSESSMENT CRITERION 3 
    Conditional Expressions are understood and explained in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Including Case, Coalesc, Nullif, Greatest, and Least.
     

    ASSESSMENT CRITERION 4 
    Subquery Expressions are understood and explained in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    Including standard subqueries, Exists and In.
     

    ASSESSMENT CRITERION 5 
    Row and Array Comparisons are understood and explained in the context of international SQL: 2003 standards. 
    ASSESSMENT CRITERION RANGE 
    In, Not In, Any, Some, All.
     

    ASSESSMENT CRITERION 6 
    System Information Functions are understood and explained in the context of international SQL:2003 standards. 


    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 is dealt with under the specific outcomes section where "Demonstrate KNOWLEDGE and UNDERSTANDING" is required. 

    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 
    N/A 

    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   
    Core  63711   Bachelor of Geographical Information Science (GISc)  Level 7  NQF Level 07  Passed the End Date -
    Status was "Reregistered"     		 2018-06-30   


    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.
     
    NONE 


    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.