Cel kursu:
This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.
Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.
Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

Metoda szkolenia:
Kurs ma formę wykładów połączonych z ćwiczeniami praktycznymi i jest prowadzony przez instruktora.

Oczekiwane umiejętności słuchaczy:
Previous programming experience
Knowledge of SQL

Lista tematów:

• Introduction
• Introduction to PL/SQL
• Declaring PL/SQL Identifiers
• Writing Executable Statements
• Interacting with the Oracle Server
• Writing Control Structures
• Working with Composite Data Types
• Using Explicit Cursors
• Handling Exceptions
• Creating Stored Procedures
• Creating Stored Functions
• Creating Packages
• Working With Packages
• Using Oracle-Supplied Packages in Application Development
• Using Dynamic SQL
• Design Considerations for PL/SQL Code
• Creating Triggers
• Creating Compound, DDL, and Event Database Triggers
• Using the PL/SQL Compiler
• Managing PL/SQL Code
• Managing Dependencies

Materiały szkoleniowe:
Uczestnik szkolenia otrzymuje autoryzowany podręcznik.

Szkolenia poprzedzające:
Oracle Database 11g: SQL Fundamentals I
Oracle Database 11g: SQL Fundamentals II
Oracle Database 11g: Introduction to SQL

Szkolenia następujące:
Oracle Database 11g: Advanced PL/SQL
Oracle Database 11g: Develop PL/SQL Program Units
Oracle Database 11g: Oracle Spatial: Essentials