Course Locations
Anaheim, CA
Atlanta, GA
Austin, TX
Baltimore, MD
Burbank, CA
Calgary, AB
Charleston, SC
Charlotte, NC
Chicago, IL
Columbia, MD
Columbus, OH
Dallas-Ft Worth, TX
Denver, CO
Detroit, MI
Edison, NJ
El Paso, TX
Framingham, MA
Houston, TX
Kansas City, MO
Los Angeles, CA
Minneapolis, MN
Oakbrook, IL
Oklahoma City, OK
Ottawa, ON
Pittsburgh, PA
Toronto, ON
Virtual Classroom
Popular Courses
Project Management, IT Service Management, .NET, SAS, Rexx, ASP, JavaScript, HTML, XML, ColdFusion, Visual Basic, COBOL, Assembler, Java, J2EE, Java Wireless, WebSphere, WebLogic, UNIX, LINUX, AIX, Solaris, z/OS, OS/390, CICS, IMS, VSAM, Easytrieve, AS/400, Oracle, BusinessObjects, SQL, DB2, Crystal Reports
Browse Courses
 |
 |
 |
 |
 |
Course Schedule: | |
Oracle11g Advanced PL/SQL Programming
Summary:
The course provides attendees with the background to develop stored PL/SQL programs including functions, procedures, packages, and triggers. Commonly used predefined packages provided with the Oracle11g DBMS are examined. Discussions include how these packages could be used as part of in-house applications. Additional PL/SQL features such as native dynamic SQL support and autonomous transactions are also presented.Workshops provide students with the opportunity to use predefined packages and evaluate their potential role in an application as well as to write their own stored PL/SQL objects.
Duration:
2 Days/Lecture & Lab
Audience:
This course is designed for programmers and database administrators responsible for the development or maintenance of application systems which access an Oracle database.
Topics:
- Review of PL/SQL Syntax
- PL/SQL on the Server
- Advanced Features
- Predefined Packages
Prerequisites:
Students should have taken the Oracle11g PL/SQL Programming course.
Last Update: May 20, 2013
