KT-3116 Oracle Database: Develop PL/SQL Program Units Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Oracle Database: Develop PL/SQL Program Units


Description: 

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.
  • Manage PL/SQL subprograms and triggers.
  • Understand and influence the PL/SQL compiler.
  • Manage dependencies.

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.

Audience:

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

Course 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

 
Click here to view the Course Outline
     
Prerequisite: 

Required Prerequisites:

  • Basic Knowledge of PL/SQL
  • Familiarity with programming languages
  • Oracle Database: Introduction to SQL Ed 1.1
  • Oracle Database: PL/SQL Fundamentals

Suggested Prerequisites:

  • Oracle SQL Tuning for Developers Workshop
 
   
     
Duration: 
3 Days  
     
     

View Printer Friendly Page

 

Course Schedule
  Start Date  City  Price  
 8/14/2017
 $2145
 10/9/2017
 $2205

To Inquire About Future Classes

Request a class date

if one is not scheduled.