PROGRAMMING (ORACLE DATABASE) NC III – TESDA COURSE MODULE

TESDA TRAINING REGULATIONS FOR PROGRAMMING (ORACLE DATABASE) NC III

This TESDA Course is delivered in cooperation with Oracle’s Workforce Development Program (WDP). Oracle Corporation launched WDP to address the continued global information technology (IT) worker shortage and need for accessible and low cost IT skills training. WDP enables participating educational institutions to deliver Oracle training in full-time and part-time programs for students in their local communities. WDP training will prepare students for Oracle certification testing. With the widely-acclaimed credential of Oracle certification, WDP students are readied for a variety of entry-level Oracle job-roles as well as career advancement.

The TESDA Programming (Oracle Database) NC III Course consists of competencies that a person must achieve to develop or write program codes using a personal computer or workstation as part of a systems development team. It includes core competencies on programming language on PL/SQL, such as to write SQL queries to access data stored in an Oracle database and use functions to customize data output.

At the end of the course, participants should be equipped with sufficient knowledge to take and pass the internationally acknowledged Oracle PL/SQL Certified Associate and Certified Professional Exam.

This Qualification is packaged from the competency map of the Information and Communication Technology Industry (Service sector)

Oracle Certification Explanations:

The Oracle Certified Associate (OCA) credential is typically the first step toward achieving the flagship Oracle Certified Professional certification. The OCA credential ensures that the individual is equipped with fundamental skills, providing a strong foundation for supporting Oracle products. An OCA credential is available for several of today’s most in demand technology job roles.

The Oracle Certified Professional (OCP) credential is the benchmark of professional skill and technical expertise required to manage, develop, or implement enterprise-wide databases, middleware, or applications. Increasingly, IT managers use the OCP credential to evaluate the qualifications of employees and job candidates.

A trainee or student person who has achieved this Qualification can be employed in any or more of the following:

• Application Developers
• Forms Developer
• Functional Implementer
• PL/SQL Developer
• Portal Developer
• Reports Developer
• Technical Consultant

TRAINEE ENTRY REQUIREMENTS

Trainees or students wishing to gain entry into this course should possess the following requirements:

• Must have completed at least 10 yrs. basic education or an ALS grade 10 certificate of rating holder Must have completed at least 10 yrs. basic education or an ALS grade 10 certificate of rating holder
• can communicate either oral or written;
• with basic computer skills

This list does not include specific institutional requirements such as educational attainment, appropriate work experience and others that may be required from the trainees by the school or training center delivering the TVET program.

PROGRAMMING (ORACLE DATABASE) NC III TESDA COURSE MODULE

Course Title: PROGRAMMING (ORACLE DATABASE)
Level: NC III
Nominal Training Duration :

• (Basic Competency) 64 hours
• (Common Competency) 16 hours
• (Core Competency) 160 hours

TOTAL DURATION: 240 Hours

This course is designed to develop & enhance the knowledge, skills, & attitudes of a programmer in accordance with industry standards. It covers the basic, common & core competencies on programming language, specifically Oracle Database. The nominal duration of 240 hours covers the required units at Programming (Oracle Database) NC III. TVET providers can however, offer a longer, ladderized course covering the basic, common and core plus specialized competency unit/s.

COMPETENCIES REQUIRED IN PROGRAMMING (ORACLE DATABASE) NC III

This units of competency comprising this qualification include Basic, Common and Core Competencies.

To obtain this TESDA Course in PROGRAMMING (ORACLE DATABASE) NC III, all units prescribed below for this qualification must be achieved.

These units of competency comprising this qualification include the following:

UNIT CODE	CORE COMPETENCIES (160 hours)
ICT313361	Perform relational database management in Oracle database technology
ICT313362	Use and apply PL/SQL Programming Language
ICT313363	Design and tune PL/SQL Language
UNIT CODE	COMMON COMPETENCIES (16 hours)
ICT315202	Apply quality standards
ICT311203	Perform computer operations
UNIT CODE	BASIC COMPETENCIES (64 hours)
500311109	Lead Workplace Communication
500311110	Lead Small Teams
500311111	Develop and Practice Negotiation skills
500311112	Solve Problems Related to Work Activities
500311113	Use Mathematical Concepts and Techniques
500311114	Use Relevant Technologies

These guidelines are set to provide the Technical Vocational Education and Training (TVET) providers with information and other important requirements to consider when designing training programs for PROGRAMMING (ORACLE DATABASE) NC III.

