 |
|
|
Introduction to OracleTM 9i: Advanced SQL
Essential advanced features within the Oracle SQL language are considered within this course. Building indexes, specifying declarative constraints, managing security privileges for tables and using SQL to satisfy some of the most complex query requests are all among the topics considered within this course. This course largely focuses on SQL features that are unique to the Oracle database and as such is applicable even for SQL professionals experienced in other databases.
This course was formerly called “Introduction to Oracle9i: Advanced SQL & SQL*Plus”.
 Course Summary:
- Defining Database Objects
- Database Security
- SQL Functions (CHARACTER)
- SQL Functions (NON-CHARACTER)
- Advanced SQL Language Constructs
- Protecting Tables with Declarative Constraints
- Maintaining Constraint Definitions
- Enhancing Groups with Rollup & Cube
- Advanced SQL*Plus Reports
- Building SQL*Plus Scripts
- Processing Hierarchies
- Advanced SQL & SQL*Plus Features
Follow-Up Courses:
Option of other related or follow-on courses:
- Introduction to Oracle9i: PL/SQL Language
|
 |
|
|
