Oracle 11g SQL & SQL*Plus

Summary:
From an examination of single table operations to the complexities of accessing multiple tables using joins or sub queries, this course provides a thorough introduction to interactive SQL. This course also introduces the student to basic SQL*Plus operations required to enter, edit, and run SQL statements, produce reports, and write interactive SQL scripts through SQL*Plus. Coding examples and workshops serve to reinforce the material presented in class.

Duration:
Three days

Audience:
This course is designed for Programmers, Analysts, Database Administrators, and Users who must access data in an Oracle database.

Topics:

• Data Retrieval Operations
• Multi-Table Operations
• Data Manipulation Operations
• Security
• Miscellaneous SQL
• SQL*Plus

Prerequisites:
Students should have previously taken the Oracle11g Concepts and Facilities course.