Ask Tom Live: A 1-day Oracle Seminar with Tom Kyte - Utrecht September 20th September 20, 2012

SQL is an extremely powerful language these days. It offers set-based processing, iteration, and recursion. In short, it has many of the qualities of a procedural language and a declarative language. This session explores five things you probably didn't know about SQL.

PL/SQL turns 24 years old this year—it was first introduced in 1988 with Oracle6 Database. This session looks at five technical things about PL/SQL you probably did not know: under-the-covers features that make PL/SQL quite simply the most efficient language with which to process data in the database.

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.

Official Website: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D70365_1655061&p_org_id=41&lang=NL