About Training
DESCRIPTION
Duration: 20 h
Target: Audience Professionals who want to develop programs of units (PL / SQL blocks) for both database administration as to supply computer systems requirements.
Requirements: Database Concepts, Basic knowledge of SQL.
Course Objectives
• Know the PL / SQL block
• Understand the classical structures of programming in PL / SQL
◦ Decision sequential and repeat
• Create stored procedures
◦ functions, procedures, packages and triggers databases
| PL/SQL Language | Structures |
| PL/SQL blocks Setting Variables Conditional |
IF, THEN, ELSE Repeating Structures LOOP, WHILE, FOR GOTO statement Working with Labels |
| Manipulating PL/SQL Data | |
| Working with Sliders Implicit cursor Explicit cursor Cursor OPEN-FOR |
| Working with Functions | Working with Procedures |
| Creating, changing, and deleting | Criando, Alterando e Excluindo |
| Working with Packages | Working with Triggers |
| Creating, changing, and deleting Package Global Variables Functions and Procedues Public and Private |
Triggers Tables Events: Inclusion, alteration, exclusion Database Triggers Events: Startup, Shutdown |
| Handling Exceptions | |
| Exceptions Concepts handling Exceptions User-defined exceptions |
20H
Hire
