Oracle Training Oracle Support Development Oracle Apps

 
 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 s
upport
 Remote plans
 Remote
services
 Application Server

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

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

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

Audience

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
Syllabus

© 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
                        Select
                        Project
                        Join
            Advanced SQL operators
                        Between operator
                        IN and NOT In operators
                        Sub-queries
                        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 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.