Hotsos Training Day 2008
Hotsos is proud to announce that Tom Kyte is this year's training day speaker.
Biography
Tom Kyte is a Vice President in Oracle's Public Sector division. Before starting at Oracle, Kyte worked as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers. Kyte spends a great deal of time working with the Oracle database and, more specifically, working with people who are working with the Oracle database. In addition, Kyte is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). Kyte is also the author of Expert Oracle Database Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004), Beginning Oracle Programing (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.
Topic
The topics for Training Day 2008 are as follows::
- All about Encryption – From the dbms_obfuscation_toolkit, to dbms_crypto to transparent data encryption at the column level to tablespace encrypt and data pump encryption, we'll cover them all. We'll investigate which technique should be used and under what circumstances they should be used. We'll see how the keys are managed by the Oracle Database – or not in the case of the DBMS_ packages. We'll discuss "why" you encrypt and when encryption just does not apply.
- Materialized Views, Caching – Materialized Views were a new feature in Oracle 8i Release 1 (8.1.5). Over the last eight releases of the Oracle database, they have grown in capability and day-to-day importance. In this session, we'll explore what a materialized view is, how they work, when we might use them, and various useful "techniques" you need to know in order to make the most of them.
- Effective Indexing – Indexing is a large and somewhat ignored topic. We all know that "indexes are good", but what kind of index is appropriate, and under what circumstances? How does the type of index affect us? What are the considerations you want to be thinking of when coming up with your indexing scheme? This session will explore those topics as well as explore the physical structures underlying each discussed index type.
- Storage Techniques – How data is stored on disk by Oracle directly affects the speed at which we can retrieve that data (and modify it, and create it and so on). This session will look at the physical structures available to us, discuss when to use each (and when not to!). Techniques such as clustering, index organized storage, partitioning and compression will be investigated.
- Reorganizing objects – when and how – A hotly debated topic is "do I need to reorganize/rebuild indexes and tables". We will discuss the times when a reorganization or rebuild is relevant, how to measure what you've done (to verify that the work performed did something useful!), and the best techniques for performing a reorganization of data.
Schedule
Training Day will begin at 8:30 a.m. and end at 4:45 p.m.
Pricing
- $500
Registration Cancellation Policy
- 100% refund if cancelled on or before January 4, 2008
- 50% refund if cancelled between January 5, 2008 and February 15, 2008
- Cancellations submitted February 16, 2008 and after will not be refunded
