PROKODA Gmbh

Oracle Database 11g: Advanced PL/SQL

PROKODA Gmbh
Online

2.031 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

Tipologie Seminar
Methodologie Online
Beginn nach Wahl
  • Seminar
  • Online
  • Beginn:
    nach Wahl
Beschreibung

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You’ll learn how it interfaces with the database and other applications in the most efficient manner.Learn To: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 YouExtend the functionality of the SQL language with PL/SQL language to write application code. This will help your organization realize the full benefit of utilizing Oracle best practices.Virtual Private DatabaseYou’ll also be introduced to Virtual Private Database (VPD) to implement security policies. Learn techniques and tools to strengthen applications against SQL injection attacks. Explore programming efficiency, use of external C and Java routines, PL/SQL server pages and fine-grained access.

Einrichtungen (1)
Wo und wann
Beginn Lage
nach Wahl
Online
Beginn nach Wahl
Lage
Online

Häufig gestellte Fragen

· An wen richtet sich dieser Kurs?

PL/SQL-EntwicklerDatenbankadministratoren

· Voraussetzungen

Erforderliche Vorkenntnisse:Knowledge of SQLPL/SQL Programming experienceOracle Database: Introduction to SQL

Was lernen Sie in diesem Kurs?

Interface
Access
Java
C
C+
C++
SQL
C#
PL SQL

Themenkreis

Introduction PL/SQL Programming Concepts ReviewDesigning PL/SQL CodeUsing CollectionsManipulating Large ObjectsUsing Advanced Interface MethodsPerformance and TuningImproving Performance with CachingAnalyzing PL/SQL CodeProfiling and Tracing PL/SQL CodeImplementing VPD with Fine-Grained Access ControlSafeguarding Your Code Against SQL Injection AttacksIntroduction PL/SQL Programming Concepts ReviewDesigning PL/SQL CodeUsing CollectionsManipulating Large ObjectsUsing Advanced Interface MethodsPerformance and TuningImproving Performance with CachingAnalyzing PL/SQL CodeProfiling and Tracing PL/SQL CodeImplementing VPD with Fine-Grained Access ControlSafeguarding Your Code Against SQL Injection Attacks

Zusätzliche Informationen

Förderung durch z.B. Bildungsprämie und NRW-Bildungsscheck möglichEmpfehlenswerte verwandte Kurse:Using Java - for PL/SQL and Database Developers This Java for PL/SQL and Developers training teaches you to access Oracle Database using JDBC , UCP, Java stored procedures and SQLJ technologies. Learn to create, load, resolve and publish Java classes in the Database and more.Oracle SQL Tuning for Developers WorkshopThis SQL Tuning for Developers training assists database developers, DBAs and SQL developers to identify and tune inefficient SQL statements. You’ll learn to interpret execution plans and the different ways that data can be accessed.Verwendete Datenbank Version:Oracle SQL Developer 2.1 (2.1.0.63.73) (no JDK)Oracle Database 11g Release 2 (11.2.0.1.0)URL zur Kursbeschreibung als PDF:http://education.oracle.com/pls/web_prod-plq-dad/view_pdf?c_org_id=34&c_lang=D&c_id=D52601GC20Seminarzeiten dieses Online-Trainings:2:30 Uhr bis 10:30 Uhr (Mitteleuropäischer Zeit)

User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
Mehr ansehen