Oracle 10g PL/SQL Programming

Software Training Academy
Toronto, Ontario, Canada

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

Course Description:

'' This class will teach you how to write efficient and scalable PL/SQL programs to create database-intensive PL/SQL applications.



Learning how to create efficient, scalable PL/SQL programs is an important objective of this course. To meet that objective, the course includes instruction on such things as the proper use of bind variables, bulk processing, pipelining, benchmarking different formulations of a routine and profiling PL/SQL programs to identify the code that should be tuned.



Overviews of relational concepts and Oracle architecture are also provided.



This class is highly customizable to your specific training requirements.

Learning Objectives

· Code efficient, scalable PL/SQL programs that include common programming constructs such as data-typing, variable assignment, flow control, cursor handling, bulk processing, array processing and error handling

· Create PL/SQL stored procedures that accept and return values or sets of values

· Manage stored procedure dependencies and privileges

· Create PL/SQL functions, including powerful table functions and pipelined table functions

· Create database triggers for auditing, complex business rule support, simple replication and more

· Create and maintain simple Oracle packages

· Use the UTL_FILE package to read and write to operating system files.

· Use the UTL_MAIL package to send email from an Oracle database

· Use the DBMS_PROFILER package to profile and tune PL/SQL programs

· Do simple benchmarking of PL/SQL code with the DBMS_UTITLITY package

Course Duration: 4 days

...''

Phone:1-888-896-7852

School Address:

Toronto Star Building
1 Yonge Street, Suite 1801
Downtown Toronto
Ontario, Canada - M5E 1W7

Jobs & Resumes: Toronto
Houses & Roommates: Toronto
Travel Agencies: Toronto

Search other schools for Oracle 10g PL/SQL Programming training resources.

Jakarta Struts
Java Development for Secure Systems
Java Persistence with Hibernate
Java Foundation Classes (Swing) Java 5.0
Java Servlets
JSP
JDBC
Oracle 10g Advanced SQL
Oracle 10g Introduction to SQL
Oracle Applications Using ADO.NET and C#
J2EE
Visual Basic for Applications (VBA)
Securing Java Web Applications
SQL Server 2005 Additional Topics
SQL Server 2005 Analysis Services (SSAS)
SQL Server 2005
SQL Server 2005 Integration Services (SSIS)
SQL Server 2005 Reporting Services (SSRS)

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: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.