Advanced Oracle SQL
for End-users
© 2007-2016
by Burleson Corporation
* 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.
|
|
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.
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.
|
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
|
