Oracle Database 11g: Programm with PL/SQL

Seminar

In Bremen, Dreieich-Sprendlingen, Dresden und an 3 weiteren Standorten

2.950 € zzgl. MwSt.

Beschreibung

  • Kursart

    Seminar

  • Niveau

    Fortgeschritten

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..
Gerichtet an: Sie sind Systemanalytiker, PL/SQL-Entwickler, Formsentwickler, Datenbankadministrator, Technischer Berater oder Entwickler.

Standorte und Zeitplan

Lage

Beginn

Bremen

Beginn

auf Anfrage
Dreieich-Sprendlingen (Hessen)

Beginn

auf Anfrage
Dresden (Sachsen)

Beginn

auf Anfrage
Erlangen (Bayern)
Karte ansehen
Koldestraße 8, 91052

Beginn

auf Anfrage
Jena (Thüringen)
Karte ansehen
Löbdergraben 28, 07743

Beginn

auf Anfrage
Leipzig (Sachsen)

Beginn

auf Anfrage
Alle ansehen (6)

Hinweise zu diesem Kurs

Besuch der Seminare "Oracle Database 11g: Professioneller Einstieg in Oracle SQL" (D49988) oder "Oracle Database 11g: SQL Fundamentals I" (D49996) und "Oracle Database 11g: SQL Fundamentals II" (D49994). Sie sollten auch Erfahrung in der Programmierung haben.

Fragen & Antworten

Teilen Sie Ihre Fragen und andere User können Ihnen antworten

Wer möchten Sie Ihre Frage beantworten?

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

Inhalte

Beschreibung

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.

This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

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

Conditionally control code flow (loops, control structures)

Design and use PL/SQL packages to group and contain related constructs.

Create triggers to solve business challenges.

Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.

Create anonymous PL/SQL blocks of code.

Declare PL/SQL Variables

Zielgruppe

Sie sind Systemanalytiker, PL/SQL-Entwickler, Formsentwickler, Datenbankadministrator, Technischer Berater oder Entwickler.

Voraussetzungen

Besuch der Seminare "Oracle Database 11g: Professioneller Einstieg in Oracle SQL" (D49988) oder "Oracle Database 11g: SQL Fundamentals I" (D49996) und "Oracle Database 11g: SQL Fundamentals II" (D49994). Sie sollten auch Erfahrung in der Programmierung haben.

Kursinhalte

  • 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 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

Oracle Database 11g: Programm with PL/SQL

2.950 € zzgl. MwSt.