Lucas Jellema (Oracle ACE Director) started as an Oracle consultant in 1994. He is Expertise Manager for AMIS in Nieuwegein, The Netherlands.
Before joining AMIS in 2002 he worked at Oracle Consulting's worldwide Internet Development Center of Excellence, where he developed workshops, reusable software including the CDM RuleFrame framework for Server Side Business Rule implementation and standards & guidelines.
Lucas is a frequent blogger on Oracle technology (at http://technology.amis.nl), author of many articles (including OTN, Java Developer Journal, ODTUG Technical Journal, several Dutch Oracle and Java Magazines) and presenter at conferences (Oracle Open World, JavaOne and various international User Groups) and workshops. His presentations are full of information, presented with a lot of enthusiasm, embellished with war stories and anecdotal evidence, illustrated with many demonstrations and the odd absurdist observation.
Lucas is Senior Technical Consultant on Oracle and Java projects and currently focuses on SOA, mainly through Oracle SOA Suite. At this moment he is co-authoring “The Oracle 11g SOA Suite Handbook” (Oracle Press, Spring 2009).
He devotes serious time to find interesting ways of using the Oracle products for Application Development challenges. He also regularly participates in Beta Programs for various Oracle products.
 |
1-Day
Exclusive Seminar:
Oracle SQL Inside Out -
Challenging Puzzles and Puzzling Challenges
with Lucas Jellema
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 its 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, producing 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.
Objectives:
- Be challenged on your creativity with SQL
Learn how to use SQL functionality to solve your problems in a performing way
- Have fun exploring SQL
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
| Dates: |
Melbourne: 13th November 2009 |
| Price: |
AU$1181 |
|
Spaces
are limited for this Seminar
Do you like receiving the Oracle University newsletter? |
| Oracle University brings you the latest updates on courses and general news about Oracle University. To continue to receive communication from Oracle University, go to the Manage Profile & Subscriptions page and select the opt-in checkbox for "Oracle University" and "Oracle Certification Program" Forward this newsletter to your colleagues so they can also request a subscription to Oracle University news. |
|
