AUDIENCE:   This course is for programmers, developers and support staff who wish to gain a comprehensive understanding of how to perform the more advanced tasks whilst developing and maintaining an Oracle Database. PREREQUISITES:   Delegates should have a good basic understanding of Oracle SQL and Oracle SQL*Plus. Previous attendance of our course, Oracle SQL Part 1, is highly recommended. DURATION:   2 days. Hands on. OBJECTIVES:   This course is highly interactive and consists of theory coupled with plenty of hands on practical sessions. It will introduce delegates to the creation, security and maintenance of objects in an Oracle database. In addition the course will provide an understanding of SQL performance issues. On completion of the course delegates will be able to: - Utilise the SQL language to create and populate new objects. - Establish security for those objects. - Understand the performance of the SQL itself in respect of data retrieval. COURSE CONTENT:   Database Definition Creating database objects Creating tables Altering tables Renaming tables Temporary tables Btree indices in oracle When to use btree indices Creating btree indices Altering indices Bitmap indices Index only tables Partitioned tables Clusters    Indexing    Hashing    Hashing vs. Indexing Views Materialised views Synonyms Sequences Dropping objects Quiz and practical session on database object definition Oracle Data Dictionary Introduction Views Quiz and practical session on oracle data dictionary SQL Performance Issues & Tracing Introduction Index issues Analyse & optimisation Explain plan Sql trace Performance monitoring tools Quiz and practical session on sql performance issues & tracing Optimiser Hints Introduction Optimiser goal hints Access method hints Join order hints Join operation hints Parallel execution hints Miscellanous hints Quiz and practical session on sql performance issues Query Rewrites Introduction Using query rewrites The optimiser decision process Quiz and practical session on query rewrites Oracle Security Facilities Introduction Access to system pivileges Access to database objects Removing access to the database Removing access to database objects Quiz and practical session on oracle security facilities PI07/01