Oracle SQL Part 2
Course
In Bath
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
Start date
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.
Reviews
Course programme
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