Oracle Database 11g: PL/SQL Fundamentals

AS-SYSTEME Unternehmensberatung
Inhouse

1.180 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
711 9... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

  • Seminar
  • Anfänger
  • Inhouse
  • Dauer:
    2 Tage
Beschreibung

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.

Wichtige informationen

Häufig gestellte Fragen

· 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

Themenkreis

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



Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen