Oracle SQL Inside Out with Lucas Jellema - Utrecht April 12th April 12, 2012

Oracle SQL is an extremely rich and powerful language. Much more so than the everyday 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 its more recent, advanced extensions can be leveraged to address those challenges. These situations will include:

* Calculating the group standings for the Champions League; finding the shortest route from A to B; creating a fuzzy search that returns records by relevance and score with regard to search criteria; 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 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 (and network) queries, fine-grained auditing, cursor expressions and the model clause. Note however that the functional challenges will determine the pace and we will review only SQL functions we can use.

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