Oracle Database Develop PL-SQL Program Units Ed 2

Course overview for course Oracle Database Develop PL-SQL Program Units Ed 2

The Oracle Database Develop PL-SQL Program Units Ed 2 course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers.

Learn To

  • Create, and execute stored procedures and functions.
  • Design and use PL/SQL packages.
  • Create overloaded package subprograms for more flexibility.
  • Utilize Oracle-Supplied Packages in Application Development.
  • Create triggers to solve business challenges.
  • Build and execute SQL statements dynamically.

Objectives for the course Oracle Database Develop PL-SQL Program Units Ed 2

  • 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

Course Information

  • Delivery Method: Classroom
  • Course Duration: 3 days
  • Course Level: Intermediate

Audience Summary

  • IT Professional
  • Database Administrators
  • PL/SQL Developers

Prerequisites for this course

  • Oracle Database: Introduction to SQL
  • Oracle Database: SQL Workshop II Ed 2
  • Oracle Database: SQL Workshop I Ed 2

Course content summary for Oracle Database Develop PL-SQL Program Units Ed 2

  • Introduction
  • Working with Oracle Database Exadata Express Cloud Service
  • Creating Stored Procedures
  • Creating Functions and 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
  • Using PL/SQL compiler
  • Managing Dependencies

More Evolutiontech Courses for Oracle Database

Fale Conosco

Solicite o conteúdo programático do treinamento “Oracle Database Develop PL-SQL Program Units Ed 2” ao nosso departamento comercial

Deixe uma resposta

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *