Fique a par dos conhecimentos avançados em PL/SQL com o curso em bases de dados Oracle. Nesta formação, os formandos desenvolvem as competências necessárias para usar as componentes mais avançadas de PL/SQL e como as utilizar como interface entre outras bases de dados e aplicações.
This Oracle Database: 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.
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.
Introduction
PL/SQL Programming Concepts: Review
Designing PL/SQL Code
Overview of Collections
Using Collections
Manipulating Large Objects
Using Advanced Interface Methods
Performance and Tuning
Improving Performance with Caching
Analyzing PL/SQL Code
Profiling and Tracing PL/SQL Code
12:Implementing VPD with Fine-Grained Access Control
Safeguarding Your Code Against SQL Injection Attacks
Oracle Cloud Overview