Unit Title SQA Ref. No. Credit Value SCQF SQL: Introduction DH3J 34 1 7 Software Development: Relational Database Management Systems H16W 35 2 8 Software Development: Programming in PL/SQL F4TJ 35 2 8 Professional Development Awards The HNC/D Computing contains a number of vendor qualifications including one linked to Oracle: Advanced Certificate in Database Programming. This award corresponds to Introduction to Computer Science. Upon completion advanced students will also be eligible to sit part one of the Oracle Certified Associate examination. Advanced students who elect the optional unit Software Development: Programming in PL/SQL F4TJ 35 will also be eligible to sit part two of the Oracle Certified Associate examination PDA Advanced Certificate in Database Programming G7WN 17 Candidates are required to take both mandatory units and one optional unit to achieve the PDA. Mandatory (3 Credits Required) Unit Title SQA Ref. No. Credit Value SCQF SQL: Introduction DH3J 34 1 7 Software Development: Relational Database Management Systems DH3D 35 2 8 Optional (2 Credits Required) Unit SQA Ref. No. Credit SCQF Software Development: Applications Development D76N 34 2 7 Software Development: Object Oriented Programming H171 35 2 8 Software Development: Programming in PL/SQL F4TJ 35 2 8 Appendix 1 Advice to Centres – Credit Transfer Arrangements The existing credit transfer arrangements are summarised in the table below and refers to the first course in the portfolio – Introduction to Computer Science and Business. Oracle SQA SQA Unit Code Unit Titles & SCQF Level/Points Database Design & Database Programming with SQL DM4K 12 (1 Credit) Relational Database Systems (SCQF 6 – 6 SCQF Credit Points)
♦ create both primary and foreign keys ♦ use appropriate integrity constraints dependant on design rules Lesson 2: Using Data Types Database Programming with SQL - Section 10 Lesson 2: PRIMARY KEY, FOREIGN KEY, and CHECK Constraints Database Programming with SQL - Section 10 Lesson 1: Defining NOT NULL and UNIQUE Constraints Populate Data: ♦ insert ♦ delete ♦ update data sufficient for testing purposes. Database Programming with SQL - Section 7 Lesson 1: Insert Statements Database Programming with SQL - Section 7 Lesson 2: Updating Column Values and Deleting Rows Database Programming with SQL - Section 7 Lesson 2: Updating Column Values and Deleting Rows Outcome 4 - Create and run queries on a RDBMS Introduction to Computer Science and Business SQL Examples: ♦ retrieving all columns and rows ♦ retrieving specific columns ♦ specifying a column alias ♦ using arithmetic operators ♦ using functions Database Design - Section 15 Lesson 1: Anatomy of a SQL Statement Database Programming with SQL - Section 1 Lesson 1: Case and Character Manipulation Database Design - Section 12 Lesson 2: SQL Introduction: Querying the Database Database Design - Section 16 Lesson 1: Working with Columns, Characters, and Rows Database Programming with SQL - Section 1 Lesson 1: Case and Character Manipulation Database Design - Section 16 Lesson 3: Comparison Operators Database Design - Section 17 Lesson 3: Introduction to Functions – Single Row Functions Database Programming with SQL - Section 1 Lesson 1: Case and Character Manipulation Lesson 2: Number Functions Lesson 3: Date Functions Database Programming with SQL - Section 2 Lesson 1: Conversion Functions Lesson 2: NULL Functions Outcome 4 - Create and run queries on a RDBMS Introduction to Computer Science and Business ♦ working with ♦ retrieving specific rows from tables ♦ applying functions to groups Database Programming with SQL - Section 2 Lesson 2: NULL Functions Database Design - Section 16 Lesson 2: Limit Rows Selected Database Programming with SQL - Section 5
Creating and dropping data tables in a RDBMS Database Programming with SQL - Section 8 Lesson 1 - Creating Tables Lesson 2 - Using Data Types Inserting data records into data tables Database Programming with SQL - Section 7 Lesson 1 - INSERT Statements Lesson 2 - Updating Column Values and Deleting Rows Modifying the structures of data tables Assigning primary keys to tables Database Programming with SQL - Section 8 Lesson 3 - Modifying a Database Programming with SQL - Section 10 Lesson 1 - Defining NOT NULL and UNIQUE Constraints Lesson 2 - PRIMARY KEY, FOREIGN KEY, and CHECK Constraints Lesson 3 - Managing Constraints Appendix 5 Centre Advice – Mapping Detail to SQL: Introduction DH3J 34 Outcome 2 Introduction to Computer Science and Business Using SQL to create queries to meet user requirements Database Design - Section 15 Lesson 1: Anatomy of a SQL Statement Extracting data records to meet user requirements Establishing relationships between multiple tables Sorting, updating and deleting data records as per user requirements Extracting columns and rows as per user requirements Using calculations to meet user requirements Applying functions and as per user requirements Formatting column headings to meet user requirements Database Programming with SQL - Section 5 Lesson 1: Using GROUP BY and HAVING Clauses Database Programming with SQL - Section 6 Lesson 1 – Fundamentals of Subqueries Lesson 2 - Single-Row Subqueries Lesson 3 - Multiple-Row Subqueries Lesson 2 - Correlated Subqueries Database Programming with SQL - Section 1 Lesson 1 - Case and Character Manipulation Lesson 2 - Number Functions Lesson 3 - Date Functions Database Programming with SQL - Section 2 Lesson 1 - Conversion Functions Lesson 2 – Number Functions Lesson 3 – Date Functions Database Programming with SQL – Mid Term Exam Mid Term Exam Semester 2 - Part I Mid Term Exam Semester 2 - Part II Database Programming with SQL – Final Exam Final Exam Semester 2 - Part I Final Exam Semester 2 - Part II Outcome 3 Introduction to Computer Science and Business
Use SQL to create queries to meet user requirements Sorting, updating and deleting data records to meet user requirements Incorporate calculations within queries one table in a select statement Create queries that ‘join’ more than Produce formatted query responses Database Design - Section 16 Lesson 1: Anatomy of a SQL Statement Database Programming with SQL - Section 5 Lesson 1 – Using GROUP BY and HAVING Clauses Database Programming with SQL - Section 6 Lesson 1 – Fundamentals of Subqueries Lesson 2 - Single-Row Subqueries Lesson 3 - Multiple-Row Subqueries Lesson 2 - Correlated Subqueries Database Programming with SQL - Section 1 Lesson 1 - Case and Character Manipulation Lesson 2 - Number Functions Lesson 3 - Date Functions Database Programming with SQL - Section 2 Lesson 1 - Conversion Functions Lesson 2 - NULL Functions Lesson 3 - Conditional Expressions Database Programming with SQL – Mid Term Exam Mid Term Exam Semester 2 - Part I Mid Term Exam Semester 2 - Part II Database Programming with SQL – Final Exam Final Exam Semester 2 - Part I Final Exam Semester 2 - Part II Appendix 9 Centre Advice – Software Development: Programming in PL/SQL F4TJ 35 Unit title: Software Development: Programming in PL/SQL Unit code: F4TJ 35 Credit points and level: 2 HN credits at SCQF level 8 Unit purpose: This Unit is designed to develop a broad knowledge of the concepts, principles, boundaries and scope of software development in a database programming environment using PL/SQL. These will be reinforced by developing practical skills using the structures and features of PL/SQL in the creation of solutions to problems. It forms part of an HN Computing Group Award programme, although it can also be used as a stand-alone Unit by candidates wishing to acquire and develop programming skills using a database programming language. On completion of the Unit the candidate should be able to: 1 Understand and implement Variables, Datatypes and Advanced Datatypes within PL/SQL program blocks 2 Understand Program Structure, Cursors and Exceptions Handling in PL/SQL 3 Create procedures and functions in PL/SQL