Understanding and using Oracle PL/SQL programming language

Understanding and using Oracle PL/SQL programming language

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 

Writing programs to interact and manipulate Oracle databases using PL/SQL programming language

Url: View Details

What you will learn

• Understand the sections of the PL/SQL language
• Be able to write simple PL/SQL programs
• Ability to write PL/SQL functions and procedures

Rating: 3.5

Level: All Levels

Duration: 2 hours

Instructor: John Boyle