fbpx

Oracle Database 19c: Advanced PL/SQL

Presencial
Aveiro
Sob consulta
Sob consulta
Chat

This course 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. You will learn 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.

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.
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service.

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.

Objetivos

  • 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
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service

Destinatários

  • Database Administrator
  • Developer

Pré-Requisitos

  • 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 : SQL Tuning for Developers
  • Oracle Database: Develop PL/SQL Program Units

Programa

  • Introduction
  • Working with Exadata Express Cloud Service
  • Overview of Collections
  • Using Collections
  • Handling Large Objects
  • JSON Data in Database
  • Advanced Interface Methods
  • Performance and Tuning
  • Improving Performance with Caching
  • Analyzing PL / SQL Code
  • Profiling and Tracing PL / SQL Code
  • Securing Applications through PL / SQL
  • Safeguarding Your Code against SQL Injection Attacks
  • Advanced Security Mechanisms

Outras datas e horários

Chat

Quero saber mais informações sobre este curso

Oracle Database 19c: Advanced PL/SQL

Oracle | 18h - Laboral: 09h30 - 16h30


Notas

Pretende mais informação sobre este curso?

Preencha o formulário com os seus dados e as suas questões e entraremos em contacto consigo para lhe darmos todas as informações pretendidas.

Obrigado!

Quero inscrever-me neste curso

Oracle Database 19c: Advanced PL/SQL

Oracle | 18h - Laboral: 09h30 - 16h30


Dados Pessoais
Dados para faturação