SQL Programming Language

Code: SQLPL

Description

-

Audience

-

Prerequisites

It is assumed that participants are proficient in both Basic SQL and a programming language. It is also assumed that the participants are at least somewhat familiar with the ACS tools for the database.

Objectives

-

Topics

SQL PL – Programming Language

  • Set Option Statement
  • Declaring Variables and Constants
  • Assignment Statement: SET
  • Condition Statements: IF/CASE
  • Loop Statements: LOOP / WHILE / REPEAT / FOR
  • Static and Dynamic SQL
  • Single Row Access
    • SELECT ... INTO / Values Into
  • Cursor Handling
    • Serial and Scroll Cursors
    • Update through Cursors
  • Error Handling
    • Continue/Exit/Undo Handler

ACS Integrated Debugger

Stored Procedures

  • External and SQL Stored Procedures
    • Calling Stored Procedurs (incl. Argument list)
  • Parameters
    • Parameter Styles
    • Optional Parameters (with Default Values)
  • Returning and Consuming Result Sets

User Defined Functions

  • External and SQL Scalar Functions
  • External and SQL Table Functions

Trigger

  • External and SQL-Trigger
  • Trigger Event and Trigger Time
  • Conditioned Triggers and Trigger on Field Level
  • Instead Of Trigger

Price (ex. VAT)

€ 3.040,00 per person

Duration

3 or 4 days

Schedule

Please send us a message with the form below

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)

Questions?

Write us and we will contact you to discuss your requirements
contact us