|
(703)246-9100 Northern Virginia (804)285-5830 Central Virginia (757)420-3810 Tidewater Area (800)294-7497 Toll Free (804)285-3722 Fax |
ORACLE8i ACCELERATED INTRODUCTION TO ORACLE
Duration: 1 day
Accelerate your understanding of Oracle SQL*Plus and various utilities.
Course Description:
Building on your existing knowledge of SQL you will be provided with the knowledge required to step into the Oracle world. You will work with SQL*Plus and various Oracle utilities.
You can learn to…
Format reports using the SQL*Plus commands
Understand Oracle Security
Export and Import Tables
Load Tables Using SQL*Loader
Who Needs to Attend:
Application Designers, Developers, Database Administrators and End Users
Prerequisites:
Relational Database Theory, SQL knowledge, Windows OS.
Course Content:
SQL BASICS & SQL*PLUS
Understanding the difference between SQL*Plus and PL/SQL
Invoking and Leaving SQL*Plus
Entering & Executing commands
Simple queries
The SQL buffer, buffer commands
SQL*Plus default output
Basic SQL*Plus commands including – COLUMN, SET, SHOW
The SELECT command
Column aliases
THE WHERE & ORDER BY CLAUSE
The WHERE and ORDER BY clauses
SINGLE ROW FUNCTIONS
Single row, Large object , and Conversion functions
Date and Numeric format models
GROUP FUNCTIONS
Group functions, The GROUP BY and The HAVING clauses
THE JOIN CONDITION
The join condition, Outer join
Table aliases, Set operators
SUBQUERY
Subquery
SQL*PLUS REPORTING
SQL*Plus report writing commands
Column command, Titles, System variables
A master-detail report with title and column commands
Control breaks, Computing aggregate amounts
Using set to customize the SQL*Plus environment
Types of variables, Using variables in SQL*Plus
Course Labs:
SQL*Plus basics
WHERE & ORDER BY clause
Functions
Group functions
Join condition
Subquery
SQL*Plus reporting
Unique Training Solutions for Unique Clients - Expanding skills today to meet the challenges of tomorrow