Oracle SQL Inside Out - Challenging Puzzles and Puzzling Challenges with Lucas Jellema, 26th May 2010, Bratislava May 25, 2010

Oracle SQL is an extremely rich and powerful language. Much more so than every day use of SQL reveals. Today, Oracle SQL is much more than just the simple Select-From-Group By-Order By construction it once used to be. This seminar introduces a series of real world challenges and demonstrates how SQL and sometimes it more recent and more advanced extensions can be leveraged to address those challenges.
From calculating the group standings for the Champions League and finding the shortest route from A to B, creating a fuzzy search that returns records by relevance and score with regard to search criteria, to creating a personalized television guide, creating charts, emulating a supermarket cash register, creating a test data generator, implementing a highway speed controller and devising a mobile telephone billing application, we take on clear situations and find ways to make SQL do the work.
SQL functions that we will explore include Pivot and Unpivot (10g and 11g), Analytical Functions, Aggregation, Collections, Intervals, Flashback, Single Statement ETL, SQL/XML, Inline Views, Outer Joins, Hierarchical (& Network) Queries, Fine Grained Auditing, Cursor Expressions and the Model Clause. Note however that the functional challenges determine the pace and we visit only SQL functions we can really use.

Topics:

* Analytics in action
* Single Statement ETL
* Aggregation and Partitioning
* Querying Hierarchies and Networks
* Smart Joining
* Time is on our side - freeze & revert time, interval & time zone calculations
* SQL & PL/SQL interaction through Objects, Collections, Table Functions and Cursors
* The other procedural SQL - in line views and scalar subqueries

Official Website: http://cli.gs/rX3Uur