Számalk Oktatási és Informatikai Zrt.
Cím: 1119 Budapest, Fejér Lipót u. 70.
E-mail: training##kukac##szamalk.hu
Telefon: +36 1 491 8974
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.
Learn To:
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.
Course Objectives
Course Agenda
Describe the development environments
Identify the tables, data, and tools used in this course
Identify PL/SQL block structure
Packages, procedures and functions
Cursors
Handle exceptions
Dependencies
Describe the predefined data types
Create subtypes based on existing types for an application
List the different guidelines for cursor design
Describe cursor variables
White List
Overview of collections
Use Associative arrays
Navigate using associative methods
Use Nested tables
Use Varrays
Compare nested tables and varrays
Write PL/SQL programs that use collections
Use Collections effectively
Enhancements to PL/SQL Type Binds
Working with LOBs
Overview of SecureFile LOBs
Calling External Procedures from PL/SQL
Benefits of External Procedures
Understand how an external routine is called from PL/SQL
C advanced interface methods
Java advanced interface methods
Understand and influence the compiler
Tune PL/SQL code
Enable intra unit inlining
Identify and tune memory issues
Recognize network issues
Describe result caching
Use SQL query result cache
Use PL/SQL function cache
Review PL/SQL function cache considerations
Finding Coding Information
PL/Scope Concepts
DBMS_METADATA Package
PL/SQL Enhancements
Tracing PL/SQL Execution
Tracing PL/SQL: Steps
Understand how fine-grained access control works overall
Describe the features of fine-grained access control
Describe an application context
Create an application context
Set an application context
List the DBMS_RLS procedures
Implement a policy
Query the dictionary views holding information on fine-grained access
SQL Injection Overview
Reducing the Attack Surface
Filtering Input with DBMS_ASSERT
Introduction to Oracle Cloud & Oracle Cloud Services
Cloud Deployment Models
Evolving from On-premises to Exadata Express
What is in Exadata Express?
Exadata Express for Users & Developers
Oracle Exadata Express Cloud Service
Getting Started with Exadata Express
Service Console & Web Access through Service Console