KT-3091 Introduction to Oracle 10g and SQL Training Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

Introduction to Oracle 10g and SQL Training


  • Learn by Doing!
  • Online, hands-on, completely Instructor-Led!
  • VoIP (or telephone), email and chat access to your instructor throughout class.
  • Includes 297 page detailed course book, workshop solutions and sample code.
  • Certificate of Completion.
  • Satisfaction 100% Guaranteed.

This class teaches you PL/SQL fundamentals and how to create database-intensive PL/SQL applications by writing efficient, scalable PL/SQL programs. Introduces PL/SQL including structure, concepts and language fundamentals; using PL/SQL and SQL including Cursors and Bulk Processing; Stored Procedures; Functions; Error handling; Packages; DML Triggers; Trace and Tune; file input/output using UTL_FILE and sending email with UTL_MAIL.

This 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.

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.

Hands-on workshops constitute approximately 50% of the class. Overviews of relational concepts and Oracle architecture are also provided. As with all of our courses, this class is highly customizable to your specific training requirements.

Click here to view the Course Outline

You must possess strong programming skills to benefit from this class. (We will not teach you the basics of programming such as logic flow and conditional logic. We will, however, teach you how to do it efficiently in PL/SQL.) Experience with a procedural language (e.g. Java, C or COBOL), SQL and SQL*Plus is required.


3 Days  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.