Grade 12 Computer Programming (Oracle Database)

Content standard

The learners demonstrate an understanding of concepts and components of database management systems and use of SQL basic syntax for data manipulation.

Performance standard

The learners execute basic SQL syntax for data manipulation.

Learning competencies (6)

• CPORCL-G12-Q1-01

  Discuss fundamental concepts and components of Oracle Database system

• CPORCL-G12-Q1-02

  Discuss installation procedure of IDE for Oracle Database

• CPORCL-G12-Q1-03

  Construct basic SQL syntax

• CPORCL-G12-Q1-04

  Apply LIMIT rows syntax retrieved by a query

• CPORCL-G12-Q1-05

  Apply SORT rows syntax retrieved by a query

• CPORCL-G12-Q1-06

  Apply single row functions

Content standard

The learners demonstrate an understanding of multiple row functions, joins, subqueries, and substitution variables to retrieve and display data from multiple tables.

Performance standard

The learners create a database applying multiple row functions, joins, subqueries, and substitution variables to retrieve and display data from multiple tables.

Learning competencies (4)

• CPORCL-G12-Q2-01

  Apply multiple row functions

• CPORCL-G12-Q2-02

  Apply JOIN syntax in retrieving and displaying from multiple tables

• CPORCL-G12-Q2-03

  Apply subqueries for complex data retrieval and manipulation

• CPORCL-G12-Q2-04

  Apply substitution variables in SQL

Content standard

The learners demonstrate an understanding of Data Manipulation Language (DML) commands in creating and managing database using constraints, views, database objects, managing user access roles and set operators to combine query results.

Performance standard

The learners apply DML commands in creating and managing database using constraints, views, database objects, managing user access roles and set operators to combine query results.

Learning competencies (8)

• CPORCL-G12-Q3-01

  Apply DML commands in manipulating data for table attributes

• CPORCL-G12-Q3-02

  Create tables for managing data

• CPORCL-G12-Q3-03

  Apply constraint commands for data validation

• CPORCL-G12-Q3-04

  Apply VIEW syntax in accessing specific data

• CPORCL-G12-Q3-05

  Apply database object functions for storing or referencing data

• CPORCL-G12-Q3-06

  Apply database control in managing user access

• CPORCL-G12-Q3-07

  Apply SET operators in data manipulation

• CPORCL-G12-Q3-08

  Execute GROUP BY clause commands for data manipulation

Content standard

The learners demonstrate an understanding in connecting programming language (PL) to a SQL database, effectively performing Create, Read, Update and Delete (CRUD) operations.

Performance standard

The learners create an application by connecting programming language (PL) to a SQL database, effectively performing Create, Read, Update and Delete (CRUD) operations.

Learning competencies (7)

• CPORCL-G12-Q4-01

  Perform connection of PL to SQL for program application

• CPORCL-G12-Q4-02

  Apply SQL syntax to programming .net or Java for storing or retrieval of data

• CPORCL-G12-Q4-03

  Evaluate bugs using exception handling in programming .net or Java for debugging process

• CPORCL-G12-Q4-04

  Apply store procedures on PL/SQL

• CPORCL-G12-Q4-05

  Create the PL/SQL code framework

• CPORCL-G12-Q4-06

  Apply the advanced interface methods on PL/SQL framework

• CPORCL-G12-Q4-07

  Apply performance and tuning using PL/SQL code