Oracle SQL and SQL*Plus
- Recommended Duration:
- 3 Days
- Version
- Oracle 11g. (Suitable for Oracle 10g, Oracle9i, or Oracle8i). Courses for Oracle8 or Oracle7 also available.
- Benefits
- Participants will be introduced to the Oracle database, SQL, and the SQL*Plus tool. Several exercises use SQL to query the database and create simple reports using the SQL*Plus tool. the participant will also learn how to work with views and synonyms.
- Audience
- Personnel needing to create and execute queries against the Oracle database using SQL*Plus. No programming background or experience is necessary, although a technical orientation is helpful.
- Prerequisites
- Participants should be familiar with the terminals to be used in class exercises. A basic understanding of the host system editing tool is useful, but not required.
- Major Topics
-
- Relational database concepts
- SQL syntax and usage
- SELECT statement
- Joins
- Outer joins
- Nested Queries
- Views
- Synonyms
- SQL*Plus report creation
- Editing and saving queries
- Spooled output
- Exercises
- There are nine machine exercises.