This course will give and overview of the Oracle PL/SQL programming language.
This course is a must have for anyone considering learning more about databases and database management
Whether as a DBA or Database application developer, PL/SQL is foundations to understanding how Oracle works and how to change data within the database.
We cover all the fundamental aspects of the language and use real world example to manipulate databases.
Topic covered Include:
- Explanation of PL/SQL
- Language Syntax, Sections, Operators, Assignments and Variables
- Using PL/SQL to automatically do updates, inserts and deletion of records of an Oracle Database
- PL/SQL Cursors - to bring in large data sets to work with
- PL/SQL Loops - to loop through tables of data
- PL/SQL Exceptions - to trap and handle coding exceptions both user and machine generated
- PL/SQL Triggers - to have the table automatically change data based on the other data
- PL/SQL Functions - to return a frequently used value and avoid duplicate coding
- PL/SQL Procedures - to get anonymous blocks into reusable coding procedures
- PL/SQL Packages - to put PL/SQL objects together to quicker retrieval