PL/SQL11g

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
02.fw20H

Hire

 SQL 11g PL/SQL 11g Management 11g Backup 11g Performance 11g

Our Clients