Oracle SQL and SQL*Plus for End Users

Course Number:  581-JK
Recommended Duration:  3 days

Intended Audience
People who will use Oracle's Relational Data Base and its various tools to solve queries and simple business problems.

Course Overview
Introduces non-technical personnel to Oracle, SQL, and SQL*Plus.  There are twelve machine exercises and two optional exercises.

Course appropriate for Oracle 10g, Oracle 9i, or Oracle8i. Also suitable for Oracle8 or Oracle 7 shops.

Objectives
Introduces participants to the Oracle database and its most commonly used tools.  Numerous hands-on exercises will provide practice using SQL, and SQL*Plus.  SQL is used to create, query, and modify database tables and views. SQL and database efficiency are emphasized while showing how SQL is used to solve queries.

Prerequisites
No prior knowledge of SQL or Oracle is required.  Some familiarity with computer terminals (or PCs ) is helpful.

Topics

• Relational database concepts

• SQL syntax and usage

• SELECT statements

• Joins

• Nested SQL queries

• Table / View / Synonym creation

• INSERT, UPDATE, DELETE, GRANT, REVOKE