> > > D80343

Oracle Database 12 R2c: Advanced PL/SQL (D80343)

Kursbeschreibung Kurstermine
 

Kursüberblick

This Oracle Database 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections.

Learn To:
  • Write powerful PL/SQL programs.
  • Explore programming efficiency.
  • Use external C and Java routines.
  • Apply PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Implement a virtual private database with fine-grained access control.
  • Write code to interface with external C and Java applications.
  • Write code to interface with large objects and use SecureFile LOBs.
  • Write and tune PL/SQL code effectively to maximize performance.
Benefits to You

Discover how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance. By investing in this course, you'll be introduced to the Virtual Private Database(VPD) to implement security policies and explore techniques and tools to strengthen your applications against SQL injection attacks. Expand programming resources by creating PL/SQL programs that interface with C and Java code.

Zielgruppe

Database administrators

Voraussetzungen

Kursziele

  • Design PL/SQL packages and program units that execute efficiently
  • Write code to interface with external applications and the operating system
  • Create PL/SQL applications that use collections
  • Write and tune PL/SQL code effectively to maximize performance
  • Implement a virtual private database with fine-grained access control
  • Write code to interface with large objects and use SecureFile LOBs

Kursinhalt

  • Introduction
  • PL/SQL Programming Concepts: Review
  • Designing PL/SQL Code
  • Overview of Collections
  • Using Collections
  • Manipulating Large Objects
  • Using Advanced Interface Methods
  • Performance and Tuning
  • Improving Performance with Caching
  • Analyzing PL/SQL Code
  • Profiling and Tracing PL/SQL Code
  • 12:Implementing VPD with Fine-Grained Access Control
  • Safeguarding Your Code Against SQL Injection Attacks
Classroom Training
Modality: C

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Deutschland: 2.031,- €
  • Schweiz: Fr. 2.484,-
inkl. Verpflegung
Verpflegung umfasst:

  • Kaffee, Tee, Saft, Wasser, Cola
  • Gebäck und Süßigkeiten
  • Frisches Obst
  • Mittagessen in einem der naheliegenden Restaurants

Gilt nur bei Durchführung durch Fast Lane. Termine, die von unseren Partnern durchgeführt werden, beinhalten ggf. ein abweichendes Verpflegungsangebot.


Termine und Buchen
Online Training
Modality: U

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Deutschland: 1.893,- €
Termine und Buchen
E-Learning Oracle Training on Demand
Modality: P
Preis (exkl. MwSt.)
  • Deutschland: 1.755,- €
E-Learning kaufen
 
Zum Buchen bitte auf den Ortsnamen klicken Kurstermine
Deutschland
04.03. - 06.03.2019 München
20.05. - 22.05.2019 Hamburg
26.08. - 28.08.2019 München
21.10. - 23.10.2019 Hamburg
Österreich
11.02. - 13.02.2019 Wien (iTLS)
26.08. - 28.08.2019 Wien (iTLS)
 

Cookies verbessern unsere Services. Durch die Benutzung unserer Website erklären Sie sich mit unserer Verwendung von Cookies einverstanden.   Verstanden.