Oracle SQL Inside Out Training Course with Lucas Jellema

March 27, 2012 - PRLog -- 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.

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/oracle-sql-inside-out-with-lucas-jelle...

---

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