Software Development: Programming in PL/SQL (HT0G48)

Overview

Learn to analyze and understand the fundamental constructs of PL/SQL, including its procedural, functional, and object-oriented capabilities. Design, implement, and troubleshoot PL/SQL stored programs while demonstrating a clear understanding of SQL and PL/SQL interaction. Evaluate and effectively manage database transactions and handle exceptions in PL/SQL programming. Apply the acquired skills and knowledge to develop robust and scalable software applications, showing a keen awareness of best practices in software development.

Syllabus

Analyse and understand the fundamental constructs of PL/SQL, including its procedural, functional, and object-oriented capabilities.
Design, implement, and troubleshoot PL/SQL stored programs, demonstrating a clear understanding of SQL and PL/SQL interaction.
Evaluate and effectively manage database transactions and handle exceptions in PL/SQL.
Apply the learned skills and knowledge to develop robust and scalable software applications, showing a keen awareness of best practices in software development.