ASP.NET, VB.NET, and C# Training Classes     
Accelebrate delivers SharePoint , ASP.NET, SQL Server, Java, and other training courses in the USAAccelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Canada     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the UK     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Ireland     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the Netherlands     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses internationally  
1 877 849 1850   0808 234 2132   1 800 550 311   0 800 022 6730   +1 678 648 3113  
Microsoft and .NET TrainingSQL Server TrainingSharePoint TrainingJava TrainingAdobe TrainingDatabase and Reporting TrainingXML, JavaScript, and Other TrainingWeb/Application Server Training
HomeAboutContact Us 


Please contact us
for GSA pricing.

GSA - Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
GS-35F-0307T



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Edmonton & Calgary, Alberta
  • Phoenix, Arizona
  • Tucson, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Amsterdam, The Netherlands / Brussels, Belgium
  • Vancouver, British Columbia
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • San Diego, California
  • Orange County / Los Angeles, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida 
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Boise, Idaho
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Wichita, Kansas
  • Lexington / Louisville, Kentucky
  • Baton Rouge/New Orleans, Louisiana
  • Portland, Maine
  • Hagerstown & Frederick, Maryland
  • Annapolis / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Ann Arbor / Detroit, Michigan
  • Grand Rapids, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • St. Louis, Missouri
  • Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Fredericton / Moncton / Saint John, New Brunswick
  • Albuquerque, New Mexico
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • Albany, New York
  • Buffalo, New York
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • San Juan, Puerto Rico
  • Providence, Rhode Island
  • Saskatoon / Regina, Saskatchewan
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Spartanburg & Greenville, South Carolina
  • Knoxville, Tennessee
  • Memphis / Nashville, Tennessee
  • Houston, Texas
  • El Paso, Texas
  • San Antonio / Austin, Texas
  • Dallas, Texas
  • Salt Lake City, Utah
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Charleston, West Virginia
  • Madison / Milwaukee, Wisconsin

 

Oracle SQL Training: Introduction to Oracle 11g SQL Programming

Print This Outline
E-mail This Outline
Get A Quote
Course Number: ORC-200
Duration: 5 days
view class outline

Oracle 11g SQL Training Overview

In Accelebrate's Introduction to Oracle 11g SQL Programming training, students learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will also be introduced to Oracle® 11g database features and tools.

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. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, 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/?action=category&page=oracle.

Oracle 11g 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 SQL Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

  • A complete installation of Oracle 11g
  • Oracle SQL Developer

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

Oracle 11g SQL Training Objectives

All attendees will learn how to:

  • Write SELECT statements
  • Use Scalar functions
  • Join tables
  • Use aggregate functions
  • Manipulate data
  • Create and use transactions
  • Use data definition and control statements

Oracle 11g SQL Training Outline

  • Relational Databases & SQL
    • About Relational Databases
    • Elements of SQL
  • Choosing A SQL & PL/SQL Interface
    • About Database Connections
    • About Bind Variables
    • Using SQL Developer
    • Using SQL*PLUS
    • Using Application Express
  • Building A Statement
    • About the Select Statement
    • Using Alias Names
  • Restricting Data with the Where Clause
    • About Logical Operators
    • Equality Operator
    • Boolean Operators
    • Null & Between Operators
    • Is [Not] Null Operator
    • [Not] Between Operator
    • Finding Text Strings
    • [Not] Like Operator
    • Regexp_Like()
    • In Operator
  • Sorting Data with the Order By Clause
    • About the Order By Clause
    • Multiple Column Sorts
    • Specifying the Sort Sequence
    • About Null Values within Sorts
    • Using Column Aliases
  • Pseudo Columns & Functions
    • Using Rowid
    • Using Rownum
    • Using the Functions
    • Sysdate
    • User & Uid
    • Using the Dual Table
    • Sessiontimezone Function
  • Joining Tables
    • About Joins
    • Inner Join
    • Reflexive Join
    • Non-Key Join
    • Outer Join
  • Using the Set Operators
    • About the Set Operators
    • Set Operator Examples
  • Summary Functions
    • About Summary Functions
    • Summary Functions with Distinct
  • Using Sub-Queries
    • About Sub-Queries
    • Standard Sub-Queries
    • Correlated Sub-Queries
  • Aggregating Data within Groups
    • About Summary Groups
    • Finding Groups within the Base Tables
    • Selecting Data from the Base Tables
    • Selecting Groups from the Result Table
  • Build Simple SQL*PLUS Reports
    • Format Column Output with Column
    • Defining Report Breaks with Break
    • Produce Subtotals with Compute
  • Use Data Definition Language to Create & Manage Tables
    • Create Table Statement
    • Not Null
    • Default
    • Alter Table Statement
    • Drop Table Statement
    • Supportive Statements
    • Describe
    • Rename
  • Use Data Manipulation Language to Manipulate Data
    • About the Insert Statement
    • About the Delete Statement
    • About the Update Statement
    • About Transactions
    • Rollback
    • Commit
    • Savepoint
    • Set Transaction
    • Truncate Table
    • Complex Table References
  • SQL99 Join Techniques
    • Cross Joins
    • Natural Joins
    • Inner Joins
    • Outer Joins
    • Anti Joins
    • Using Named Subqueries
  • Enhancing Groups with Rollup & Cube
    • Using Rollup
    • Using Cube
  • Using the Case Expression
  • SQL Functions: Character
    • String Formatting Functions
    • Ascii Codes Functions
    • Pad & Trim Functions
    • String Manipulation Functions
    • String Comparison Functions
    • Phonetic Search Functions
  • SQL Functions: Numeric
    • About the Numeric Functions
    • Null Value Functions
  • SQL Functions: Date
    • Date Format Functions
    • Date Arithmetic Functions
  • Database Objects: Relational Views
    • About Database Objects
    • About Relational Views
    • Updating View Data
    • Maintaining View Definitions
    • Alter View
    • Drop View
  • Database Objects: Data Dictionary Storage
    • About the Data Dictionary
    • Object-Specific Dictionary Views
    • User_Updatable_Columns
    • Understanding the Data Dictionary Structure
  • Database Objects: Indexes
    • About Indexes
    • Use B-Tree Indexes
  • Database Objects: Other Objects
    • More About Creating Tables
    • About Sequences
    • Alter Sequence & Drop Sequence
    • Alter Sequence
    • Drop Sequence
    • About Synonyms
    • Drop Synonym
    • Create Schema Authorization
  • Database Objects: Security
    • User Passwords
    • Object Security
  • Data Using Constraints
    • About Constraints
    • Not Null Constraint
    • Check Constraint
    • Unique Constraint
    • Primary Key Constraint
    • References Constraint
    • Defining Constraints On Existing Tables
  • Managing Constraint Definitions
    • Renaming & Dropping Constraints
    • Enabling & Disabling Constraints
    • Deferred Enforcement
    • Set Constraints
    • Handling Constraint Exceptions
    • Constraints with Views
    • Data Dictionary Storage
  • Advanced SQL*PLUS Reports
    • Break
    • Compute
    • Column
    • Ttitle & Btitle
  • Conclusion

© 2008 Sideris Courseware Corporation

 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.

Oracle® is a registered trademark of the Oracle Corporation 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.

 
Request Information for Group Training at Your Site   Request Information for Group Training at Your Site
 
Accelebrate®
Focuses on You!


Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

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

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

             
               

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

“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 | Albany, NY | 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