An introduction to the design and creation of relational databases. Topics include storing, retrieving, updating and displaying data using Structured Query Language (SQL) integrated into Stored Procedures, Functions, Packages and Triggers (PL/SQL Programming)
This course is designed to teach students how to create programmed solutions using the PL/SQL procedural language.
As each student is required to have a working knowledge of the programming process and understanding of the functional constructs in programming, the focus of this course is on database problems and potential solutions.
DML – SELECT, INSERT, UPDATE, DELETE
DDL – CREATE, DROP, GRANT, ALTER
Transaction – COMMIT, ROLLBACK, SAVEPOINT
PL/SQL Concepts and Constructs
DECLARE, BEGIN, EXCEPTION, END
Procedures, Functions, Packages and Triggers
Input and Output Parameters and Return values
PL/SQL Code Implementations
Variables and Constants
Attributes (Char, Varchar2, Number, Binary, Integer, Date)
IF – THEN – ELSIF – ELSE
Simple (EXIT WHEN)
TYPES - %TYPE, &ROWTYPE, RECORD
Our course materials include more than a simple slideshow presentation handout. Each student will receive a comprehensive course Student Guide, complete with detailed course notes, code samples, software tutorials, diagrams and related reference materials and links.