Programming with PL/SQL

4.5
2 reviews
  • Awesome trainer and course. The examples given were totally useful. Good value for money.
    |
  • Amazing course delivered by a professional trainer.
    |

Course

In Manchester and London

£ 650 + VAT

Description

  • Duration

    2 Days

This course will give you an introduction to Oracle Corporation's proprietary procedural extension to the SQL database language, PL/SQL. PL/SQL (Procedural Language/Structured Query Language) is embedded in the Oracle Database, and allows the creation of powerful programming blocks - procedures and functions - which interact with SQL to dramatically increase the functionality of your Oracle database. Suitable for: A basic level of SQL knowledge, and some understanding of relational database (RDBMS) concepts is assumed. For students who do not have experience in these areas the Introduction to SQL class is recommended.

Facilities

Location

Start date

London
See map
164-180 Union Street, Waterloo, SE1 0LH

Start date

On request
Manchester (Cheshire)
See map

Start date

On request

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.5
  • Awesome trainer and course. The examples given were totally useful. Good value for money.
    |
  • Amazing course delivered by a professional trainer.
    |
100%
4.7
excellent

Course rating

Recommended

Centre rating

Peter Warren

4.5
18/11/2015
What I would highlight: Awesome trainer and course. The examples given were totally useful. Good value for money.
Would you recommend this course?: Yes

Former Student

4.5
18/02/2015
What I would highlight: Amazing course delivered by a professional trainer.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • Database
  • SQL
  • PL/SQL
  • Database training
  • Programming
  • SQL Database
  • Programming Application
  • Programming with PL/SQL
  • IT
  • IT Development

Teachers and trainers (1)

Dean Bullen

Dean Bullen

Development course leader

Dean has been working with databases since 1998, and in web development since 2005. He worked at Oracle for 8 years and has extensive knowledge of SQL, PL/SQL. T-SQL as well as the .NET framework, VB and C#.

Course programme

This course will give you an introduction to Oracle Corporation’s proprietary procedural extension to the SQL database language, PL/SQL. PL/SQL (Procedural Language/Structured Query Language) is embedded in the Oracle Database, and allows the creation of powerful programming blocks - procedures and functions - which interact with SQL to dramatically increase the functionality of your Oracle database.

Introduction to PL/SQL

  • Relation between SQL and PL/SQL
  • Advantages of PL/SQL
  • A Simple PL/SQL Block
  • Declaration using attributes
  • Loop Statements
  • Displaying the user messages on screen

Cursors and Error Handling

  • Cursors
  • Using the Explicit Cursors
  • Explicit Cursor Attributes
  • Implicit Cursor Attributes
  • Example of an Explicit Cursor and Attribute
  • Error handling in PL/SQL
  • Stored Procedures, Functions and Packages

Stored Procedures

  • Stored Procedures
  • How Oracle creates a Procedure?
  • Advantages of Procedures
  • Deleting the Procedure

Functions

  • Stored Functions
  • How Oracle creates a Function?
  • Advantages of Functions
  • Creating a Function
  • Deleting a Function

Triggers

  • Use of Database Triggers
  • Applying a Database Trigger
  • Types of Triggers
  • Before Vs After Triggers
  • Creating a Trigger
  • Deleting a Trigger

Programming with PL/SQL

£ 650 + VAT