On-line training course catalogue

Oracle9i: SQL for End Users

Type of course: Classroom

Course details

Fee	£840
Days	2
Course code	ORSQLEU

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note that Oracle courses running at London training centres are subject to a 5% surcharge.

In this course, delegates learn about relational principles of an Oracle database. The class also covers how to query data and how to use iSQL*Plus to format query output.

Prerequisites

Delegates should be familiar with data processing concepts and techniques. Graphical user interface (GUI) experience is also required.

Delegates will learn how to

• Use iSQL*Plus to execute SQL statements
• Retrieve data in an Oracle database
• Describe the relational aspects of Oracle database management systems

Outline

RELATIONAL PRINCIPALS AND ORACLE CONCEPTS

Describing the lifecycle development phases; Discussing the theoretical and physical aspects of a relational database; Describing the Oracle implementation of the RDBMS and ORDBMS; Describing the features of Oracle8i; Describing new features of Oracle9i; Describing how SQL is used in the Oracle product set

WRITING BASIC SQL STATEMENTS

Listing the capabilities of SQL SELECT statements; Executing a basic SELECT statement; Differentiating between SQL statements and iSQL*Plus statements

RESTRICTING AND SORTING DATA

Limiting the rows retrieved by a Query; Sorting the rows retrieved by a Query

SINGLE-ROW NUMBER AND CHARACTER FUNCTIONS

Describing the various types of functions available in SQL; Using character and number functions in SELECT statements

SINGLE-ROW DATE AND CONVERSION FUNCTIONS

Using SYSDATE in conjunction with SELECT statements; Arithmetic operations with dates; Describing conversion functions available in SQL; Using date functions in SELECT statements

DISPLAYING DATA FROM MULTIPLE TABLES

Writing SELECT statements using equality and nonequality joins to access data from more than one table; Describing the cartesian product; Joining a table to itself; Natural join and cross join

AGGREGATING DATA USING GROUP FUNCTIONS

Identifying the available group functions; Describing the use of group functions; Using the GROUP BY clause to group data

WRITING SUBQUERIES

Describing the types of problems that subqueries can solve; Defining subqueries; Listing the types of subqueries; Writing single-row and multiple-row subqueries

ISQL*PLUS

Producing queries that require an input variable; Customising the iSQL*Plus environment; Producing more readable output; Creating and executing script files