> > > D80170

Oracle Database: Develop PL/SQL Program Units (D80170)

Kursbeschreibung Kurstermine Detaillierter Kursinhalt
 

Kursüberblick

This 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.
Benefits To You

Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies. In this course, students learn and use Oracle SQL Developer as the main environment tool to develop these program units. SQL*Plus is introduced as optional tools. Demonstrations and hands-on practice reinforce the fundamental concepts.

Zielgruppe

  • Database Administrators
  • System Analysts
  • Forms Developer
  • Technical Consultant
  • Portal Developer
  • PL/SQL Developer

Voraussetzungen

Required Prerequisites:
  • Familiarity with data processing concepts and technique
  • Familiarity with programming languages
Suggested Prerequisites:
  • Familiarity with data processing concepts and techniques
  • Familiarity with programming languages

Kursziele

  • Use conditional PL/SQL compilation and obfuscate (hide) code
  • 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

Kursinhalt

  • 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
Classroom Training
Modality: G

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Schweiz: CHF 2'484.-
  • Deutschland: 2'010.- €
Termine und Buchen
Online Training
Modality: U

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Schweiz: CHF 2'313.-
  • Deutschland: 1'893.- €
Termine und Buchen
 
Kurstermine

Derzeit gibt es keine Trainingstermine für diesen Kurs.  Termin anfragen

 

Cookies verbessern unsere Services. Durch die Benutzung unserer Website erklären Sie sich mit unserer Verwendung von Cookies einverstanden.   Verstanden.