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 Oracle Database: Develop PL/SQL Program Units course is designed for developers with basic PL/SQL and SQL language skills. You will learn to develop, execute and manage PL/SQL stored program units, which include: procedures, functions, packages and database 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

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Learn Dynamic SQL, Design Considerations and More

This course will also teach you how to use Dynamic SQL through instruction, as well as hands-on exercises. Expert Oracle instructors will also help you understand design considerations when coding using PL/SQL.

Using Oracle SQL Developer

In addition, you’ll 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 you’ve learned throughout the course.

Audience:

  • Application Developers
  • Database Administrators
  • System Analysts
  • Support Engineer
  • PL/SQL Developer

Course Objectives:

  • 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
  • Design PL/SQL code for predefined data types, local subprograms, additional programs and standardized constants and exceptions
  • Use the compiler warnings infrastructure
  • Use conditional PL/SQL compilation and obfuscate (hide) code
  • Create triggers to solve business challenges
  • Manage dependencies between PL/SQL subprograms

 
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  
 6/5/2017
 $2145
 8/14/2017
 $2145

To Inquire About Future Classes

Request a class date

if one is not scheduled.