Отримати консультацію
Training Center MUKКурсыOracleDatabaseOracle Database 12c R2: Advanced PL/SQL Ed 2 NEW

Oracle Database 12c R2: Advanced PL/SQL Ed 2 NEW

Код курсу
3 Днів, 24 Ак. Годин
Опис курсу
Програма курсу
Опис курсу

Course overview

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. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.


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
  • Learn to work with JSON data in relational database
  • 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


  • Basic Knowledge of SQL, PL/SQL
  • Familiarity with programming languages
  • Oracle Database SQL and PL/SQL New Features
  • Oracle Database: Introduction to SQL/PLSQL Accelerated
  • Oracle Database 12c: SQL Tuning for Developers
  • Oracle Database: Develop PL/SQL Program Units


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

Course Topics

  1. Introduction
  2. Oracle Database Exadata Express Cloud Service
  3. Overview of Collections
  4. Using Collections in PL/SQL
  5. Manipulating Large Objects
  6. Working with JSON Data
  7. Using Advanced Interface Methods
  8. Performance and Tuning
  9. Improving Performance with Caching
  10. Analyzing PL/SQL Code
  11. Profiling and Tracing PL/SQL Code
  12. Securing application through PL/SQL
  13. Safeguarding Your Code Against SQL Injection Attacks
  14. Security Features implemented through PL/SQL
Реєстрація на найближчий курс
Oracle Database 12c R2: Advanced PL/SQL Ed 2 NEW
Код курсу:
3 Днів, 24 Ак. Годин
Отримати консультацію
Свяжитесь со мной
Отримати консультацію
Отправить заявку
Реєстрація на вебінар
Отправить заявку
Ваша заявка отримана!
Ми зв`яжимося з вами найближчим часом.