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 is not available as part of our public schedule but can be provided on a customised client specific basis.
Introduction To Oracle9i: SQL
DEFINING DATABASE OBJECTS:
creating an application schema
difference from delete and drop table
create index / drop index
alter, drop sequence
create synonym / drop synonym
user schema pass_a
about object security