Home
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
Analysis
Design
Implementation
Oracle Support

SQL Tuning
Security
Oracle UNIX
Oracle Linux
Monitoring
Remote support
Remote plans
Remote services
Application Server
Applications
Oracle Forms
Oracle Portal
App Upgrades
SQL Server
Oracle Concepts
Software Support
Remote Support
Development
Implementation

Consulting Staff
Consulting Prices
Help Wanted!

Oracle Posters
Oracle Books
Oracle Scripts
Ion
Excel-DB

Don Burleson Blog

Getting started with SQL for Oracle

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

Click here for on-site course prices

Optional supplemental mentoring

* Learn about SQL constructs.

* Use SQL*Plus.

* Learn advanced SQL operators.

* Use aggregation in SQL.

* Understand SQL Tuning.

Getting started with SQL for Oracle is an intensive three-day course designed to provide Oracle professionals with an in-depth understanding of the Oracle SQL dialect and how to formulate and tune SQL statements for optimal performance.

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

John Garmany

Rampant Tech Press

ISBN 0-9727513-7-8

This course is designed for practicing Oracle professionals who have basic experience with SQL and the use of a relational database. Prior experience with Oracle is not required, but experience using SQL with a relational database is highly desirable.

This course was designed by Donald K. Burleson, an acknowledge leader in Oracle database administration. Author or more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson has over a decade of real-world DBA experience in Oracle features and shares his Oracle secrets in this intense Oracle SQL training.

Learning Objectives

By the end of this course the student will be able to formulate basic and advanced SQL queries including correlated subqueries and outer joins. The student will also become familiar with Oracle SQL and will be able to use the EXPLAIN PLAN utility to view SQL execution plans.

Getting Started with Oracle SQL
Syllabus

Introduction to SQL constructs

Review of Basic SQL statements
Select, Project, Join
Describing Oracle tables
Restricting row returns

Using SQL*Plus

Creating basic reports

Using the set commands
Column wrapping

Creating breaks and summaries

Adding prompts to queries

Joining Oracle tables

Equi-join

Outer join

Hiding joins by creating views

Using IN, NOT IN, EXISTS and NOT EXISTS
Subqueries
Exercise – write a subquery

Correlated subquery
Non-correlated subqueries

Advanced SQL operators

Between operator
IN and NOT In operators
Sub-queries
EXISTS clause
Using wildcards in queries (LIKE operator)

Aggregation in SQL

Count(*)
Sum
Avg
Min and max
Using the group by clause

SQL access methods

Review of Basic joining methods
Merge join
Hash Join
Nested Loop join
Advanced SQL operators
Between operator

SQL Tuning

Introduction to rule-based optimization
Introduction to cost-based optimization
Collecting table and index statistics
Using column histograms
Changing the default optimizer modes
Using TKPROF
Using SQL*Trace
SQL reusability within the library cache
Table high-water mark
Table striping and table partitions
Using EXPLAIN PLAN
Interpreting EXPLAIN PLAN Output
Using indexes to improve performance
Identifying full-table scans
Re-writing SQL queries
Using hints to improve SQL performance
Using parallel query to improve performance
Tuning sub-queries

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