CORE COMPETENCIES

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

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.

1. Retrieve Data Using the SQL SELECT Statement
   • Capabilities of SQL SELECT statements are listed in accordance with PL/SQL framework
   • Report of data from the output of a basic SELECT statement is generated in accordance with PL/SQL framework
   • Arithmetic expressions and NULL values are used in accordance with PL/SQL framework
   • Column aliases are implemented in accordance with PL/SQL framework
   • Concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword are described in accordance with PL/SQL framework
   • Data is Sorted and Restricted in accordance with PL/SQL framework
2. Use Single-Row Functions to Customize Output
   • Single row and multiple row functions are differentiated in accordance with PL/SQL framework
   • Strings using character functions are manipulated in accordance with PL/SQL framework
   • Numbers with the ROUND, TRUNC, and MOD functions are manipulated in accordance with PL/SQL framework
   • Arithmetic with date data are performed in accordance with PL/SQL framework
   • Dates with the DATE functions are manipulated in accordance with PL/SQL framework
   • Functions and Conditional Expressions are converted in accordance with PL/SQL framework
3. Display Data From Multiple Tables Using Joins
   • SELECT statements to access data from more than one table are written in accordance with PL/SQL framework
   • Tables Using SQL:1999 Syntax are joined in accordance with PL/SQL framework
   • Data that does not meet a join condition by using outer joins are viewed in accordance with PL/SQL framework
   • Cross Joins are created in accordance with PL/SQL framework
4. Manipulate Data
   • New Rows to a Table are added in accordance with PL/SQL framework
   • Data in a Table are changed in accordance with PL/SQL framework
   • DELETE and TRUNCATE Statements are used in accordance with PL/SQL framework
   • COMMIT and ROLLBACK statements are saved in accordance with PL/SQL framework
   • Read Consistency is implemented in accordance with PL/SQL framework
   • FOR UPDATE Clause is described in accordance with PL/SQL framework
   • DDL Statements to Create and Manage Tables are used in accordance with PL/SQL framework
5. Control User Access
   • System and Object Privileges are identified in accordance with PL/SQL framework
   • Users are created in accordance with PL/SQL framework
   • System Privileges are granted in accordance with PL/SQL framework
   • Privileges to a Role are created and granted in accordance with PL/SQL framework
   • Object Privileges are granted in accordance with PL/SQL framework
   • Privileges are passed in accordance with PL/SQL framework
   • Object Privileges are revoked in accordance with PL/SQL framework
   • Schema Objects are managed in accordance with PL/SQL framework
   • Objects with Data Dictionary Views are managed in accordance with PL/SQL framework
6. Manipulate Large Data Sets
   • Subqueries to Manipulate Data are used in accordance with PL/SQL framework
   • Data Using a Subquery as Source are retrieved in accordance with PL/SQL framework
   • Data Using a Subquery as a Target are inserted in accordance with PL/SQL framework
   • The WITH CHECK OPTION Keyword on DML Statements are used in accordance with PL/SQL framework
   • The types of Multitable INSERT Statements are listed in accordance with PL/SQL framework
   • Multitable INSERT Statements are identified in accordance with PL/SQL framework
7. Manage Data in Different Time Zones
   • Date and Time in a Session’s Time Zone are compared in accordance with PL/SQL framework
   • DBTIMEZONE and SESSIONTIMEZONE are described in accordance with PL/SQL framework
   • The differences between DATE and TIMESTAMP are listed in accordance with PL/SQL framework
   • he INTERVAL Data Types are identified in accordance with PL/SQL framework
   • EXTRACT, TZ_OFFSET and FROM_TZ functions are used in accordance with PL/SQL framework
   • TO_TIMESTAMP, TO_YMINTERVAL, and TO_DSINTERVAL are used in accordance with PL/SQL framework
8. Retrieve Data Using Subqueries
   • Pairwise and Nonpairwise are compared in accordance with PL/SQL framework
   • Scalar Subquery Expressions are used in accordance with PL/SQL framework
   • Problems with Correlated Subqueries are solved in accordance with PL/SQL framework
   • Correlated Subqueries are updated and deleted in accordance with PL/SQL framework
   • The EXISTS and NOT EXISTS operators are used in accordance with PL/SQL framework
   • The WITH clause is used in accordance with PL/SQL framework
   • The Recursive WITH clause is used in accordance with PL/SQL framework

UNIT OF COMPETENCY: USE AND APPLY PL/SQL PROGRAMMING LANGUAGE
UNIT CODE : ICT313363

This unit introduces the student to PL/SQL language and explains the benefits of this programming language. The student will learn to develop stored procedures, functions, packages and other basic functions.

1. Declare PL/SQL Identifiers
   • PL/SQL language is introduced in accordance with PL/SQL framework
   • List the different Types of Identifiers in a PL/SQL subprogram in accordance with PL/SQL framework
   • Declarative Section to Define Identifiers are used in accordance with PL/SQL framework
   • Variables to store data are used in accordance with PL/SQL framework
   • Scalar Data Types are identified in accordance with PL/SQL framework
   • Sequences in PL/SQL Expressions are used in accordance with PL/SQL framework
   • Executable Statements are written in accordance with PL/SQL framework
2. Apply Interaction with the Oracle Server
   • SELECT Statements in PL/SQL are invoked in accordance with PL/SQL framework
   • Data in PL/SQL are retrieved in accordance with PL/SQL framework
   • Errors by using Naming Conventions when using Retrieval and DML Statements are avoided in accordance with PL/SQL framework
   • Data in the Server using PL/SQL is manipulated in accordance with PL/SQL framework
   • SQL Cursor Attributes to Obtain Feedback on DML are used in accordance with PL/SQL framework
3. Apply Exception Handling
   • Exceptions are understood in accordance with PL/SQL framework
   • Exceptions with PL/SQL are handled in accordance with PL/SQL framework
   • Predefined Oracle Server Errors are trapped in accordance with PL/SQL framework
   • Non-Predefined Oracle Server Errors are trapped in accordance with PL/SQL framework
   • User-Defined Exceptions are trapped in accordance with PL/SQL framework
   • Exceptions are propagated in accordance with PL/SQL framework
4. Store Procedures
   • Modularized and Layered Subprogram Design are created in accordance with PL/SQL framework
   • Development With PL/SQL Blocks are modularized in accordance with PL/SQL framework
   • PL/SQL Execution Environment are understood in accordance with PL/SQL framework
   • Benefits of using PL/SQL Subprograms are listed in accordance with PL/SQL framework
   • Differences between Anonymous Blocks and Subprograms are listed in accordance with PL/SQL framework
   • Procedures Parameters and Parameters Modes are implemented in accordance with PL/SQL framework
   • Procedure Information is viewed in accordance with PL/SQL framework

UNIT OF COMPETENCY: DESIGN AND TUNE PL/SQL LANGUAGE
UNIT CODE : ICT313364

This unit covers the advanced features of PL/SQL to design and tune PL/SQL. It also covers how to manage PL/SQL to interface with the database and other applications in the most efficient manner

1. Design PL/SQL Code
   • Predefined data types are described in accordance with PL/SQL framework
   • Subtypes based on existing types for an application are created in accordance with PL/SQL framework
   • Different guidelines for cursor design are listed in accordance with PL/SQL framework
   • Collections are used in accordance with PL/SQL framework
   • Manipulating Large Objects are manipulated in accordance with PL/SQL framework
2. Use Advanced Interface Methods
   • External Procedures from PL/SQL are called in accordance with PL/SQL framework
   • Benefits of External Procedures are listed in accordance with PL/SQL framework
   • C advanced interface methods are shown in accordance with PL/SQL framework
   • Java advanced interface methods are shown in accordance with PL/SQL framework
3. Apply Performance and Tuning to PL/SQL code
   • The compiler is understood and influenced in accordance with PL/SQL framework
   • PL/SQL code is tuned in accordance with PL/SQL framework
   • Intra unit in-lining is enabled in accordance with PL/SQL framework
   • Memory issues are identified and tuned in accordance with PL/SQL framework
   • Network issues are recognized in accordance with PL/SQL framework
   • Performance with Caching is improved in accordance with PL/SQL framework
4. Implement virtual private database (VPD) with Fine-Grained Access Control
   • How fine-grained access control works overall is understood in accordance with PL/SQL framework
   • Features of fine-grained access control are described in accordance with PL/SQL framework
   • An application context is described in accordance with PL/SQL framework
   • An application context is created in accordance with PL/SQL framework
   • An application context is set in accordance with PL/SQL framework
   • The DBMS_RLS procedures are listed in accordance with PL/SQL framework
   • A policy is implemented in accordance with PL/SQL framework
   • Dictionary views holding information on fine-grained access are queried in accordance with PL/SQL framework

COMMON COMPETENCIES

UNIT TITLE : APPLY QUALITY STANDARDS
UNIT CODE : ICT315202

This unit covers the knowledge, skills, attitudes and values needed to apply quality standards in the workplace. The unit also includes the application of relevant safety procedures and regulations, organization procedures and customer requirements.

1. Assess quality of received materials
   • Work instruction is obtained and work is carried out in accordance with standard operating procedures.
   • Received materials are checked against workplace standards and specifications.
   • Faulty materials related to work are identified and isolated.
   • Faults and any identified causes are recorded and/or reported to the supervisor concerned in accordance with workplace procedures.
   • Faulty materials are replaced in accordance with workplace procedures.
2. Assess own work
   • Documentation relative to quality within the company is identified and used.
   • Completed work is checked against workplace standards relevant to the task undertaken.
   • Errors are identified and isolated.
   • Information on the quality and other indicators of production performance are recorded in accordance with workplace procedures.
   • In cases of deviations from specific quality standards, causes are documented and reported in accordance with the workplace’ s standards operating procedures.
3. Engage in quality improvement (Produce)
   • Process improvement procedures are participated in relative to workplace assignment.
   • Work is carried out in accordance with process improvement procedures.
   • Performance of operation or quality of product of service to ensure customer satisfaction is monitored.

UNIT TITLE : PERFORM COMPUTER OPERATIONS
UNIT CODE : ICT 311203

This unit covers the knowledge, skills, attitudes and values needed to perform computer operations which include inputting, accessing, producing and transferring data using the appropriate hardware and software.

1. Plan and prepare for task to be taken undertaken
   • Requirements of task are determined in accordance with the required output.
   • Appropriate hardware and software are selected according to task assigned and required outcome.
   • Task is planned to ensure that OH & S guidelines and procedures are followed.
   • Client -specific guidelines and procedures are followed.
   • Required data security guidelines are applied in accordance with existing procedures.
2. Input data into computer
   • Data are entered into the computer using appropriate program/application in accordance with company procedures.
   • Accuracy of information is checked and information is saved in accordance with standard operating procedures.
   • Inputted data is stored in storage media according to requirements.
   • Work is performed within ergonomic guidelines.
3. Access information using computer
   • Correct program/application is selected based on job requirements.
   • Program/application containing the information required is accessed according to company procedures.
   • Desktop icons are correctly selected, opened and closed for navigation purposes.
   • Keyboard techniques are carried out in line with OH & S requirements for safe use of keyboards.
4. Produce output/data using computer system
   • Entered data are processed using appropriate software commands.
   • Data are printed out as required using computer hardware /peripheral devices in accordance with standard operating procedures.
   • Files and data are transferred between compatible systems using computer software, hardware/peripheral devices in accordance with standard operating procedures.
5. Use basic functions of a www-browser to locate information
   • Information requirements for internet search are established.
   • Browser is launched.
   • Search engine is loaded.
   • Appropriate search criteria/or URL of site is entered.
   • Relevant links are followed to locate required information.
   • Useful pages are bookmarked or printed as required
6. Maintain computer equipment and systems
   • Procedures for ensuring security of data, including regular back-ups and virus checks are implemented in accordance with standard operating procedures.
   • Basic file maintenance procedures are implemented in line with the standards operating procedures.

BASIC COMPETENCIES

The BASIC COMPETENCIES refer to non-technical skills (knowledge, skills and attitudes) that everybody will need in order to perform satisfactorily at work and in society and are considered portable and transferable irrespective of jobs and industrial settings.

UNIT OF COMPETENCY : LEAD WORKPLACE COMMUNICATION
UNIT CODE : 500311109

This unit covers the knowledge, skills and attitudes required to lead in the dissemination and discussion of ideas, information and issues in the workplace.

1. Communicate information about workplace processes
   • Appropriate communication method is selected
   • Multiple operations involving several topics areas are communicated accordingly
   • Questions are used to gain extra information
   • Correct sources of information are identified
   • Information is selected and organized correctly
   • Verbal and written reporting is undertaken when required
   • Communication skills are maintained in all situations
2. Lead workplace discussions
   • Response to workplace issues are sought
   • Response to workplace issues are provided immediately
   • Constructive contributions are made to workplace discussions on such issues as production, quality and safety
   • Goals/objectives and action plan undertaken in the workplace are communicated
3. Identify and communicate issues arising in the workplace
   • Issues and problems are identified as they arise
   • Information regarding problems and issues are organized coherently to ensure clear and effective communication
   • Dialogue is initiated with appropriate personnel
   • Communication problems and issues are raised as they arise

UNIT OF COMPETENCY : LEAD SMALL TEAMS
UNIT CODE : 500311110

This unit covers the knowledge, skills and attitudes to lead small teams including setting and maintaining team and individual performance standards.

1. Provide team leadership
   • Work requirements are identified and presented to team members
   • Reasons for instructions and requirements are communicated to team members
   • Team members’ queries and concerns are recognized, discussed and dealt with
2. Assign responsibilities
   • Duties, and responsibilities are allocated having regard to the skills, knowledge and aptitude required to properly undertake the assigned task and according to company policy
   • Duties are allocated having regard to individual preference, domestic and personal considerations, whenever possible
3. Set performance expectations for team members
   • Performance expectations are established based on client needs and according to assignment requirements
   • Performance expectations are based on individual team members duties and area of responsibility
   • Performance expectations are discussed and disseminated to individual team members
4. Supervised team performance
   • Monitoring of performance takes place against defined performance criteria and/or assignment instructions and corrective action taken if required
   • Team members are provided with feedback, positive support and advice on strategies to overcome any deficiencies
   • Performance issues which cannot be rectified or addressed within the team are referenced to appropriate personnel according to employer policy
   • Team members are kept informed of any changes in the priority allocated to assignments or tasks which might impact on client/customer needs and satisfaction
   • Team operations are monitored to ensure that employer/client needs and requirements are met
   • Follow-up communication is provided on all issues affecting the team
   • All relevant documentation is completed in accordance with company procedures

UNIT OF COMPETENCY : DEVELOP AND PRACTICE NEGOTIATION SKILLS
UNIT CODE : 500311111

This unit covers the skills, knowledge and attitudes required to collect information in order to negotiate to a desired outcome and participate in the negotiation.

1. Plan negotiations
   • Information on preparing for negotiation is identified and included in the plan
   • Information on creating non verbal environments for positive negotiating is identified and included in the plan
   • Information on active listening is identified and included in the plan
   • Information on different questioning techniques is identified and included in the plan
   • Information is checked to ensure it is correct and up-to- date
2. Participate in negotiations
   • Criteria for successful outcome are agreed upon by all parties
   • Desired outcome of all parties are considered
   • Appropriate language is used throughout the negotiation
   • A variety of questioning techniques are used
   • The issues and processes are documented and agreed upon by all parties
   • Possible solutions are discussed and their viability assessed
   • Areas for agreement are confirmed and recorded
   • Follow-up action is agreed upon by all parties

UNIT OF COMPETENCY : SOLVE PROBLEMS RELATED TO WORK ACTIVITIES
UNIT CODE : 500311112

This unit of covers the knowledge, skills and attitudes required to solve problems in the workplace including the application of problem solving techniques and to determine and resolve the root cause of problems.

1. Identify the problem
   • Variances are identified from normal operating parameters; and product quality
   • Extent, cause and nature are of the problem are defined through observation, investigation and analytical techniques
   • Problems are clearly stated and specified
2. Determine fundamental causes of the problem
   • Possible causes are identified based on experience and the use of problem solving tools / analytical techniques.
   • Possible cause statements are developed based on findings
   • Fundamental causes are identified per results of investigation conducted
3. Determine corrective action
   • All possible options are considered for resolution of the problem
   • Strengths and weaknesses of possible options are considered
   • Corrective actions are determined to resolve the problem and possible future causes
   • Action plans are developed identifying measurable objectives, resource needs and timelines in accordance with safety and operating procedures
4. Provide recommendation/s to manager
   • Report on recommendations are prepared
   • Recommendations are presented to appropriate personnel.
   • Recommendations are followed-up, if required

UNIT OF COMPETENCY : USE MATHEMATICAL CONCEPTS AND TECHNIQUES
UNIT CODE : 500311113

This unit covers the knowledge, skills and attitudes required in the application of mathematical concepts and techniques.

1. Identify mathematical tools and techniques to solve problem
   • Problem areas are identified based on given condition
   • Mathematical techniques are selected based on the given problem
2. Apply mathematical procedure/solution
   • Mathematical techniques are applied based on the problem identified
   • Mathematical computations are performed to the level of accuracy required for the problem
   • Results of mathematical computation is determined and verified based on job requirements
3. Analyze results
   • Result of application is reviewed based on expected and required specifications and outcome
   • Appropriate action is applied in case of error

UNIT OF COMPETENCY : USE RELEVANT TECHNOLOGIES
UNIT CODE : 500311114

This unit of competency covers the knowledge, skills, and attitude required in selecting, sourcing and applying appropriate and affordable technologies in the workplace.

1. Study/select appropriate technology
   • Usage of different technologies is determined based on job requirements
   • Appropriate technology is selected as per work specification
2. Apply relevant technology
   • Relevant technology is effectively used in carrying out function
   • Applicable software and hardware are used as per task requirement
   • Management concepts are observed and practiced as per established industry practices
3. Maintain/enhance relevant technology
   • Maintenance of technology is applied in accordance with the industry standard operating procedure, manufacturer’s operating guidelines and occupational health and safety procedure to ensure its operative ability
   • Updating of technology is maintained through continuing education or training in accordance with job requirement
   • Technology failure/ defect is immediately reported to the concern/responsible person or section for appropriate action

DEFINITION OF TERMS

GENERAL

• Certification – is the process of verifying and validating the competencies of a person through assessment
• Certificate of Competency (COC) – is a certification issued to individuals who pass the assessment for a single unit or cluster of units of competency
• Common Competencies – are the skills and knowledge needed by all people working in a particular industry
• Competency – is the possession and application of knowledge, skills and attitudes to perform work activities to the standard expected in the workplace
• Competency Assessment – is the process of collecting evidence and making judgments on whether competency has been achieved
• Competency Standard (CS) – is the industry-determined specification of competencies required for effective work performance
• Context of Assessment – refers to the place where assessment is to be conducted or carried out
• Core Competencies – are the specific skills and knowledge needed in a particular area of work – industry sector/occupation/job role
• Critical aspects of competency – refers to the evidence that is essential for successful performance of the unit of competency
• Elective Competencies – are the additional skills and knowledge required by the individual or enterprise for work
• Elements – are the building blocks of a unit of competency. They describe in outcome terms the functions that a person perform in the workplace
• Evidence Guide – is a component of the unit of competency that defines or identifies the evidences required to determine the competence of the individual. It provides information on critical aspects of competency, required knowledge, required skills, resource implications, assessment method and context of assessment
• Level – refers to the category of skills and knowledge required to do a job
• Method of Assessment – refers to the ways of collecting evidence and when evidence should be collected
• National Certificate (NC) – is a certification issued to individuals who achieve all the required units of competency for a national qualification defined under the Training Regulations. NCs are aligned to specific levels within the PTQF
• Performance Criteria – are evaluative statements that specify what is to be assessed and the required level of performance
• Qualification – is a cluster of units of competencies that meets job roles and is significant in the workplace. It is also a certification awarded to a person on successful completion of a course in recognition of having demonstrated competencies in an industry sector
• Range of Variables – describes the circumstances or context in which the work is to be performed
• Recognition of Prior Learning (RPL) – is the acknowledgement of an individual’s skills, knowledge and attitudes gained from life and work experiences outside registered training programs
• Resource Implications – refers to the resources needed for the successful performance of the work activity described in the unit of competency. It includes work environment and conditions, materials, tools and equipment
• Basic Competencies – are the skills and knowledge that everyone needs for work
• Training Regulations (TR) – refers to the document promulgated and issued by TESDA consisting of competency standards, national qualifications and training guidelines for specific sectors/occupations. The TR serves as basis for establishment of qualification and certification under the PTQF. It also serves as guide for development of competency-based curricula and instructional materials including registration of TVET programs offered by TVET providers
• Required Knowledge – refers to the competency that involves in applying knowledge to perform work activities. It includes specific knowledge that is essential to the performance of the competency
• Required Skills – refers to the list of the skills needed to achieve the elements and performance criteria in the unit of competency. It includes generic and industry specific skills
• Unit of Competency – is a component of the competency standards stating a specific key function or role in a particular job or occupation; it is the smallest component of achievement that can be assessed and certified under the PTQF

SECTOR SPECIFIC

• ADO.NET – is a set of computer software components that programmers can use to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems, though it can also access data in nonrelational sources. ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but was changed so extensively that it can be considered an entirely new product.
• ASP.NET – is a web application framework developed and marketed by Microsoft to allow programmers to build dynamic web sites, web applications and web services. ASP.NET is built on the Common Language Runtime (CLR), allowing programmers to write ASP.NET code using any supported .NET language.
• Algorithm – is a type of effective method in which a list of well-defined instructions for completing a task will, when given an initial state, proceed through a well-defined series of successive states, eventually terminating in an end-state. The transition from one state to the next is not necessarily deterministic; some algorithms, known as probabilistic algorithms, incorporate randomness.
• Artificial intelligence programmer – develops the logic the game uses to carry out a large number of actions. An AI programmer may program pathfinding, strategy and enemy tactic systems. This is one of the most challenging aspects of game programming and its sophistication is developing rapidly.
• Browser – a software package that provides the user interface for accessing Internet, intranet and extranet Web sites.
• COBOL – is one of the oldest programming languages. Its name is an acronym for Common Business-Oriented Language, defining its primary domain in business, finance, and administrative systems for companies and governments.
• Compiler – is a computer program (or set of programs) that transforms source code written in a programming language (the source language) into another computer language (the target language, often having a binary form known as object code). The most common reason for wanting to transform source code is to create an executable program.
• Computer – a device that has the ability to accept data; internally store and execute a program of instructions; perform mathematical, logical, and manipulative operations on data; and report the results.
• Computer program – also a software program, or just a program, is a sequence of instructions written to perform a specified task for a computer. A computer requires programs to function, typically executing the program’s instructions in a central processor. The program has an executable form that the computer can use directly to execute the instructions. The same program in its human-readable source code form, from which executable programs are derived (e.g., compiled), enables a programmer to study and develop its algorithms.
• Computer programming – is the iterative process of writing or editing source code. Editing source code involves testing, analyzing, and refining, and sometimes coordinating with other programmers on a jointly developed program. A person who practices this skill is referred to as a computer programmer, software developer or coder. The sometimes lengthy process of computer programming is usually referred to as software development.
• Computer Terminal – any input/output device connected by telecommunications links to a computer.
• C language – is an imperative (procedural) systems implementation language. It was designed to be compiled using a relatively straightforward compiler, to provide low-level access to memory, to provide language constructs that map efficiently to machine instructions, and to require minimal run-time support. C was therefore useful for many applications that had formerly been coded in assembly language.
• C++ language – is a statically typed, free-form, multi-paradigm, compiled, general purpose programming language. It comprises a combination of both high-level and low level language features. Some of its application domains include systems software, application software, device drivers, embedded software, high-performance server and client applications, and entertainment software such as video games.
• Data – objective measurements of the attributes (characteristics) of entities such as people, places, things, and events.
• Data access – typically refers to software and activities related to storing, retrieving, or acting on data housed in a database or other repository. Historically, different methods and languages were required for every repository, including each different database, file system, etc., and many of these repositories stored their content in different and incompatible formats.
• Decompiler – is the name given to a computer program that performs the reverse operation to that of a compiler. That is, it translates a file containing information at a relatively low level of abstraction (usually designed to be computer readable rather than human readable) into a form having a higher level of abstraction (usually designed to be human readable)
• Documentation – a collection of documents or information.
• Edit – to modify the form or format of data
• End user – anyone who uses an information system or the information it produces.
• Ergonomics – the science and technology emphasizing the safety, comfort, and ease of use of human-operated machines. The goal of ergonomics is to produce systems that are user-friendly: safe, comfortable and easy to use.
• HTML, which stands for HyperText Markup Language – is the predominant markup language for web pages. It is written in the form of HTML elements consisting of “tags” surrounded by angle brackets within the web page content. It is the building blocks of all basic websites.
• Information – data placed in a meaningful and useful context for an end user.
• Information and Communication Technology (ICT) – refers to technologies associated with the transmission and exchange of data in the form of sound, text, visual images, signals or any combination of those forms through the use of digital technology. It encompasses such services as telecommunications, posts, multimedia, electronic commerce, broadcasting, and information technology.
• Integrated development environment (IDE) – is a software application that provides comprehensive facilities to computer programmers for software development. An IDE normally consists of a source code editor, a compiler and/or interpreter, build automation tools, and (usually) a debugger. Typically an IDE is dedicated to a specific programming language, so as to provide a feature set which most closely matches the programming paradigms of the language. However, some multiple-language IDEs are in use, such as Eclipse, ActiveState Komodo, recent versions of NetBeans, and Microsoft Visual Studio.
• Java – is a general-purpose, concurrent, class-based, object-oriented language that is specifically designed to have as few implementation dependencies as possible. It is intended to let application developers “write once, run anywhere”. Java is currently one of the most popular programming languages in use, and is widely used from application software to web applications
• Java applications – are typically compiled to bytecode (class file) that can run on any Java Virtual Machine (JVM) regardless of computer architecture.
• Local Area Network (LAN) – a communications network that typically connects computers, terminals, and other computerized devices within a limited physical area such as an office, building, manufacturing plant and other work sites.
• Microsoft .NET Framework – is a software framework that can be installed on computers running Microsoft Windows operating systems. It includes a large library of coded solutions to common programming problems and a common language infrastructure that manages the execution of programs written specifically for the framework. The .NET Framework supports multiple programming languages in a manner that allows language interoperability, whereby each language can utilize code written in other languages; in particular, the .NET library is available to all the programming languages that .NET encompasses.
• Microsoft SQL Server – is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI SQL
• Object code – or an object file, is the representation of code that a compiler or assembler generates by processing a source code file. Object files contain compact code, often called “binaries”. A linker is typically used to generate an executable or library by linking object files together. The only essential element in an object file is machine code (code directly executed by a computer’s CPU). Object files for embedded systems might contain nothing but machine code. However, object files often also contain data for use by the code at runtime, relocation information, program symbols (names of variables and functions) for linking and/or debugging purposes, and other debugging information.
• Oracle Forms – is a software product for creating screens that interact with an Oracle database. It has a typical IDE including an object navigator, property sheet and code editor that uses PL/SQL. It was originally developed to run server-side in character mode terminal sessions. It was ported to other platforms, including Windows, to function in a client–server environment. Later versions were ported to Java where it runs in a Java EE container and can integrate with Java and web services. The primary focus of Forms is to create data entry systems that access an Oracle database.
• Oracle Reports – is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer (a component of the Oracle Developer Suite) and Oracle Application Server Reports Services (a component of the Oracle Application Server).
• Outsourcing – turning over all or part of an organization’s information systems operation to outside contractors, known as systems integrators or facilities management companies.
• Programming language – is an artificial language designed to express computations that can be performed by a machine, particularly a computer. Programming languages can be used to create programs that control the behavior of a machine, to express algorithms precisely, or as a mode of human communication.
• Program Evaluation and Review Technique (PERT) – a statistical tool used in project management, that is designed to analyze and represent the tasks involved in completing a given project.
• Quality Assurance – methods for ensuring that information systems are free from errors and fraud and provide information products of high quality.
• Relational database management system (RDBMS) – is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the relational database model. A short definition of an RDBMS may be a DBMS in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.
• Service-oriented programming (SOP) – is a programming paradigm that uses “services” as the unit of computer work, to design and implement integrated business applications and mission critical software programs. Services can represent steps of business processes and thus one of the main applications of this paradigm is the cost effective delivery of standalone or composite business applications that can “integrate from the inside-out.”
• Software – computer programs and procedures concerned with the operation of an information system.
• Source code – is any collection of statements or declarations written in some human readable computer programming language. Source code is the means most often used by programmers to specify the actions to be performed by a computer.
• SQL, often referred to as Structured Query Language – is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon relational algebra. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
• Standards – measures of performance developed to evaluate the progress of a system toward its objectives
• System – an assembly of methods, procedures, or techniques unified by regulated interaction to form an organized whole
• User- friendly – a characteristic of human-operated equipment and systems that makes them safe, comfortable, and easy to use.
• User interface – is the system by which people (users) interact with a machine. The user interface includes hardware (physical) and software (logical) components. User interfaces exist for various systems, and provide a means of: 1) Input, allowing the users to manipulate a system, and/or 2) Output, allowing the system to indicate the effects of the users’ manipulation.
• VB.NET – is a redesigned, object-oriented dialect of Visual Basic.
• Web application – is an application that is accessed over a network such as the Internet or an intranet. The term may also mean a computer software application that is hosted in a browser-controlled environment (e.g. a Java applet) or coded in a browser-supported language (such as JavaScript, combined with a browser-rendered markup language like HTML) and reliant on a common web browser to render the application executable.
• Windows Forms – is the name given to the graphical application programming interface (API) included as a part of Microsoft’s .NET Framework, providing access to the native Microsoft Windows interface elements by wrapping the existing Windows API in managed code. While it is seen as a replacement for the earlier and more complex C++ based Microsoft Foundation Class Library, it does not offer a paradigm comparable to model–view–controller.
• Windows Forms application – is an event-driven application supported by Microsoft’s .NET Framework. Unlike a batch program, it spends most of its time simply waiting for the user to do something, such as fill in a text box or click a button.