Schedule today!

Call Peggy at
  (800) 252-0652

Contact Us

More Oracle

Related Courses

Oracle SQL and SQL*Plus

Recommended Duration:
3 Days
Oracle 11g. (Suitable for Oracle 10g, Oracle9i, or Oracle8i). Courses for Oracle8 or Oracle7 also available.
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.
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.
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
There are nine machine exercises.