Database and Reporting Training     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
Crystal Reports Training * MySQL Training * Oracle Training * SQL Server Training * Live Online Training


 * Introduction to Oracle 10g SQL Programming Training
 * Oracle 10g Advanced SQL Programming Training
 * Introduction to Oracle 10g PL/SQL Programming Training
 * Oracle 10g Advanced PL/SQL Programming Training
 * Oracle 10g Database Administration Training
 * Oracle 10g Real Application Clusters for Administrators Training



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary Database & Reporting Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour database or reporting training seminar. For more details, please contact us today.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

 

Oracle PL/SQL Training: Introduction to Oracle 10g PL/SQL Programming

Print This Outline
E-mail This Outline
Get A Quote
Course Number: 584
Duration: 3 days
view class outline

Oracle 10g PL/SQL Training Overview

In Accelebrate's Introduction to Oracle 10g PL/SQL Programming training, students write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. They learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.

Accelebrate also offers an Advanced Oracle 10g PL/SQL training class.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/database.htm.

Oracle 10g PL/SQL Training Prerequisites

A solid understanding of SQL and 3GL programming is required. It is recommended the student understand Oracle 10g SQL features.

Hands-on/Lecture Ratio

This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.

Oracle 10g PL/SQL Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

  • A complete installation of Oracle 10g

Please contact us for detailed setup instructions if you have purchased this class.

Oracle 10g PL/SQL Training Objectives

All attendees will learn how to:

  • Understand the environment and context in which PL/SQL operates.
  • Consider the advantages and benefits of PL/SQL within a database environment.
  • 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.
  • Using the advanced features of nested blocks and subprograms.
  • How to take advantage of new features such as regular expression support and the handling of string literals within program code.

Oracle 10g PL/SQL Training Outline

  • Language features
    • Understanding PL/SQL
    • Structure of a PL/SQL program block
    • PL/SQL from interactive tools
    • Generating output within SQL*Plus
  • Declare clause
    • About the declare clause
    • Declare simple types
    • Complex types
    • Type ... Table
    • Type ... Record
  • Begin clause
    • About the begin clause
    • Performing data manipulation
    • Logic control & branching
    • if-then-else
    • Case
  • Exception clause
    • About the exception clause
    • Isolating the specific exception
    • Pragma exception_init
    • SQL%rowcount & select...into
  • Explicit cursors
    • About explicit cursors
    • Advanced cursor techniques
  • Advanced programming: nested blocks
  • Advanced programming: declared subprograms
  • Introducing database program units
    • About database program units
    • Types of PL/SQL program units
    • Types of stored program units
    • Advantages of using stored program units
    • Development tools
  • Creating stored procedures & functions
    • About stored procedures & functions
    • Creating procedures & functions
    • Executing procedures & functions
    • Handling compilation errors
  • Maintaining stored procedures & functions
    • Recompiling & dropping programs
    • Data dictionary storage
    • Managing dependencies
  • Conclusion

© 2008 Sideris Courseware Corporation

 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.

Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.

 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!



VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK

About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Database and Reporting Training