Training Resources
Accessibility
Web Development
Active Server Pages Introduction
Adobe / Macromedia Web
Programming
Visual Studio 2005 (.NET 2.0):
VB.NET Application Development
ADO.NET Data
Programming in VB
C#.NET Application Development
ADO.NET Data
Programming in C#
Visual Studio 2008 (.NET 3.5):
VB.NET Application Development
C#.NET Application Development
What's New in VS2008
(2-day courses):
VB.NET Application Development
C#.NET Application Development
Databases
Professional Courses
Project Management
with
Microsoft Project
Adobe
Microsoft SharePoint
Technical
Geographic (GIS)
ESRI ArcGIS 9.2:
ESRI ArcGIS 9.3:
Microsoft Office
Moving to Microsoft Office 2007
Training Resources
Programming with Oracle PL/SQL – Introduction
2 day course
The Oracle PL/SQL language provides for programming logic features not contained within SQL. The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available. Topics to be covered include understanding the environment and context in which PL/SQL operates, declaring program variables and complex data types, developing logic within PL/SQL program blocks, fetching data from the database into program variables, returning program output to users, handling program exceptions, using explicit and implicit database cursors, and using the advanced features of nested blocks and subprograms.
Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)
- PL/SQL Language Features
- DECLARE Clause
- BEGIN Clause
- EXCEPTION Handling
- Explicit Cursors
- Programming with Nested Blocks
- Declared Subprograms