logo

Oracle Database 12c: PL/SQL III – Advanced Programming & Tuning (DB6159)

The PL/SQL programming language is at the core of most Oracle database applications. This course will give attention to three fundamental pillars of effective implementation of PL/SQL applications. First, we will explore the advanced features of the language that allow powerful and adaptable database applications to be built. Next, we will discuss performance tuning techniques that allow these applications to run efficiently. Finally, we will consider critical security measures which should be implemented to counter hacker attacks and other security threats.

Pohađajte naše Oracle obuke u Beogradu, putem virtuelne učionice (online, uživo) ili u vašim prostorijama (on-site).

Specijalni popusti se odobravaju prilikom prijave više učesnika koji istovremeno pohađaju obuku iz vaše kompanije, državni i neprofitni sektor, itd. Kontaktirajte nas da biste saznali više.

Termini obuke

Trajanje obuke: 
5 dana / 35 sati

Privatni trening

On-site / Online
Minimalan broj polaznika: 3
5 dana / 35 sati
Cena na zahtev
srpski ili engleski
Plan obuke: 

Advanced Programming: Why Needed & PL/SQL Execution Internals

  • Why Advanced Programming?
  • SQL & PL/SQL Execution Internals
  • SQL & PL/SQL PGA Internals

Advanced Programming: Dynamic SQL

  • Advantages Of Dynamic SQL
  • Native Dynamic SQL
  • Dynamic SQL Using DBMS_SQL() 

Advanced Programming: Using Collections

  • About Collections
  • Bulk Bind Using Collections
  • About SQL%BULK_ROWCOUNT()
  • About SQL%BULK_EXCEPTIONS()
  • Collection Methods
  • More About RETURNING Clause
  • Advanced Collection Features
  • IN INDICES OF Clause
  • IN VALUES OF Clause 

Advanced Programming: Java & C Interface Methods

  • Advanced Program Interfaces
  • Calling Java Classes
  • Calling C Programs 

System-Supplied Packages: DBMS_METADATA() – Part I

  • Why Retrieve Object Definitions?
  • Retrieving Default Metadata
  • Retrieving Customized Metadata
  • Using SET_COUNT()
  • Using ADD_TRANSFORM()
  • Using FETCH DDL()
  • Calling FETCH_DDL() 

System-Supplied Packages: DBMS_METADATA() – Part II

  • SET_TRANSFORM_PARAM()
  • GET_QUERY()

System-Supplied Packages: DBMS_METADATA() – Part III

  • FETCH CLOB()
  • SET_FILTER() Dependent Objects
  • SET_PARSE_ITEM()
  • Primary & Dependent Object DDL 

System-Supplied Packages: DBMS_REDEFINITION()

  • About Table Redefinition
  • Using DBMS_REDEFINITION()
  • DBA_REDEFINITION_ERRORS
  • CAN_REDEF_TABLE()
  • START_REDEF_TABLE()
  • FINISH_REDEF_TABLE()
  • ABORT_REDEF_TABLE()
  • COPY_TABLE_DEPENDENTS()
  • SYNC_INTERIM_TABLE()

System-Supplied Packages: DBMS_LOB()

  • Working With External BFILES
  • Working With Internal LOBS
  • SUBSTR()
  • INSTR()
  • Dynamic SECUREFILE Options

High-Performance: Advanced System-Supplied Packages

  • COMPRESSION & UTL_COMPRESS()
  • LZ_COMPRESS()
  • LZ_UNCOMPRESS()
  • DBMS_DESCRIBE()
  • UTL_MAIL()
  • DBMS_UTILITY()
  • COMPILE_SCHEMA()
  • DB_VERSION()
  • GET_PARAMETER_VALUE()
  • WAIT_ON_PENDING_DML()
  • GET_TIME()
  • GET_ENDIANNESS()
  • DBMS_FILE_TRANSFER()

High Performance: Programming & Coding Techniques

  • Autonomous Transactions
  • Using NOCOPY FOR Parameters
  • Choosing The Optimum Data Type
  • About NOT NULL
  • Useful PL/SQL Coding Techniques
  • Handling String Literals
  • User-Defined SQL Functions

High Performance: Influencing Oracle Pl/Sql Compilation

  • PL/SQL Compiler Optimization
  • PLSQL_OPTIMIZE_LEVEL
  • Controlling Compilation Messages
  • PL/SQL Native Execution
  • Wrapping Source Code

High Performance: Dynamic Partitioning & Parallelization

  • Dynamic Partitioning (Chunks)
  • Creating & Processing Chunks
  • CREATE_TASK()
  • CREATE_CHUNKS_BY_ROWID()
  • CREATE_CHUNKS_BY_NUMBER_COL()
  • EXECUTE_RUN_TASK()
  • TASK_STATUS()
  • DROP_TASK()
  • Monitoring Chunk Processing 

High Performance: Using PL/SCOPE For Code Analysis

  • Configuring PL/SCOPE
  • PLSCOPE_SETTINGS
  • Using PL/SCOPE Data

High Performance: Tuning With The Hierarchical Profiler

  • What Is The Hierarchical Profiler?
  • Configuring The Profiler
  • Managing Profiler Runs
  • Analyzing Profiler Data
  • Interpreting The Results
  • DBMSHP_RUNS
  • DBMSHP_FUNCTION_INFO
  • DBMSHP_PARENT_CHILD_INFO

High Performance: Debugging With DBMS_TRACE()

  • Using The Trace Facility
  • DBMS_TRACE() To Manage Runs
  • Examining The Trace Data
  • EVENT_KIND Values 

Application Security: SQL Injection Attacks

  • Understanding The Threat
  • Applying Countermeasures 

Application Security: Virtual Private Databases

  • Understanding VPDS
  • Preparing For A VPD
  • Configuring A VPD
  • Managing Application Contexts
  • Managing Policies & Security Rules
Benefiti: 
  • Video snimak predavanja u periodu od 180 dana posle kraja obuke

  • Pristup laboratorijama u toku trajanja kursa
  • Materijal u elektronskom obliku

  • Sertifikat o pohađanju kursa

Poželjno predznanje: 

Specific prerequisites for this course are the following titles, or equivalent experience:

  • ORACLE DATABASE 12C: SQL FUNDAMENTALS (LEVELS I & II) 

  • ORACLE DATABASE 12C: PL/SQL FUNDAMENTALS (LEVELS I & II)

Kontaktirajte nas za više informacija o ceni:

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 195
E-mail: Jelena.Mijanovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 197
E-mail: Boris.Gigovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs