KT-5533 Oracle Introduction to PL/SQL Programming 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 Introduction to PL/SQL Programming


Description: 

This class will teach you how to write PL/SQL programs. You will learn the critical aspects of PL/SQL language including language basics, bulk processing, procedures, , functions, and triggers , error handling and packages. Hands-on workshops constitute approximately 50% of the class.

Audience: Developers, DBAs and analysts

Objectives: After successfully completing this course, you will be able to:

  • Code PL/SQL programs that include common programming constructs such as data-typing, var iable assignment, flow control, cursor handling, bulk processing, array processing a nd error handling
  • Use bulk processing to write efficient PL/SQL programs.
  • Use UTL_FILE to read and write to operating system files.
  • Use DBMS_PROFILER to profile and tune PL/SQL programs.
  • Create efficient server-side stored procedures, functions and triggers
  • Track and manage object dependencies
  • Create and maintain simple Oracle packages
  • Describe the new features of Oracle that address the Internet and very large databases
  • Describe the fundamental concepts of the Relational Model of Data and how Oracle adheres to the model
  • Successfully master the material for exam s 1 and 2 of the Oracle Certified Application Developer Program.

 
Click here to view the Course Outline
     
Prerequisite: 

You must be a programmer to benefit from this class. Experience with any procedural language such as Java, C or COBOL is required. You must also know SQL and SQL*Plus. We will not teach you the basics of programming such as logic flow and conditional logic. We will teach you how to do it in PL/SQL.

 
   
     
Duration: 
3 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.