Oracle 10G SQL for End Users
Course
In Bath
Description
-
Type
Course
-
Location
Bath
-
Duration
2 Days
On completion of the course delegates will be able to: Query and manipulate data. Use SQL*Plus to format query output. Suitable for: The course has been designed for System Analysts, Managers and End Users.
Facilities
Location
Start date
Start date
About this course
IT professionals who have some familiarity with the base operating system on which the database is mounted (e.g. Unix, Windows etc).
Reviews
Course programme
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
Oracle 10G SQL for End Users