April 24, 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 yearit 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.
Event organizer: Oracle University
Get more info and register online for the Ask Tom Live: A 1-day Oracle Seminar with Tom Kyte - Utrecht September 20th at http://itevent.net/ask-tom-live-a-1-day-oracle-seminar-wi...
ITEVENT.NET is the largest listing of IT training courses and conferences provided by global corporations (such as Microsoft, IBM and Oracle) and independent consultants from IT, telecom, web and other technology and computer related industries. More IT events can be found on http://itevent.net