> > > ORPLSQL

Oracle PL/SQL Fundamentals (ORPLSQL)

Course Description Schedule Course Outline
 

Course Overview

This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This trainng will also lay the foundation for the Oracle PL/SQL programming language, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The focus of the second part of this training will be on the use of database-resident stored program units such as procedures, functions, packages and database triggers. New features introduced with the Oracle 12c release of the database are also explained and demonstrated.

PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.

Who should attend

The target audience is all Oracle professionals. Among the specific groups for whom this course will be helpful are:

  • Application designers and database developers
  • Database administrators
  • Web server administrators

Course Objectives

This trainng begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language.

In a production environment most PL/SQL program units should be packaged, and these advanced database programming capabilities along with the benefits of using these are discussed. It concludes with extensive demonstrations on how a particular type of database-resident program unit known as a database trigger can be used as part of an advanced database application design.

Course Content

  • Selection & Setup Of The Database Interface
  • About BIND & SUBSTITUTION Variables
  • Choosing A Database Programming Language
  • PL/SQL Language Fundamentals
  • DECLARE Section
  • BEGIN Section
  • Exception Section
  • Beyond The Basics: Explicit Cursors
  • Beyond The Basics: Nested Blocks
  • Beyond The Basics: DECLARED Subprograms
  • Introducing Database-Resident Program Units
  • Creating Stored Procedures & Functions
  • Executing Stored Procedures & Functions
  • Maintaining Stored Program Units
  • Managing Dependencies
  • Creating & Maintaining Packages
  • Advanced Package Capabilities
  • Advanced Cursor Techniques
  • Using System-Supplied Packages
  • Database Trigger Concepts
  • Creating Database Triggers
  • Maintaining Database Triggers
  • Implementing System Event Triggers
Classroom Training
Modality: C

Duration 5 days

Price (excl. tax)
  • Germany: 2,500.- €
  • Switzerland: Fr. 2,900.-
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


Dates and Booking
 
Click on town name to book Schedule
This is a FLEX course, which is delivered both virtually and in the classroom.
Germany

Currently no local training dates available.  For enquiries please write to info@flane.de.

FLEX Training

Please see below our alternative, English language, FLEX course options.

07/01/2019 - 11/01/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Bratislava
18/03/2019 - 22/03/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
25/03/2019 - 29/03/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Budapest
08/07/2019 - 12/07/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
09/09/2019 - 13/09/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Prague
21/10/2019 - 25/10/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
11/11/2019 - 15/11/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Bucharest
Switzerland
04/02/2019 - 08/02/2019 Zurich
13/05/2019 - 17/05/2019 Zurich
05/08/2019 - 09/08/2019 Zurich
04/11/2019 - 08/11/2019 Zurich

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.

Europe
Czech Republic
09/09/2019 - 13/09/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Prague
Hungary
25/03/2019 - 29/03/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Budapest
Italy
28/01/2019 - 01/02/2019 Milan
15/04/2019 - 19/04/2019 Rome
15/07/2019 - 19/07/2019 Milan
14/10/2019 - 18/10/2019 Rome
Romania
11/11/2019 - 15/11/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Bucharest
Slovakia
07/01/2019 - 11/01/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/Bratislava
United Kingdom
18/03/2019 - 22/03/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
08/07/2019 - 12/07/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
21/10/2019 - 25/10/2019 FLEX training This is an English language FLEX course.
Time zone: Europe/London
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!