> > > 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.)
  • Deutschland: 2.010,- €
  • Schweiz: Fr. 2.484,-
Termine und Buchen
Online Training
Modality: U

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Deutschland: 1.893,- €
Termine und Buchen
 
Zum Buchen bitte auf den Ortsnamen klicken Kurstermine
Dies ist ein Instructor-led Online Training, das über WebEx in einer VoIP Umgebung durchgeführt wird. Sollten Sie Fragen zu einem unserer Online-Kurse haben, können Sie uns jederzeit unter +49 (0)40 25334610 oder per E-Mail an info@flane.de kontaktieren.
Deutschland
25.10. - 27.10.2027 Online Training Zeitzone: Europe/Berlin Kurssprache: englisch
 

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