To wersja testowa nowego serwisu infoShare Academy — wyświetlane treści i oferta nie są wiążące ani kompletne

Data

Oracle Database – PL\SQL programming

This training provides knowledge about programming in the PL/SQL language for Oracle databases using the latest versions of the engine.

Ask about the program → See all
Who it's for

Ideal for teams that…

1 Developers
2 DevOps
3 Data Analysts
4 Data Scientists
5 Database Administrators
6 Architects
Outcomes after the program

Hands-on AI and data analytics workshops — built around your team's real cases.

✓

Programming in PL/SQL

✓

Understanding loops, control statements, and cursors

✓

Creating functions, procedures, and packages

✓

Familiarity with database elements such as sequences, views, synonyms, data dictionary, temporary tables, constraints

Program · 6 modules

What we actually do

M01
Introduction to PL/SQL Programming
  • · Introduction to PL/SQL programming
  • · Executing anonymous blocks
  • · Declaring variables
  • · Standard and complex data types
  • · Attributes: %TYPE and %ROWTYPE
M02
Flow Control
  • · Control statements
  • · Loops and labels
  • · INTO clause – using SQL, exceptions, scope of visibility
M03
Cursors
  • · Explicit and implicit cursors
  • · Parameterized cursors
  • · WHERE CURRENT OF and FOR UPDATE clauses
M04
Functions, Procedures, and Packages
  • · Stored procedures and functions
  • · Building packages and their dependencies
M05
Regular Expressions
  • · Searching data using regular expressions
M06
Working with the Repository
  • · System dictionary
  • · Managing constraints
  • · Temporary tables
  • · Views and indexes
  • · Synonyms and sequences
  • · Database links
  • · External tables
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

How we handle your data

We process your business data (name, work e-mail, phone number, company, job title) in order to handle your corporate training inquiry and prepare an offer. The data controller is infoShare Academy Sp. z o.o., Al. Grunwaldzka 472B, 80-309 Gdańsk. Providing the data is voluntary but necessary to receive a response. You have the right to access, rectify, erase or restrict the processing of your data and to object to it. Full information is available in our data processing notice.

Optional marketing consents

The controller of your personal data is infoShare Academy sp. z o.o. The rules for processing personal data are set out in the Privacy Policy and the Data Processing Notice.

Other programs for teams

See all →
Data

Active Directory

Hands-on AI and data analytics workshops — built around your team's real cases.

16h · 2 days →
Data

AI SQL Developer

Hands-on AI and data analytics workshops — built around your team's real cases.

24h · 3 days →
Data

Amazon Redshift - Introductory Training

Hands-on AI and data analytics workshops — built around your team's real cases.

16h · 2 days →