 |
 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: Introduction to Oracle 10g SQL Programming |
Course Number: 580
Duration: 3 days
view class outline
Oracle 10g SQL Training Overview
In Accelebrate's Introduction to Oracle 10g SQL Programming training, students learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools.
Accelebrate also offers an Advanced 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.
Oracle 10g 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 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.
Oracle 10g SQL Training Objectives
All attendees will learn:
- A summation of relational database principles and an introduction to the Oracle relational database server.
- Using the iSQL*Plus web-based database interface and other traditional interfaces.
- Writing simple SQL queries and moderately complex SQL queries using various join techniques.
- Summarizing, grouping and sorting data.
- Advanced query techniques such as correlated subqueries.
- Developing simple SQL*Plus reports.
- Creating and maintaining database tables.
- Taking advantage of new features such as the use of regular expressions.
- Moving beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others.
- Understanding basic database security and object privileges.
- Using the powerful set of built-in SQL functions.
- Protecting the database and extending the basic data model using declarative constraints.
- Performing advanced SQL queries such as grouping and cube operations and SQL99 join syntax.
- Developing complex SQL*Plus reports and using SQL*Plus scripts.
|
Oracle 10g SQL Training Outline
- Relational Databases & SQL
- About relational databases
- Eelements of SQL
- Using SQL*Plus
- About SQL*Plus
- Using the ms windows SQL*Plus tool
- Using the iSQL*Plus web tool
- Entering commands & syntax
- Building a select statement
- About the select statement
- Selecting columns
- Using alias names
- Building a where clause
- About logical operators
- Equality operator
- Boolean operators
- Null & between operators
- Finding text strings
- In operator
- Ordering the result table
- About the order by clause
- Multiple column sorts
- Specifying the sort sequence
- About null values within sorts
- Using column aliases
- Pseudo columns & functions
- About pseudo columns & functions
- Using ROWID
- Using ROWNUM
- Using the functions
- Using the dual table
- Sessiontimezone function
- Joining tables
- About joins
- Inner join
- Reflexive join
- Non-key join
- Outer join
- Using set operators
- About the set operators
- Set operator examples
- Summary functions
- About summary functions
- Summary functions with distinct
- Using subqueries
- About subqueries
- Standard subqueries
- Correlated subqueries
- Creating & selecting groups
- About summary groups
- Finding groups within the base tables
- Selecting data from the base tables
- Selecting groups from the result table
- Sql*Plus commands
- About SQL*Plus commands
- More about script files
- Invoking operating system commands
- Saving session output
- Build simple SQL*Plus reports
- About the SQL*Plus report features
- Session output with set
- Format column output with column
- Defining report breaks with break
- Produce subtotals with compute
- Sql data definition language
- About SQL DDL
- Create table statement
- Alter table statement
- Drop table statement
- Supportive statements
- Sql data manipulation language
- About SQL DML
- About the insert statement
- About the delete statement
- About the update statement
- About transactions
- Truncate table
- Complex table references
- 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!
|
|
|
|
|
