D80170 - Oracle Database: Develop PL/SQL Program Units

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.

Code: d80170

Duration: 3.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:

  • 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

Content

  • Module 1: Introduction
  • Module 2: Working with Oracle Database Exadata Express Cloud Service
  • Module 3: Creating Stored Procedures
  • Module 4: Creating Functions and Debugging Subprograms
  • Module 5: Creating Packages
  • Module 6: Working With Packages
  • Module 7: Using Oracle-Supplied Packages in Application Development
  • Module 8: Using Dynamic SQL
  • Module 9: Creating Triggers
  • Module 10: Creating Compound, DDL, and Event Database Triggers
  • Module 11: Design Considerations for PL/SQL Code
  • Module 12: Using PL/SQL compiler
  • Module 13: Managing Dependencies

Audience

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

Prerequisites

  • Familiarity with data processing concepts and technique
  • Familiarity with programming languages
  • Oracle Database 12c: Introduction for Experienced SQL Users

Suggested Prerequisites:

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

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
 
 
 
 
Xd3DgB
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy