Отримати консультацію
Training Center MUKКурсыOracleDatabaseOracle Database 11g: Advanced PL/SQL

Oracle Database 11g: Advanced PL/SQL

Код курсу
Orl11g Adv
Тривалість
3 Днів, 24 Ак. Годин
Опис курсу
Цілі
Вимоги
Програма курсу
Опис курсу

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.

Цілі

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
Вимоги

Required Prerequisite

  • Knowledge of SQL
  • PL/SQL Programming experience

Audience

  • Database Administrator
  • Developer
Програма курсу

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
Реєстрація на найближчий курс
Oracle Database 11g: Advanced PL/SQL
Код курсу:
Orl11g Adv
Тривалість:
3 Днів, 24 Ак. Годин
Зареєструватися
Отримати консультацію
Свяжитесь со мной
Отримати консультацію
Отправить заявку
Реєстрація на вебінар
Отправить заявку
Ваша заявка отримана!
Ми зв`яжимося з вами найближчим часом.