Who will the Course Benefit? Who will the Course Benefit?
Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts to enhance their productivity in manipulating data.
The delegate will learn and acquire skills as follows:
Writing and running PL/SQL programs from SQL*Plus or SQL Developer
Assigning and manipulating values
Using SQL statements within PL/SQL
Implementing conditional execution and loop constructs
Updating data with cursors
Trapping and handling errors and exceptions in code
Implementing nested and labelled loops and blocks
Handling PL/SQL records and tables
Using PL/SQL table built-in functions
Using PL/SQL table built-in functions Course Objectives Course Objectives
To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.
A working knowledge of SQL*Plus or SQL Developer and Oracle SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite course. Some previous programming experience will also prove advantageous.
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.