Semester 1 Mid Term Exam Semester 1 Mid Term Exam Part I Semester 1 Mid Term Exam Part II Database Programming with PL/SQL - Section 7 Lesson 1 Handling Exceptions – Lesson 2 Trapping Oracle Server Exceptions – Lesson 3 Trapping User-Defined Exceptions – Lesson 4 Recognizing the Scope of Exceptions – Appendix 9 Centre Advice Software Development: Programming in PL/SQL F4TJ 35 – Outcome 3 Introduction to Computer Science and Business Handling Exceptions, Oracle Server Database Programming with PL/SQL - Section 7 Exceptions, User-Defined Exceptions Lesson 1 Handling Exceptions – Creating Procedures in PL/SQL Lesson 2 Trapping Oracle Server Exceptions – Lesson 3 Trapping User-Defined Exceptions – Using Parameters, Passing Lesson 4 Recognizing the Scope of Exceptions – Parameters in PL/SQL Database Programming with PL/SQL - Section 8 Creating and Functions in PL/SQL Lesson 1 Creating Procedures – Lesson 2 Using Parameters in Procedures – Using the Data Dictionary Lesson 3 Passing Parameters – Managing Procedures and Functions in PL/SQL Database Programming with PL/SQL - Section 9 Understanding Object Privileges in Lesson 1 Creating Functions – PL/SQL Lesson 2 Functions in SQL Statements – Lesson 3 Review of the Data Dictionary – Understanding User Rights in PL/SQL Lesson 4 - Managing Procedures and Functions Lesson 5 Review of Object Privileges – Lesson 6 Using Invoker’s Rights and Autonomous – Transactions First Semester Project Enhancement Semester Student Project Enhancement Semester 1 Exam Semester 1 Final Exam Part I
Semester 1 Mid Term Exam Semester 1 Mid Term Exam Part I Semester 1 Mid Term Exam Part II Database Programming with PL/SQL - Section 7 Lesson 1 – Handling Exceptions Lesson 2 – Trapping Oracle Server Exceptions Lesson 3 – Trapping User-Defined Exceptions Lesson 4 – Recognizing the Scope of Exceptions Appendix 9 Centre Advice – Software Development: Programming in PL/SQL F4TJ 35 Outcome 3 Introduction to Computer Science and Business Handling Exceptions, Oracle Server Exceptions, User-Defined Exceptions Creating Procedures in PL/SQL Using Parameters, Passing Parameters in PL/SQL Creating and Functions in PL/SQL Using the Data Dictionary Managing Procedures and Functions in PL/SQL Understanding Object Privileges in PL/SQL Understanding User Rights in PL/SQL Database Programming with PL/SQL - Section 7 Lesson 1 – Handling Exceptions Lesson 2 – Trapping Oracle Server Exceptions Lesson 3 – Trapping User-Defined Exceptions Lesson 4 – Recognizing the Scope of Exceptions Database Programming with PL/SQL - Section 8 Lesson 1 – Creating Procedures Lesson 2 – Using Parameters in Procedures Lesson 3 – Passing Parameters Database Programming with PL/SQL - Section 9 Lesson 1 – Creating Functions Lesson 2 – Functions in SQL Statements Lesson 3 – Review of the Data Dictionary Lesson 4 - Managing Procedures and Functions Lesson 5 – Review of Object Privileges Lesson 6 – Using Invoker’s Rights and Autonomous Transactions First Semester Project Enhancement Semester Student Project Enhancement Semester 1 Exam Semester 1 Final Exam Part I