As he had promised before he left last December, Tom Kyte will come back to Zurich on September 21st./22nd. and deliver another two days of his very advanced seminars on database architecture and programming techniques.
After the last seminar in December which was completely sold out, we have booked for a larger room this time, again at the Zurich Development Center, which is a great location to have a seminar at.
Again Tom Kyte will deliver two sets of sessions each of them about 60-90 minutes long.
Tom Kyte will cover the following topics:
“Things you “know”
Many developers and DBAs (not all, but many) approach the database with little or no understanding of how it actually works. Developers approach Oracle assuming it must work just like SQL Server or even worse with the frame of mind that says, “It doesn’t matter how it works, I’m using a layer of abstraction to protect me.” DBAs approach the server sometimes with a cursory knowledge of how things work, leading them to do things like, “We can skip backing up undo data-it isn’t our stuff, we don’t need it” or erasing archives because they ran out of space.
This presentation will present some of these foibles and explain how not understanding how the database actually works will lead to disaster. Some examples of things you just might not know about yourself will be explored. Oracle is big and it is a moving target. Understanding it is an ongoing process that we need to continually do.
Advanced analytic functions
Analytic functions are the coolest thing to happen to the SQL language since the introduction of the keyword SELECT . This session explores the use cases for analytic functions, demonstrates how and where you should use them, and explains the (nontrivial) syntax behind them.
Efficient schema design
Based entirely on chapter 7 of Tom’s book “Effective Oracle by Design”, this session takes you through the fundamentals of physical schema design. It demonstrates the various structures (hash clusters, B*-tree clusters, index-organized tables, …) and tells when and where you want to use them. The session closes with indexing and compression techniques.
PL/SQL or Java?
Is one language “better” than the other? Or maybe there is room for both? This session explores when you might want to use one over the other SQL Techniques
The presenter will describe common SQL techniques he has encountered and utilizes day to day to tune query performance. Features such as scalar subqueries, using rownum (yes, to ‘tune’), analytics, some hints and more will be demonstrated. Emphasis will be on when they work (where the ‘trick’ applies) as well as when they don’t workwhere they do not apply. Care will be taken to show these not as a “top 10 things to do” but rather techniques to keep in mind when looking at problems in general.
Building test cases
When you say “it doesn’t work”, or “it isn’t working right”, you will need to build a small, concise, yet 100% complete test case that demonstrates the issue at hand (and removes all of the irrelevant bits). This session walks through how Tom Kyte builds his own test cases — and how he many times finds his own mistakes in the development of them (such as: it wasn’t a database bug in the first place!) – or, even if it turns out to be a problem in the database, how the development of the test case often leads to finding a workable “workaround”.
Bits and bytes
This session covers some Oracle 10g features that are really “cool” but not played up in the Oracle marketing messages. Mundane features that make our day to day lives that much nicer. Presented as a top 10 for 10g Release 1 and top ten for 10g Release 2
Versioning of data
A common requirement today is to maintain a complete history of data: every change made to a row over time, for rows in a table or set of tables. This session explores the methods available to do this, from “do it yourself” versioning (via triggers/application code) to letting the database do it for you with workspace management. Key focuses of this session are time to develop, performance, and implementation
Every participant of this seminar will not only get the printed courseware for the sessions of course but also a copy of Tom Kyte’s book on Oracle 9i and 10g Database Architecture.
Also there will be the sought-after Tom Kyte-T-Shirt again.
There are still a few seats available!
If you are interested in taking part here are the detail again:
Date: September 21st., 22nd.
Time: 9:00h -16:00h
Location: Zurich Development Center
Price: CHF 1800,-