Konsultasiya almaq
Training Center MUKКурсыOracleDatabaseOracle Database 11g: Advanced PL/SQL

Oracle Database 11g: Advanced PL/SQL

Kursun kodu
Orl11g Adv
Müddət
3 Gün, 24 Saat
Kursun təsviri
Məqsədlər
Tələblər
Kursun proqramı
Kursun təsviri

Course overview

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 You

Extend 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.

Məqsədlər

Course Objectives

  • 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
Tələblər

Required Prerequisite

  • Knowledge of SQL
  • PL/SQL Programming experience

Audience

  • Database Administrator
  • Developer
Kursun proqramı

Course Topics

  1. Introduction
  2. PL/SQL Programming Concepts Review
  3. Designing PL/SQL Code
  4. Using Collections
  5. Manipulating Large Objects
  6. Using Advanced Interface Methods
  7. Performance and Tuning
  8. Improving Performance with Caching
  9. Analyzing PL/SQL Code
  10. Profiling and Tracing PL/SQL Code
  11. Implementing VPD with Fine-Grained Access Control
  12. Safeguarding Your Code Against SQL Injection Attacks
Ən yaxın kurs üçün qeydiyyat
Oracle Database 11g: Advanced PL/SQL
Kursun kodu:
Orl11g Adv
Müddət:
3 Gün, 24 Saat
Qeydiyyatan keç
Konsultasiya almaq
Свяжитесь со мной
Konsultasiya almaq
Отправить заявку
Vebinara qeydiyyat
Отправить заявку
Müraciətiniz qəbul olundu!
Yaxın zamanda sizinlə əlaqə saxlanılacaq.