PL/SQL: Procedures and Functions

Information Management Systems Inc.
Atlanta, GA, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Audience

Database administrators, system administrators, and application developers who are using PL/SQL version 2 for the first time, and experienced developers who are upgrading from a previous PL/SQL version or another 3GL programming language.
Prerequisites

The course Relational Principles; the courses on SQL*Plus; and the courses PL/SQL: Fundamentals and PL/SQL: Exceptions and Scripts.
Course Aim

To provide the student with a detailed understanding of modular programming in PL/SQL using stored procedures and functions.
Learning Objectives

Describe the user-defined composite data-structures available in PL/SQL
create, call, and pass parameters to a PL/SQL procedure
create, call, and pass parameters to a PL/SQL function.
Topics

Modular programming overview
The TABLE dataype
The RECORD dataype
Hands-on: A sample program
Creation and execution
Passing in parameters
Passing out parameters
Hands-on: A sample program
Creation and execution
Source code
Hands-on: A sample program.
...''

Phone:404 329-6260 or 888 812 9028

School Address:

2470 Cheshire Bridge Road
Atlanta, GA
United States - 30324
Phone : 404 329-6260 or 888 812 9028
Fax : 404 329-6365
Email : cservice@imsinc.com

Jobs & Resumes: Atlanta
Houses & Roommates: Atlanta

Perl Fundamentals
UNIX: Using the Shell
PISIP: Planning and Implementing a Secure Internet Presence
UNIX: Using Editors
PKIDC: Public Key Infrastructure Courese: PKI & Digital C
UNIX: The User Environment
PKTEL: Building Cisco Packet Telephony Networks v1.0
UNIX: Shell Programming
PL/SQL: Packages and Triggers
UNIX: Process and Data Utilities
UNIX: Overview
Planning and Managing Business Strategy: Bases of Competitive Advantage
UNIX: Exploring the Filesystem
Understanding and Applying Internet Concepts: Connecting to the Net
Planning and Managing Business Strategy: Cultrue and Leadership
Troubleshooting LANs
Planning and Managing Business Strategy: Diversification
Top Gun IIII: Network Management Interoperability
Planning and Managing Business Strategy: Implementing Strategy

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.