Use SQL to create queries to meet user Database Design - Section 16 requirements Lesson 1: Anatomy of a SQL Statement Sorting, updating and deleting data Database Programming with SQL - Section 5 records to meet user requirements Lesson 1 Using GROUP BY and HAVING Clauses – Incorporate calculations within queries Database Programming with SQL - Section 6 Lesson 1 Fundamentals of Subqueries – one table in a select statement Lesson 2 - Single-Row Subqueries Lesson 3 - Multiple-Row Subqueries Lesson 2 - Correlated Subqueries Create queries that more than ‘join’ Produce formatted query responses 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
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
Credit_Transfer_Arrangements_DB_SQL.docx