Oracle Database: Develop PL SQL Program Units

SKU: OCDBDPSPU

Þessi vara er ekki til á lager og þvi ófáanleg eins og er.

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

Forkröfur

Required

  • Oracle Database: SQL Workshop (or equivalent knowledge)
  • Oracle Database: PL/SQL Fundamentals

Suggested

  • Familiarity with data processing concepts and techniques
  • Familiarity with programming languages

Audience

  • Database Administrator
  • Developer
  • Implementer
  • Tester

Nemandi mun læra eftirfarandi

  • Describe stored procedures and functions
  • 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 greater flexibility
  • Use Oracle supplied PL/SQL packages to generate console and file output
  • Write dynamic SQL for more coding flexibility
  • Create Triggers
  • Manage dependencies between PL/SQL subprograms

Samantekt

  • Creating Stored Procedures
  • Creating Functions
  • Debugging Subprograms
  • Creating Packages
  • Working with Packages
  • Using Oracle-Supplied Packages in Application Development
  • Using Dynamic SQL
  • Creating Triggers
  • Creating Compound, DDL and Event Database Triggers
  • Design Considerations for PL/SQL Code
  • Tuning the PL/SQL Compiler
  • Managing Dependencies