Kód kurzu: D80343« Krok späť

Oracle Database 12c: Advanced PL/SQL

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. 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.

 DátumDníCena kurzuCena príručkyJazyk výukyLokalita 
Kedykoľvek 3 30 120 CZK v cene kurzu Anglický jazyk On Demand
 
16. 12. 2019 3 1 350,00 EUR v cene kurzu Slovenský jazyk GOPAS Bratislava_GTT (info o GTT)
 
30. 3. 2020 3 1 350,00 EUR v cene kurzu Český jazyk GOPAS Bratislava_GTT (info o GTT)
 
16. 12. 2019 3 36 588 CZK v cene kurzu Český jazyk GOPAS Brno_GTT (info o GTT)
 
30. 3. 2020 3 36 588 CZK v cene kurzu Český jazyk GOPAS Brno_GTT (info o GTT)
 
16. 12. 2019 3 36 588 CZK v cene kurzu Český jazyk GOPAS Praha_GTT (info o GTT)
 
30. 3. 2020 3 36 588 CZK v cene kurzu Český jazyk GOPAS Praha_GTT (info o GTT)
 
13. 11. 2019 3 36 588 CZK v cene kurzu Anglický jazyk Virtual Class Oracle
 
Kedykoľvek 3 32 448 CZK v cene kurzu Anglický jazyk Virtual Class
 
V prípade záujmu o iný termín uvedeného kurzu, kontaktujte klientsky servis, prosím.

PobočkaDníKatalógová cenaCena príručkyITB*
Praha3 36 588 CZK v cene kurzu 45
Brno3 36 588 CZK v cene kurzu 45
Bratislava3 1 350,00 EUR v cene kurzu 45

*Body se vztahují pouze na kurzy realizované v prostorách Gopasu.

Co Vás naučíme

  • 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.

Požadované vstupní znalosti

Basic Knowledge of SQL, PL/SQL
Familiarity with programming languages
Oracle Database: Develop PL/SQL Program Units NEW
Oracle Database: SQL Workshop I NEW

Metody výuky

Odborný výklad s praktickými ukázkami, cvičení na počítačích.

Formáty školení Oracle

Velmi oblíbenou formou školení jsou nahrávané kurzy On Demand zahrnující 90 dnů samostudia kdykoliv a kdekoliv s TOP lektorem. Dalšími možnými formáty studia jsou kurzy probíhající přímo v učebně v Počítačové škole Gopas nebo ve společnosti Oracle, dále formát Live Virtual Class (školení on-line) či Selft-Study (samostudium ve formě CD, nebo download). Podrobnější informace k těmto možnostem studia najdete zde.

Studijní materiály

Elektronické autorizované materiály Oracle v anglickém jazyce.

Osnova kurzu

Introduction

  • Course Objectives
  • Course Agenda
  • Describe the development environments
  • Identify the tables, data, and tools used in this course

PL/SQL Programming Concepts: Review

  • Identify PL/SQL block structure
  • Packages, procedures and functions
  • Cursors
  • Handle exceptions
  • Dependencies

Designing PL/SQL Code

  • 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

  • Overview of collections
  • Use Associative arrays
  • Navigate using associative methods
  • Use Nested tables
  • Use Varrays
  • Compare nested tables and varrays

Using Collections

  • Write PL/SQL programs that use collections
  • Use Collections effectively
  • Enhancements to PL/SQL Type Binds

Manipulating Large Objects

  • Working with LOBs
  • Overview of SecureFile LOBs

Using Advanced Interface Methods

  • 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

Performance and Tuning

  • Understand and influence the compiler
  • Tune PL/SQL code
  • Enable intra unit inlining
  • Identify and tune memory issues
  • Recognize network issues

Improving Performance with Caching

  • Describe result caching
  • Use SQL query result cache
  • Use PL/SQL function cache
  • Review PL/SQL function cache considerations

Analyzing PL/SQL Code

  • Finding Coding Information
  • PL/Scope Concepts
  • DBMS_METADATA Package
  • PL/SQL Enhancements

Profiling and Tracing PL/SQL Code

  • Tracing PL/SQL Execution
  • Tracing PL/SQL: Steps

12:Implementing VPD with Fine-Grained Access Control

  • 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

Safeguarding Your Code Against SQL Injection Attacks

  • SQL Injection Overview
  • Reducing the Attack Surface
  • Filtering Input with DBMS_ASSERT

Predošlé kurzy

Nasledujúce kurzy

žiadny nadväzujúci kurz
Oracle University eKit

Cena:
cena kurzu zahŕňa
Uvedené ceny sú bez DPH.