 |
 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 SQL Training: Oracle 10g Advanced SQL Programming |
Course Number: 581
Duration: 3 days
view class outline
Advanced Oracle 10g SQL Training Overview
In Accelebrate's Oracle 10g Advanced SQL Programming training, students develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle datatypes, learn analysis and tuning techniques to increase SQL performance, and master advanced features of Oracle SQL for large data sets and data warehouses.
Accelebrate also offers an Introduction to Oracle 10g 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.
Advanced Oracle 10g SQL Training Prerequisites
Accelebrate's Introduction to Oracle 10g SQL Programming course or equivalent experience.
Hands-on/Lecture Ratio
This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.
Advanced Oracle 10g 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.
Advanced Oracle 10g SQL Training Objectives
All attendees will learn how to:
- Use the SQL99 join syntax. Also, performing advanced SQL queries using techniques such as grouping and cube operations.
- Move beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others.
- Understand basic database security and object privileges.
- Use the powerful set of built-in SQL functions.
- Protect the database and extending the basic data model using declarative constraints.
- Develop complex SQL*Plus reports and using SQL*Plus scripts.
|
Advanced Oracle 10g SQL Training Outline
- SQL99 join techniques
- cross joins
- natural joins
- inner joins
- outer joins
- anti joins
- using named subqueries
- Enhancing groups with rollup & cube
- Using the case expression
- SQL99 functions: character
- what are the SQL99 functions?
- character functions
- about greatest(), least()
- SQL99 functions: numeric
- SQL99 functions: date
- date format functions
- date arithmetic functions
- Database objects: relational views
- about relational views
- updating view data
- maintaining view definitions
- alter view
- drop view
- Database objects: data dictionary storage
- user_updatable_columns
- understanding the data dictionary structure
- Database objects: indexes
- about indexes
- use B-TREE indexes
- Database objects: other objects
- creating an application schema
- more about creating tables
- defining sequences
- alter sequence & drop sequence
- alter sequence
- drop sequence
- about synonyms
- drop synonym
- create schema authorization
- Database objects: security
- user id passwords
- object security
- Data integrity using constraints
- not null constraint
- check constraint
- unique constraint
- primary key constraint
- references constraint
- Managing constraint definitions
- managing constraints
- renaming & dropping constraints
- enabling & disabling constraints
- deferred enforcement
- set constraints
- handling constraint exceptions
- data dictionary storage
- Optional – advanced SQL99*plus reports
- break
- compute
- column
- TTITLE & BTITLE
- Optional – building SQL99*plus scripts
- using SQL99*plus variables
- define & undefine
- accept
- prompt
- pause
- 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!
|
|
|
|
|
