About this Course

From an examination of single table operations to the complexities of accessing multiple tables using joins or subqueries, 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.

This course can be taught for any Oracle version.

Audience Profile

Programmers, Analysts, Database Administrators, and Users who must access data in an Oracle database.

Course Outline

• Data Retrieval Operations
• Multi-Table Operations
• Data Manipulation Operations
• Row Functions
• Group Functions
• Related Oracle Objects
• Creating Objects