Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Oracle SQL and SQL*Plus for End Users

Recommended Duration:
3 Days
Version
Oracle 12c or 11g.
(Courses available for earlier Oracle versions)
Benefits
Introduces participants to the Oracle database and its most commonly used tools. Numerous hands-on exercises will provide practice using SQL, and SQL*Plus or SQL Developer. 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.
Audience
People who will use Oracle's Relational Data Base and its various tools to solve queries and simple business problems.
Prerequisites
No prior knowledge of SQL or Oracle is required. Some familiarity with computer terminals (or PCs ) is helpful.
Major Topics
  • Relational database concepts
  • SQL syntax and usage
  • SELECT statements
  • Joins
  • Nested SQL queries
  • Table / View / Synonym creation
  • INSERT, UPDATE, DELETE, GRANT,REVOKE
Exercises
There are twelve machine exercises and two optional exercises.