Ideal for teams that…
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
What we actually do
- · Introduction to PL/SQL programming
- · Executing anonymous blocks
- · Declaring variables
- · Standard and complex data types
- · Attributes: %TYPE and %ROWTYPE
- · Control statements
- · Loops and labels
- · INTO clause – using SQL, exceptions, scope of visibility
- · Explicit and implicit cursors
- · Parameterized cursors
- · WHERE CURRENT OF and FOR UPDATE clauses
- · Stored procedures and functions
- · Building packages and their dependencies
- · Searching data using regular expressions
- · System dictionary
- · Managing constraints
- · Temporary tables
- · Views and indexes
- · Synonyms and sequences
- · Database links
- · External tables
From brief to retro in 30 days.
Brief & diagnosis
A call with the team lead + a short survey for participants. We define goals, gap and context.
Program customization
We adapt modules, case studies and code examples to your stack. Approval in 5 days.
Workshop
Trainer-led sessions, hands-on, code review. Mentor available between sessions too.
Retro + report
Outcome report for the team and lead. 30 days of consulting included.
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.
Thank you!
We'll get back to you within 1 business day.
Other programs for teams
See all →Active Directory
Hands-on AI and data analytics workshops — built around your team's real cases.
AI SQL Developer
Hands-on AI and data analytics workshops — built around your team's real cases.
Amazon Redshift - Introductory Training
Hands-on AI and data analytics workshops — built around your team's real cases.