Oracle Database 11g R2: Advanced PL/SQL Programming & Tuning

  • 4h 39m
  • Sideris Courseware Corporation
  • Sideris
  • 2011

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

Audience

The target audience for this course is senior application developers. Developers who will be building, debugging and tuning PL/SQL program units will benefit from this course.

In this Book

  • Introduction
  • Workshop Setup Guide
  • Dynamic SQL
  • Dynamic SQL
  • Using Collections
  • Using Collections
  • System-Supplied Packages—DBMS_METADATA() — Part I
  • System-Supplied Packages—DBMS_METADATA() — Part I
  • System-Supplied Packages—DBMS_METADATA() — Part II
  • System-Supplied Packages—DBMS_METADATA() — Part II
  • System-Supplied Packages—DBMS_METADATA() — Part III
  • System-Supplied Packages—DBMS_METADATA() — Part III
  • System-Supplied Packages—DBMS_REDEFINITION()
  • System-Supplied Packages—DBMS_REDEFINITION()
  • System-Supplied Packages—DBMS_LOB()
  • System-Supplied Packages—DBMS_LOB()
  • System-Supplied Packages—Others
  • System-Supplied Packages—Others
  • Advanced Interface Methods
  • Advanced Interface Methods
  • PL/SQL Advanced Programming & Coding Techniques
  • PL/SQL Advanced Programming & Coding Techniques
  • Influencing Oracle PL/SQL Compilation
  • Dynamic Partitioning & Parallelization
  • Dynamic Partitioning & Parallelization
  • Using PL/Scope
  • Using PL/Scope
  • Application Tuning with the PL/SQL Hierarchical Profiler
  • Application Tuning with the PL/SQL Hierarchical Profiler
  • PL/SQL Debugging with DBMS_TRACE()
  • PL/SQL Debugging with DBMS_TRACE()
  • Protecting against SQL Injection Attacks
  • Protecting against SQL Injection Attacks
  • Implementing Virtual Private Databases
  • Implementing Virtual Private Databases
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Oracle on Docker: Running Oracle Databases in Linux Containers
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Book Extending Oracle Application Express with Oracle Cloud Features: A Guide to Enhancing APEX Web Applications with Cloud-Native and Machine Learning Technologies