back to Course Categories | back | print
Oracle10g Advanced Queuing          

Duration: 3 days

Description 
Overview This introductory class to Advanced Queuing will introduce Oracle developers to the fundamental concepts of Advanced Queuing in Oracle. Attendees will learn the key AQ packages such as DBMS_AQADM and DBMS_AQ will be covered. The steps necessary for creating queue tables, creating queues, managing queues, as well as enqueuing and dequeuing will be covered.

Topics

  • Advanced Queuing in Oracle
  • Advanced Queuing concepts and terminology
  • Introduction to object types
  • Introduction to XML in Oracle
  • DBMS_AQADM package
  • DBMS_AQ package
  • Creating and managing queue tables
  • Creating and managing queues
  • Starting and stopping queues
  • Setup and payloads
  • Different types of payloads
  • Privileges and permissions for advanced queuing
  • Subscribers
  • Propagation
  • Putting messages in the queue
  • Enqueuing options
  • Taking messages out of the queue
  • Dequeuing options
  • Messaging workshops

Prerequisites

  • A solid understanding of SQL and PL/SQL is required.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design