ORACLE8i ACCELERATED INTRODUCTION TO ORACLE

Duration: 1 day

Accelerate your understanding of Oracle SQL*Plus and various utilities.

Print Outline in PDF format

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:

1. SQL*Plus basics

2. WHERE & ORDER BY clause

3. Functions

4. Group functions

5. Join condition

6. Subquery

7. SQL*Plus reporting

Unique Training Solutions for Unique Clients - Expanding skills today to meet the challenges of tomorrow