Oracle PL/SQL Programming
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Develop efficient PL/SQL programs to access Oracle databases
Create stored procedures and functions for maximum reuse and minimum code maintenance
Design modular applications using packages
Manage data retrieval for front-end applications
Bulk bind collections to increase the speed of data movement operations
Invoke native dynamic SQL to develop high-level abstract code
Course Benefits
The Oracle PL/SQL language—a flexible procedura...
Full archival course description>>
|
Oracle 10g PL/SQL Programming
School: New Horizons Boston
Venue: Boston
Tel.: 781-487-3200This class will teach you how to write efficient and scalable PL/SQL programs to create database-intensive PL/SQL applications. You will learn the critical and fundamental aspects of PL/SQL language.
Outline :
Lesson 1: Introduction to PL/SQL
What is PL/SQL? Why Use PL/SQL? PL/SQL Program Structure Anonymous Blocks Compile Errors Sending Output to SQL*Plus Introduction to Procedures Procedure Compile Errors Procedure Compile Warnings (10g) Introduction to Functions Introduction to...
Full archival course description>>
|
Oracle Database 11g: Advanced PL/SQL
Format: Online
School: ExitCertified USA
Venue: Houston, Las Vegas, Philadelphia, Phoenix, New York City, Sacramento, San Francisco, San Jose
Tel.: 1.800.803.3948In this course, students learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, and collections, students learn to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered.
Students learn to write PL/...
Full archival course description>>
|
PL/SQL on Oracle 11g
Format: Online
School: Webucator
Venue: Jamesville
Tel.: 877-WEBUCATE (877-932-8228)
PL/SQL is Oracle’s extension language for standard SQL.
In this PL/SQL training class, students who already know SQL, learn to use PL/SQL to write sophisticated queries against an Oracle database.
Class Goals
•Understand the PL/SQL Development Environment.
•Learn the basics of the PL/SQL language.
•Learn to declare and work with variables.
•Learn to use conditionals and loops in PL/SQL.
•Learn to handle and create user-defined exceptions.
•Learn to ...
Full archival course description>>
|
Oracle PL/SQL
Format: Online
School: Webucator
Venue: Jamesville
Tel.: 877-WEBUCATE (877-932-8228)
PL/SQL is Oracle’s extension language for standard SQL.
In this PL/SQL training class, students who already know SQL, learn to use PL/SQL to write sophisticated queries against an Oracle database.
Class Goals
•Understand the PL/SQL Development Environment.
•Learn the basics of the PL/SQL language.
•Learn to declare and work with variables.
•Learn to use conditionals and loops in PL/SQL.
•Learn to handle and create user-defined exceptions.
•Learn to ...
Full archival course description>>
|
