Getting started with SQL for
Oracle
© 2007-2009
by Burleson Consulting
* 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.
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
© 2007-2009 by Donald K.
Burleson
Introduction to SQL
constructs
-
Review of Basic SQL
statements
-
Select, Project,
Join
-
Describing Oracle
tables
-
Restricting row
returns
Using
SQL*Plus
-
Using the
set commands
-
Column
wrapping
-
Creating
breaks and summaries
-
Adding
prompts to queries
Joining Oracle tables
-
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
|
This is a BC Oracle training
course (c) 2002-2009
|
