SUMMARY:   This course will introduce students to the creation, security, and maintenance of objects in an Oracle database. In addition the course will provide an understanding of SQL performance issues. AUDIENCE:   Programmers and support staff who need to gain a comprehensive understanding of how to perform the more advanced tasks in SQL, while developing and maintaining an Oracle Database. PREREQUISITES:   Students should have a good basic understanding of Oracle SQL and Oracle SQL*Plus.Previous attendance of our course Oracle10g SQL and SQL*Plus Part One is highly recommended. DURATION:   2 Days. This course can be combined with PL/SQL Part One to run at 5 Days. It Can also be combined with SQL Part One to run at 5 Days, though that may be a little intensive for students new to SQL. APPROACH:   The course is highly interactive. Consisting of instructor led, modular chapters containing plenty of hands on, practical workshop sessions. OBJECTIVES:   Upon completion of this course, students will be able to utilize the SQL language to create and populate new objects, establish security for those objects as well as understand the performance of the SQL itself in respect of retrieving data. 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 ORACLE DATA DICTIONARY INTRODUCTION VIEWS SQL PERFORMANCE ISSUES & TRACING INTRODUCTION INDEX ISSUES ANALYSE & OPTIMISATION EXPLAIN PLAN SQL TRACE PERFORMANCE MONITORING TOOLS OPTIMISER HINTS INTRODUCTION OPTIMISER GOAL HINTS ACCESS METHOD HINTS JOIN ORDER HINTS JOIN OPERATION HINTS PARALLEL EXECUTION HINTS MISCELLANOUS HINTS QUERY REWRITES INTRODUCTION USING QUERY REWRITES THE OPTIMISER DECISION PROCESS ORACLE SECURITY FACILITIES INTRODUCTION ACCESS TO SYSTEM PRIVILEGES ACCESS TO DATABASE OBJECTS REMOVING ACCESS TO THE DATABASE REMOVING ACCESS TO DATABASE OBJECTS