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.
Event organizer: Oracle University
Get more information and register for the Oracle SQL Inside Out with Lucas Jellema - Utrecht April 12th at http://itevent.net/
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