Fairmont Heights High – Database Programming with PL/SQL and Database Project

Mar 2026 · 2nd Semester

This course covers PL/SQL, a procedural language extension to SQL. Through an innovative project-based approach, students learn procedural logic constructs such as variables, constants, conditional statements, and iterative controls. The Database Programming with PL/SQL course introduces students to the PL/SQL programming language. In this course, students learn how to write PL/SQL code. Students learn to develop stored procedures, functions and packages, and they extend their knowledge of PL/SQL by learning more advanced topics such as creating database triggers, manipulating large objects, and managing dependencies. Students will work on a project to build a web-based application using Oracle APEX platform - including user login, registration, reports, form and shopping cart.