Course
Oracle PL-SQL
Course Duration
2 Days
The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.
Private Courses
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
Prerequisites
-
- Prerequisite course : Oracle SQL
- 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.
Objectives
-
- To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.
Target Audience
-
- Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts to enhance their productivity in manipulating data.
Skills Gained
-
- Writing and running PL/SQL programs from SQL*Plus or SQL Developer
- Declaring and using variables and constants
- Assigning and manipulating values
- Using SQL statements within PL/SQL
- Implementing conditional execution and loop constructs
- Declaring and using cursors with and without parameters
- Updating data with cursors
- Trapping and handling errors and exceptions in code
- Implementing nested and labelled loops and blocks
- Raising exceptions
- Handling PL/SQL records and tables
- Using PL/SQL table built-in functions
What's included
-
- Comprehensive course materials and exercises
Course Content
-
DAY 1
-
Course IntroductionAdministration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions -
PL/SQL FUNDAMENTALSWhat is PL/SQL?
Basic Elements
Variables and Constants
Data Types
Initialising Variables and Assigning Values
Using SQL Statements in Code
Generating Output to SQL or SQL Developer -
PROGRAM LOGIc# #IF THEN ELSIF ELSE Statements
CASE Statements
The Basic Loop Construct
WHILE and FOR Loops
Nested and Labelled Loops
The GOTO Statement
The CONTINUE Statement -
USING CURSORSWhat is a Cursor?
Implicit and Explicit Cursors
Cursor Operations
Declaring, Opening and Closing Cursors
Fetching Rows
Status Checking
Using Cursors FOR UPDATE
The Cursor FOR Loop
Parameterised Cursors -
Day 2
-
EXCEPTIONS AND NESTED BLOCKSThe EXCEPTION Section
Types of Exception
Handling Named System-Raised Exceptions
Handling Un-named System-Raised Exceptions
User-Declared Exceptions and Application Errors
WHEN OTHERS THEN NULL
Nested and Labelled Blocks
Propagation of Exceptions
Scope of Variables and Cursors
Scope of Goto Statements -
PL/SQL RECORDS AND INDEX-BY TABLESDeclaring Record Types
Handling PL/SQL Records
Nested Records
Declaring PL/SQL Index-By Tables or Associative Arrays
PL/SQL Table Built-in Functions
Manipulating PL/SQL Tables or Associative Arrays -
NoteThe 2 Day Oracle PL/SQL course can be combined with the 3 Day Stored Program Units course, this is equivalent to attending the 5 Day Oracle Program with PL/SQL course.
Related Courses
Oracle SQL Fundamentals The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements and scripts. A wide range of SQL functions and data manipulation statements are introduced.
Oracle PL-SQL Stored Program Units The Oracle PL/SQL Stored Program Units course provides practical experience in developing and writing triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages.
Oracle SQL Advanced The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.
Your PL-SQL course can be delivered online or in-person. You can choose your learning path and delivery style. Learn in-person or online with our virtual classrooms. Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.
You can master PL-SQL, please contact us to book a place or request a quote.
-
Course Options
Please contact us to discuss options for this coursePublic ScheduledPublic ScheduledFixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!PrivatePrivateFlexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/26/2024 5:44:47 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/26/2024 5:44:47 AM