Oracle SQL Training: Oracle 10g Advanced SQL Programming

Course Number: ORC-102
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. 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.

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

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