IT-Practice: Oracle Database 23c PL/SQL (Free - Developer Release)

Course PW42

  • Duration:
    • 5 days

Dates:

  • Implementation planned - places still available
  • Implementation - probability high - still places available
  • There are no more seats available. For many courses, it may still be possible to participate online, via virtual classroom.
  • Course times: As a rule, our seminars are held from 10:00 am to 5:00 pm on day 1 and from 9:00 am to 4:00 pm on the following days. Changes are possible. The concrete seminar times you will find in the binding order confirmation.
03.03.2025 - 07.03.2025 Virtual Classroom
  • 3180 EUR / Person
 German
05.05.2025 - 09.05.2025 Virtual Classroom
  • 3180 EUR / Person
 German
30.06.2025 - 04.07.2025 Virtual Classroom
  • 3180 EUR / Person
 German

Get to know PL/SQL. The course content includes procedures, functions, packages and triggers as well as concepts for their effective use.

This course teaches the basics and advantages of the PL/SQL programming language. Participants will learn how to create anonymous blocks and stored subroutines. Procedures, functions, packages and triggers are developed and stored in the database for use in applications. The management of these objects, considerations for the design of PL/SQL code and necessary privileges round off the course.
The Oracle SQL Developer is used as a development tool in the course, SQL*Plus can be used optionally.
Get to know the new SQL features of Oracle 23c (Free - Developer Release).

  • Getting started with PL/SQL
  • PL/SQL basics
  • SQL in PL/SQL blocks
  • Using conditions
  • Using loops
  • Handling errors
  • Compound data types
  • Cursors
  • Procedures and functions
  • Debugger
  • Package specification
  • Package Body
  • Oracle Packages
  • Dynamic SQL
  • Trigger
  • Data Security
  • performance
  • PL/SQL Developer
  • Forms developers
  • Database administrators
  • system analysts
  • Data processing
  • Familiarity with data processing concepts and techniques
  • Oracle SQL practical workshop

This seminar is organised in cooperation with Robotron Datenbank-Software GmbH Dresden.

For classroom courses, the price quoted includes lunch in Robotron's in-house canteen.

For our online offers we use

  • Zoom for the presentation of the course content and
  • Citrix for the training environments

environments. In in-house courses, Zoom can be replaced by other software solutions.

Seminar times: 1st day 10.00 - 17.00, following days 09.00 - 17.00

Contact us

SoftwareONE

IT CAMPUS
Customer Training Solutions

Blochstraße 1
D-04329 Leipzig
*The services of SoftwareONE Deutschland GmbH directly serving school and educational purposes are predominantly VAT-exempt according to § 4 No. 21 a) bb) UStG. Contact us - we are happy to help!