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