Programming with PL/SQL
-
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
Description
-
Type
Course
-
Location
-
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
Start date
Start date
Start date
Reviews
-
Awesome trainer and course. The examples given were totally useful. Good value for money.
← | →
-
Amazing course delivered by a professional trainer.
← | →
Course rating
Recommended
Centre rating
Peter Warren
Former Student
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
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