|
Length:
3 Days |
|
Audience:
Programmers, Analysts, Database Administrators,
and Users who must access data in an Oracle
database. |
|
Prerequisites:
Oracle8i Concepts and Facilities.
|
|
Overview:
This course
provides a thorough introduction to SQL
(Structured Query Language), the language used
to work with relational databases. From the
examination of single table operations to the
complexities of accessing multiple tables using
joins or subqueries, this course provides the
basic skills needed to use SQL. Participants
will also learn how to use SQL*Plus, Oracle's
command environment for entering, editing and
running SQL statements to interact with the
database and to produce reports. Workshops
including "real world" coding examples serve to
reinforce the material presented in class.
|
|
Topics Covered:
Preparing
for SQL Development
-
RDBMS
Concepts
-
Case Study
-
Development
Environment
-
Oracle8i
Data Dictionary
-
USER, ALL, and
DBA views
|
Introduction to SQL
Language
-
CREATE
TABLE
-
Basic
DML Commands
Retrieval
Using SELECT
-
SELECT
Basics
-
Using
WHERE to Restrict Results
-
GROUP BY
and Aggregate Data
MIN,
MAX, AVG, SUM, and COUNT
Basic Joins and
Subqueries
Working
With Data
-
Advanced Joins and Subqueries
-
Equi-Join, Outer Join, Theta
Join
Correlated
Subquery
-
DML
and Transaction Control
INSERT,
UPDATE, DELETE
COMMIT and ROLLBACK
Oracle8i Developer
Utilities and Features
Export and Import of Data
Other
Oracle8i Topics
Oracle8
Security Features
|
|
|
|
|
