Oracle Datenbank 11g: PL/SQL und Datenbankprogrammierung

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 PLSQL 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.

Vorkenntnisse erforderlich

• D49988 Oracle Datenbank 11g: Professioneller Einstieg in Oracle SQL

Kursbeschreibung

Sachgebiete

• 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

Teilnehmerkreis

• System Analysts
• PL/SQL Developer
• Forms Developer
• Application Developers
• Database Administrators
• Technical Consultant
• Portal Developer
• Developer

Kategorie

Oracle Grundlagen und Sprachen

Sprache Unterlagen

English