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.

« Hide The Details

Topics Covered In This Course

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

What You Can Expect

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.

Who Should Take This Course

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.

Recommended 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.

Training Style

The course is highly interactive. Consisting of instructor led, modular chapters containing plenty of hands on, practical workshop sessions.

« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com

Privacy Notice