| WA1276 Introduction to Oracle 9i: SQL |
|
The foundation for all Oracle professionals is the SQL language along with Oracle's SQL*Plus extensions. A detailed consideration of these languages includes such topics as creating and maintaining table definitions in the data dictionary, specifying data types, manipulating tables and developing sophisticated queries quickly and accurately. |
|
| Objective: |
|
At course completion, students will
- Understand the concepts of relational databases.
- Create and alter table definitions including column data type declarations.
- Maintain data within tables using INSERT, DELETE and UPDATE statements.
- Build queries using both basic and advanced SQL techniques.
|
|
| Audience |
|
All Oracle professionals including developers, database administrators, designers and analysts. |
|
| Suggested Prerequisites |
|
A basic understanding of computer programming concepts is helpful |
|
| Duration |
|
Three days. |
|
|
|
