Oracle Database 11g: PL/SQL Fundamentals
School: ONLC Training Centers in Virginia
Venue: Alexandria, Charlottesville, Fairfax, Richmond, Reston, Newport News, Norfolk, Virginia Beach
Tel.: 800-288-8221CHOOSING A SQL & PL/SQL INTERFACE
�USING SQL DEVELOPER
�USING SQL*PLUS
�USING APPLICATION EXPRESS
�USING JDEVELOPER STUDIO
LANGUAGE FEATURES
�UNDERSTANDING PL/SQL
�STRUCTURE OF A PL/SQL PROGRAM BLOCK
�USING PL/SQL FROM SQL*PLUS
DECLARE CLAUSE
�ABOUT THE DECLARE CLAUSE
�DECLARE SIMPLE TYPES
�DECLARE COMPLEX TYPES
�TYPE ... TABLE
�TYPE ... RECORD
BEGIN CLAUSE
�ABOUT THE BEGIN CLAUSE
�PERFORMING DATA MANIPULATION
�LOGI...
Full archival course description>>
|
Oracle PL/SQL Certified Developer Associate
School: CPCC Corporate and Continuing Education
Venue: Charlotte
Tel.: 1.704.330.4223When you have completed this Oracle course, you will be able to:
•Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
•Create and use stored procedures and functions
•Design and use PL/SQL packages to group and contain related constructs
•Create overloaded package subprograms for more flexibility
•Use Oracle supplied PL/SQL packages to generate screen, file, and mail output
•Write dynamic SQL for more coding fl...
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>>
|
