 |
 Introduction to Oracle 11g SQL training
Beginning and Advanced Oracle 11g PL/SQL training
Oracle 11g Administration I training
Oracle 11g Administration II training
Oracle Data Warehousing and Warehouse Builder training
Oracle 11g Backup & Recovery training
Oracle 11g Features for Administrators
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 11g PL/SQL Training: Beginning and Advanced Oracle 11g PL/SQL |
Course Number: 572
Duration: 5 days
view class outline
Oracle 11g PL/SQL Training Overview
This Oracle 11g PL/SQL training teaches attendees beginning and advanced Oracle PL/SQL database programming skills.
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 11g PL/SQL Training Prerequisites
No prior experience is presumed.
Hands-on/Lecture Ratio
This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.
Oracle 11g PL/SQL Training Materials
All students receive comprehensive courseware and a related textbook.
Software Needed on Each Student PC
- A complete installation of Oracle 11g
Please contact us for detailed setup instructions if you have purchased this class.
Oracle 11g 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.
- Declare program variables and complex data types.
- Develop logic within PL/SQL program blocks.
- Fetch data from the database into program variables.
- Return program output to users.
- Handle program exceptions.
- Use explicit and implicit database cursors.
- Use the advanced features of nested blocks and subprograms.
- Take advantage of advanced features such as regular expression support and the handling of string literals within program code
|
Oracle 11g PL/SQL Training Outline
- Choosing A SQL & PL/SQL Interface
- Using SQL Developer
- Using SQL*PLUS
- Using Application Express
- Using JDeveloper Studio
- Language Features
- Understanding PL/SQL
- Structure of A PL/SQL Program Block
- Using PL/SQL from SQL*PLUS
- Declare Clause
- About the Declare Clause
- Declare Simple Types
- Declare Complex Types
- Type ... Table
- Type ... Record
- Begin Clause
- About the Begin Clause
- Performing Data Manipulation
- Logic Control & Branching
- Loop
- 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
- 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
- Creating Stored Procedures & Functions
- About Stored Procedures & Functions
- Creating Procedures & Functions
- Executing Procedures & Functions
- Maintaining Stored Procedures & Functions
- Recompiling & Dropping Programs
- Data Dictionary Storage
- Managing Dependencies
- Creating & Maintaining Packages
- About Packages
- Creating Packages
- Advanced Programming Techniques
- Maintaining Packages
- Advanced Cursor Techniques
- Using Cursor Variables
- Using Cursor Expressions
- Using System-Supplied Packages
- Creating Database Triggers
- About Database Triggers
- Statement-Level Triggers
- Row-Level Triggers
- Examples of Triggers
- Instead of Triggers
- EMploying Triggers within an Application
- Maintaining Database Triggers
- Call Syntax
- Trigger Maintenance Tasks
- Show Errors Trigger
- Drop Trigger
- Alter Trigger
- Handling Multiple Triggers for A Table
- Handling Mutating Table Issues
- Implementing System Event Triggers
- What Are System Event Triggers?
- Defining the Scope
- Available System Events
- System Event Attributes
- 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!
|
|
|
|
|
