This Oracle Database: PL/SQL Program Units course builds on existing knowledge of PL/SQL block structure, variables, control structures and exception handling to explore the benefits of building Progran Units in this powerful programming [...]
  • OCDBDPSPU-QA
  • Cena na vyžádání

This Oracle Database: PL/SQL Program Units course builds on existing knowledge of PL/SQL block structure, variables, control structures and exception handling to explore the benefits of building Progran Units in this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and triggers and utilise Oracle provided packages. Learn To: Develop stored procedures to carry out database modifications. Write functions to be called from PL/SQL code or SQL statements. Use PL/SQL packages to group and contain related constructs. Create triggers to solve business challenges. Use Oracle supplied PL/SQL packages to generate screen output and file output. Examine the dependency chain on program units prior to implementing changes. Benefits to You: Develop sound, reliable program units to standardise and streamline your organisation's approach to maintaining data. You'll use Oracle SQL Developer to develop these program units. SQL*Plus is also available as an optional tool.

  • Create triggers to solve business challenges
  • Manage dependencies between PL/SQL subprograms
  • Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
  • Use the compiler warnings infrastructure
  • Create, use, and debug stored procedures and functions
  • Design and use PL/SQL packages to group and contain related constructs
  • Create overloaded package subprograms for more flexibility
  • Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
  • Write dynamic SQL for more coding flexibility
  • Use conditional PL/SQL compilation and obfuscate (hide) code

Mám zájem o vybraný QA kurz