Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Advanced Oracle SQL for End-users

© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices



Key Features

* Review Basic SQL statements.

* See advanced SQL operators.

* Create dynamic SQL for reports.

* Formulate and Tune complex queries.

* Avoid re-parsing of SQL statements.

* Use parallel query to improve performance.


Course Description

Advanced SQL for end users is an intensive four-day course designed to provide Oracle professionals with an in-depth understanding of the Oracle SQL and SQL*Plus.  The student will also learn how to formulate and tune SQL statements for optimal performance.

This intensive three-day advanced SQL for end user course explores all of the advanced concepts and techniques with Oracle SQL.  The course covers advanced SQL query formulation including correlated sub-queries and nested SQL statements.  The students will also learn the SQL*Plus and will learn the tricks for formatting and executing reports that extract data directly from Oracle.

Book Recommended

  Easy Oracle SQL
Get Started Fast Writing SQL Reports with SQL*Plus

John Garmany

Rampant Tech Press

ISBN 0-9727513-7-8


This advanced SQL for end users training course is designed for non-Oracle professionals who have business experience and need to know how to develop SQL queries to answer business-related questions.  There are no formal prerequisites.

Curriculum Design

This advanced SQL for end users training course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle end user training

Learning Objectives

By the end of this advanced SQL for end users training course the student will be able to formulate advanced SQL queries including correlated subqueries and outer joins.  The student will also become familiar with the use of SQL*Plus to create advanced Oracle reports and will know how to tune basic SQL statements.

Advanced Oracle SQL for end-users

© 2007-2016 by Donald K. Burleson

Day 1 – Basic Review of Oracle SQL
Introduction to the course
Introduction to SQL constructs
            Review of Basic SQL statements
            Advanced SQL operators
                        Between operator
                        IN and NOT In operators
                        EXISTS clause
                        Using wildcards in queries (LIKE operator)
DAY 2 – Introduction to Oracle SQL report creation

Creating basic reports
Adjusting line output
Column wrapping
Creating breaks and summaries
Creating dynamic SQL for reports
Adding prompts to queries


DAY 3 - Advanced SQL constructs
Creating and using Views
Creating and tuning SQL subqueries
ISO 99 SQL in Oracle
Creating and using materialized views
Formulating and Tuning complex queries
DAY 4 – Oracle SQL tuning
            Introduction to rule-based optimization
            Introduction to cost-based optimization
            Changing the default optimizer modes
            Finding poor queries (full-table scans)
            Avoiding re-parsing of SQL statements
            Using EXPLAIN PLAN
            Using hints to improve SQL performance
            Using parallel query to improve performance





Please note that while the knowledge gained from this Oracle training may be valuable when preparing for Oracle certification exams, the content of this course is not for Oracle Certification, including the Certified Professional (OCP) or Oracle Certified Associate (OCA) programs.

This is a BC Oracle training course (c) 2002-2016

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational