Oracle PL/SQL Programming Training

Nivå: Intermediate
Snittbetyg: 4,7/5 4,70/5 Based on 192 Reviews

This Oracel PL/SQL training course will teach you to increase the productivity, performance, scalability, portability, and security of your Oracle database. With this training, you will learn how to execute PL/SQL programs in Oracle, build stored procedures, design and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.

Nyckelfunktioner:

  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included

Du kommer lära dig att:

  • Develop efficient PL/SQL programs to access Oracle databases
  • Create stored procedures and functions for reuse and maintenance
  • Design modular applications using packages
  • Manage data retrieval for front-end applications
  • Invoke native dynamic SQL to develop high-level abstract code

Välj den utbildningsform som passar dig bäst

LIVE, LÄRARLEDD

Klassrum och självstudier

  • 5-day instructor-led training course
  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included

FÖRETAGSINTERN UTBILDNING

Teamträning

  • Använd denna eller någon annan utbildning i ditt företag
  • Fullskalig programutveckling
  • Levereras när, var och hur du vill
  • Blandade utbildningsmodellerSkräddarsytt innehåll
  • Coaching av ett expertteam

Anpassa kurs och innehåll efter teamets behov

Kontakta oss

Utveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning

Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .

Klassrum och självstudier

Note: This course runs for 5 dagar

  • 23 - 27 mar 9:00 - 4:30 GMT London / Online (AnyWare) London / Online (AnyWare) Boka Din Kursplats

  • 20 - 24 jul 9:00 - 4:30 BST London / Online (AnyWare) London / Online (AnyWare) Boka Din Kursplats

  • 12 - 16 okt 9:00 - 4:30 BST London / Online (AnyWare) London / Online (AnyWare) Boka Din Kursplats

  • 13 - 17 jan 9:00 - 4:30 EST Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Boka Din Kursplats

  • 10 - 14 feb 9:00 - 4:30 EST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Boka Din Kursplats

  • 16 - 20 mar 9:00 - 4:30 EDT Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Boka Din Kursplats

  • 20 - 24 apr 9:00 - 4:30 EDT New York / Online (AnyWare) New York / Online (AnyWare) Boka Din Kursplats

  • 22 - 26 jun 9:00 - 4:30 EDT Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Boka Din Kursplats

  • 10 - 14 aug 9:00 - 4:30 EDT Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Boka Din Kursplats

  • 14 - 18 sep 9:00 - 4:30 EDT Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Boka Din Kursplats

Kurs med startgaranti

När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.

PL/SQL Course Information

  • Requirements

    • Knowledge at the level of:
  • Software

    • This course is currently running on Oracle 12c

PL/SQL Course Outline

  • Introduction and Overview

    PL/SQL fundamentals

    • Declaring and anchoring variables to database definitions
    • Flow control constructs

    Oracle 11g and 12c PL/SQL features

    • PL/Scope in Oracle 11g
    • Returning implicit cursor results from stored procedures in Oracle 12c
    • Declaring local functions within SELECT statements in Oracle 12c
  • Data Manipulation Techniques

    Maintaining data with DML statements

    • Employing the RETURNING INTO clause
    • Solving the fetch-across-commit problem

    Managing data retrieval with cursors

    • Implications of explicit and implicit cursors
    • Simplifying cursor processing with cursor FOR LOOPs
    • Embedding cursor expressions in SELECT statements

    Cursor variables

    • Strong vs. weak cursor variables
    • Passing cursor variables to other programs
    • Defining REF CURSORS in packages
  • Developing Well-Structured and Error-Free Code

    Error handling using EXCEPTIONs

    • Propagation and scope
    • "Retrying" problem transactions with EXCEPTION processing

    Debugging PL/SQL blocks

    • Simplifying testing and debugging with conditional compilation
    • Interpreting compiler messages
    • Applying structured testing techniques
    • Building and applying a test bed
    • Leveraging the debugging facilities in SQL Developer
  • Achieving Maximum Reusability

    Writing stored procedures and functions

    • Calling and invoking server-side logic
    • Passing input and output parameters
    • Implementing an autonomous transaction

    Coding user-written functions

    • Calling PL/SQL functions from SQL
    • Building table-valued functions

    Developing safe triggers

    • Employing :OLD and :NEW variables
    • Avoiding unreliable trigger constructs
    • Exploiting schema and database triggers
  • Exploiting Complex Datatypes

    Collection types

    • PL/SQL tables, nested tables, VARRAYs
    • Stepping through dense and nonconsecutive collections

    Bulk binding for high performance

    • Moving data into and out of PL/SQL blocks
    • BULK COLLECT INTO and FORALL
    • BULK cursor attributes
    • BULK EXCEPTION handling
  • Invoking Native Dynamic SQL

    Finessing the compiler

    • The EXECUTE IMMEDIATE statement
    • The RETURNING INTO clause

    Types of dynamic SQL

    • Building SQL statements during runtime
    • Autogenerating standard code
  • Package Tips and Techniques

    • Package structure: SPEC and BODY
    • Eliminating dependency problems
    • Overloading for polymorphic effects
    • Evaluating application frameworks
    • Declaring and using persistent global variables

Teamträning

PL/SQL Training FAQs

  • What software does this Oracle PL/SQL course run on?

    This course is currently running on Oracle 12c.

  • Can I learn Oracle PL/SQL programming online?

    Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.

Questions about which training is right for you?

call 08-506 668 00




100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

  • If you are not 100 % satisfied, you pay no tuition fee!
  • No advance payment required for most products.
  • Tuition fee can be paid later by invoice - OR - at the time of checkout by credit card.

*Partner-delivered courses may have different terms that apply. Ask for details.

London / Online (AnyWare)
London / Online (AnyWare)
London / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Alexandria, VA / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Alexandria, VA / Online (AnyWare)
Hur föredrar du att bli kontaktad:

Please Choose a Language

Canada - English

Canada - Français