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 12c and/or 11g.
(Courses available for earlier Oracle versions.)
Benefits
Participants will be introduced to the Oracle database, SQL, and the SQL*Plus and/or SQL Developer tool. Several exercises use SQL to query the database and create simple reports using the SQL*Plus commands. 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, SQL Developer, or the locally-available tool. No programming background or experience is necessary, although a technical orientation is helpful.
Prerequisites
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
  • WHERE clause
  • ORDER BY clause
  • GROUP BY and HAVING
  • Joins
  • Outer joins
  • Nested Queries (subqueries)
  • Views
  • Synonyms
  • SQL*Plus report creation
  • Editing and saving queries
  • Spooled output
  • Introduction to SQL Developer
Exercises
There are nineteen machine exercises.