Request availability or book by selecting a date: Scotland
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview This course introduces delegates to the concepts of relational databases and provides an in-depth look at SQL in the SQL*Plus environment in order to retrieve and manipulate data from an Oracle database. This course is suitable for Oracle8, 8i and 9i. Audience Programmers, support staff and power users who wish to gain a comprehensive understanding of how the Oracle Structured Query Language is used. Skills Gained - Describe the basic structure of a relational database
- Use the command line features of SQL*Plus
- Create SQL statements to select data from an Oracle Database
- Generate simple reports from selected data
- Use SQL*Plus control and run time parameters
- Create and alter tables, indexes and views
- Create, update and delete records
- Grant and revoke access privileges
- Access the Data Dictionary
Prerequisites Delegates should be computer literate with a good knowledge of the standard editor available on their target hardware platform.
How to make a booking for the OD9-SQL13 course
|
