AUDIENCE:   The course has been designed for System Analysts, Managers and End Users. PREREQUISITES:   IT professionals who have some familiarity with the base operating system on which the database is mounted (e.g. Unix, Windows etc). DURATION:   2 days. Hands on. OBJECTIVES:   On completion of the course delegates will be able to: Query and manipulate data. Use SQL*Plus to format query output. COURSE CONTENT:   Explore Relational Principles and Oracle Concepts Examine the basic SQL statement Restrict and sort data Discuss single row functions and the use of NUMBER and CHAR functions Discuss single row DATE and CONVERSION functions Display Data Using Multiple Tables Aggregate data using group functions Write subqueries Examine SQL*Plus Manipulate data PI07/01