Oracle Database 11g: PL/SQL Fundamentals

Seminar

Inhouse

1.180 € zzgl. MwSt.

Beschreibung

  • Kursart

    Seminar

  • Niveau

    Anfänger

  • Methodik

    Inhouse

  • Dauer

    2 Tage

Dieser Kurs vermittelt folgende Kenntnisse und Fähigkeiten: - Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors). - Handle runtime errors. - Describe stored procedures and functions. - Use cursors to process rows. - Design PL/SQL anonymous block that execute efficiently. - Describe the features and s.. Gerichtet an: PL/SQL-Entwickler. Systemanalytiker. Technischer Berater. Formsentwickler.

Hinweise zu diesem Kurs

Um diesen Kurs erfolgreich absolvieren zu können, sollten Sie über folgende Vorkenntnisse verfügen:

- Oracle Database 11g: Introduction to SQL (combination of Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II)

- Oracle Database 11g: SQL Fundamentals II

- Oracle Database 11g: SQL Fundamentals I

Fragen & Antworten

Ihre Frage hinzufügen

Unsere Berater und andere Nutzer werden Ihnen antworten können

Wer möchten Sie Ihre Frage beantworten?

Geben Sie Ihre Kontaktdaten ein, um eine Antwort zu erhalten

Es werden nur Ihr Name und Ihre Frage veröffentlicht.

Meinungen

Inhalte

Trainingsziel

Dieser Kurs vermittelt folgende Kenntnisse und Fähigkeiten:

  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)


  • Handle runtime errors


  • Describe stored procedures and functions


  • Use cursors to process rows


  • Design PL/SQL anonymous block that execute efficiently.


  • Describe the features and syntax of PL/SQL


Teilnehmerkreis

PL/SQL-Entwickler

Systemanalytiker

Technischer Berater

Formsentwickler

Voraussetzungen

Um diesen Kurs erfolgreich absolvieren zu können, sollten Sie über folgende Vorkenntnisse verfügen:

  • Oracle Database 11g: Introduction to SQL (combination of Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II)


  • Oracle Database 11g: SQL Fundamentals II


  • Oracle Database 11g: SQL Fundamentals I


Überblick über den Inhalt des Trainings

This course introduces students to PL/SQL and explains 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 also learn to

create anonymous PL/SQL blocks and are introduced to stored procedures

and functions. Students learn about declaring identifiers and trapping

exceptions. Demonstrations and hands-on practice reinforce the

fundamental concepts.

Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.

Introduction

  • Course Objectives
  • Course Agenda
  • Describing the Human Resources (HR) Schema
  • PL/SQL development environments Available in this course
  • Introduction to SQL Developer


Introduction to PL/SQL

  • PL/SQL Overview
  • Benefits of PL/SQL Subprograms
  • Overview of the Types of PL/SQL blocks
  • Creating and Executing a Simple Anonymous Block
  • Generating Output from a PL/SQL Block


Declaring PL/SQL Identifiers

  • Different Types of Identifiers in a PL/SQL subprogram
  • Using the Declarative Section to Define Identifiers
  • Storing Data in Variables
  • Scalar Data Types
  • %TYPE Attribute
  • Bind Variables
  • Using Sequences in PL/SQL Expressions


Writing Executable Statements

  • Describing Basic PL/SQL Block Syntax Guidelines
  • Commenting Code
  • SQL Functions in PL/SQL
  • Data Type Conversion
  • Nested Blocks
  • Operators in PL/SQL


Interacting with the Oracle Server

  • Including SELECT Statements in PL/SQL to Retrieve data
  • Manipulating Data in the Server Using PL/SQL
  • The SQL Cursor concept
  • Using SQL Cursor Attributes to Obtain Feedback on DML
  • Saving and Discarding Transactions


Writing Control Structures

  • Conditional processing Using IF Statements
  • Conditional processing Using CASE Statements
  • Simple Loop Statement
  • While Loop Statement
  • For Loop Statement
  • The Continue Statement


Working with Composite Data Types

  • Using PL/SQL Records
  • Using the %ROWTYPE Attribute
  • Inserting and Updating with PL/SQL Records
  • INDEX BY Tables
  • INDEX BY Table Methods
  • INDEX BY Table of Records


Using Explicit Cursors

  • Understanding Explicit Cursors
  • Declaring the Cursor
  • Opening the Cursor
  • Fetching data from the Cursor
  • Closing the Cursor
  • Cursor FOR loop
  • Explicit Cursor Attributes
  • FOR UPDATE Clause and WHERE CURRENT Clause


Handling Exceptions

  • Understanding Exceptions
  • Handling Exceptions with PL/SQL
  • Trapping Predefined Oracle Server Errors
  • Trapping Non-Predefined Oracle Server Errors
  • Trapping User-Defined Exceptions
  • Propagate Exceptions
  • RAISE_APPLICATION_ERROR Procedure


Creating Stored Procedures and Functions

  • Understanding Stored Procedures and Functions
  • Differentiate between anonymous blocks and subprograms
  • Create a Simple Procedure
  • Create a Simple Procedure with IN parameter
  • Create a Simple Function
  • Execute a Simple Procedure
  • Execute a Simple Function


Oracle Database 11g: PL/SQL Fundamentals

1.180 € zzgl. MwSt.