Oracle Database PL/SQL Programming Training

Catalogue index: IFS/38

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • Średniozaawansowany
  • Type of training:
    • stacjonarnie; online
PLN1,526.67 net / particip. PLN22,900.05  net for 1 workshop PLN1,877.80 gross incl. 23% VAT / particip.

product- line 1

Features

Features
Certification:
  • TAK
Dedicated training:
Number of training hours:
  • 21
Producer:
Training language:
  • polski
Training level:
  • Średniozaawansowany
Type of training:
  • stacjonarnie; online

Description

Company Description

Infoshare is the largest tech community in CEE and the organizer of the leading tech conference in Gdańsk. It connects startups, investors, corporations, and innovation enthusiasts. It promotes entrepreneurship, knowledge sharing, and networking. Through events, competitions, and programs, it supports the development of the tech ecosystem in Poland and the region.

Training Description

The training provides knowledge about programming in PL\SQL for Oracle databases based on the latest versions of this engine. Participants will learn to efficiently create programmable elements of this database, enabling them to automate and streamline their daily work with data.

Who is the training for
  • For programmers, DevOps, Data Analysts, Data Science, Administrators, Architects
Goals
Benefits
  • Programming in PL\SQL
  • Knowledge of loops, control statements, cursors
  • Creating functions, procedures, and packages
  • Knowledge of database elements such as: sequence, view, synonym, dictionary, temporary tables, constraints
Training Program

  1. INTRODUCTION TO PL\SQL PROGRAMMING
     • introduction to PL\SQL programming
     • executing an anonymous block

  2. EXECUTING AN ANONYMOUS BLOCK
     • declaring variables
     • standard and complex data types
     • attributes: %TYPE and %ROWTYPE

  3. CONTROLLING WORKFLOW
     • control statements
     • loops and labels
     • INTO clause – using SQL, exceptions, scope of availability

  4. CURSORS
     • explicit and implicit cursors
     • parameterized cursors
     • WHERE CURRENT OF and FOR UPDATE clauses

  5. FUNCTIONS, PROCEDURES, PACKAGES
     • stored procedures and functions
     • building packages and their dependencies
     • built-in packages

  6. REGULAR EXPRESSIONS
     • searching data

  7. WORKING WITH THE REPOSITORY
     • system dictionary
     • managing constraints
     • temporary tables
     • views and indexes
     • synonyms and sequences
     • database links
     • external tables

Duration

21 h/3 days

Price includes

Zamów szkolenie