KT-5526 Advanced SQL Queries Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

Advanced SQL Queries


This course will provide experienced Oracle developers the advanced skills necessary to design and code the complex queries and applications required to solve enterprise business problems. You will learn to incorporate many advanced techniques such as the data warehouse functions CUBE and ROLLUP, DECODE, ANSI-compliant inner and outer joins, CONNECT BY (hierarchical queries), SET operations, correlated subqueries and other advanced subquery techniques. Oracle9i features such as flashback query, external tables and MERGE will also be covered.

You will also learn the transaction control rules implemented by Oracle, and how to work within those rules.

Finally, alternative table structures such as views, materialized views and temporary tables will be presented.

Hands-on workshops will reinforce code examples presented.

Audience: Software developers, Programmers, Application Designers.

Objectives: After successfully completing this course, you wil be able to:

Design, code and test the most efficient query for a given business problem 

Understand and code for Oracle's transaction control rules 

Effectively incorporate the following techniques into your queries 

  • Multi-level grouping
  • CUBE and ROLLUP data warehouse functions
  • Scalar (row) functions DECODE function
  • Advanced join techniques include inner, outer and cross joins
  • Ranking functions
  • Complex subqueries

Make use of the new Oracle9i features such as:

  • External Tables
  • Flashback Query
  • Merge ("upsert") operations

Click here to view the Course Outline

Prerequisites: KT-5531 Introduction to SQL & SQL*Plus Basics and KT-5533 Oracle Foundation: Introduction to PL/SQL

2 Days  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.