Oracle SQL Part 2

Course

In Bath

£ 550 + VAT

Description

  • Type

    Course

  • Location

    Bath

  • Duration

    2 Days

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. Suitable for: 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.

Facilities

Location

Start date

Bath (Somerset)
See map
11 Kingsmead Square, BA1 2AB

Start date

On request

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Oracle 10G SQL Part 2
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

Oracle SQL Part 2

£ 550 + VAT