Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

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.