Software Development: Programming in PL/SQL (HT0G48)

Overview

Master AI & Machine Learning for 50% Off

Go under the hood of AI — neural networks, real-world applications & more. Designed by UNSW experts.

This course develops skills for designing, implementing, and troubleshooting PL/SQL stored programs. It covers PL/SQL constructs, SQL interaction, transaction management, exception handling, and software development best practices.

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.