Archive for October, 2009

SQL is fun. As well as the most powerful tool in the hands of Oracle Database developers. When you are a database developer, you know SQL. And that knowledge is challenged in this seminar. Prepare to be surprised about SQL has to offer, beyond the functionality you are already intimately familiar with. And let me buy you dinner if the seminar did not hold any surprises for you.

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.

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.

The seminar has a large number of demonstrations (for which all scripts will be made available). 

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

Objectives

• Grow confident in choosing the right weapon from the database development armory
• Be challenged on your creativity with SQL
• Learn how to use SQL functionality to solve your problems in a performing way.
• And, most of all perhaps, have fun exploring SQL.

Details:

See full APAC Agenda for Oracle University Celebrity Specials.

Details for Oracle SQL Inside Out – Challenging Puzzles and Puzzling Challenges (Friday 13th november in Melbourne and Friday 20th November in Singapore).

Also see:

Details on Oracle Database 11g R1 and R2 for Database Developers (Thursday 12th November in Melbourne and Thursday 19th November in Sinagpore).

Its almost that time again, on the 17th of November the next "DBA for DBA" Conference in Holland is about to start. As always, its filled with great speakers and high quality presentations if not only because most of them are based on real-life driven use-cases.

On the 17th of November the following colleagues / peers will present thei favourite topics:

• Harald van Breederode – Oracle Database 11g release 2: Data Guard new Features in Action,
• Frits Hoogland – Oracle HTTP Server security,
• Ingo Wevers – Oracle Streams – concreet en beheerbaar toepassen,
• René Kundersma – Exadata/SUN Oracle DB machine,
• Rob den Braber – Automatic Storage Management (ASM) 11g release 2 ,
• Bernhard de Cock Buning – Oracle GRID Infrastructure ,
• Rudolf van der Heide – How to bluff your way into data warehousing for DBA’s,
• Alex Nuijten – Continuous Database Application Evolution in Oracle Database 11g Release 2,
• Yuri van Buren - Forecasting Oracle Performance,
• Nienke Gijsen – Performance en Oracle 10g histogrammen

Have a more detailed look and or register via: http://www.planboard.com/symposium (Dutch)

I have had a small preview of Alex’s presentation about "Editions" and it was pretty cool. Other topics like 11gR2 features, Exadata (yep apparently we have some in Holland), ASM, DataGuard, demo’s of the content etc, etc, from my DBA peers, Oracle ACE or OakTable Network member will be explained in great detail.

So in short: Be there or be Square

Oracle Database 11gR2 has been released for Linux and will soon be made available on other platforms. This is typically the time that many organizations to start adopting the 11g version of the database – and for database developers to start learning about what they can get from this release.

In a one-day long seminar, I will introduce, demonstrate and discuss the most useful new features in 11gR1 and R2 – in the areas of SQL, PL/SQL and other facilities for Database Developers. Among the topics: Flashback Data Archive (at last, Flashback is a feature we can use for application development!), new and improved SQL syntax, new Aggregation features, extension in Analytical SQL, XML, SOA and WebServices, Virtual Columns and Result Caches for improved performance, new uses for User Defined Types, improved hierarchical querying (the end of the Connect By clause) and the spectacular new Edition Based Redefinition mechanism in 11gR2 (all by itself well worth attending this seminar for!)

The seminar has a large number of demonstrations (for which all scripts will be made available).

Objectives:

• Get up to speed with understanding and using the most important Oracle Database 11g features for application development
• Get some understanding of what improvements can be achieved for existing applications when upgrading to 11g
• Understand the benefits of adopting the 11gR1 or 11gR2 RDBMS in the area of database development
• Learn the intricacies of a brand new11gR2 facility that helps to manage the life cycle of database objects and allows parallel access to multiple versions of packages and views
• Become confident with some of the most useful functionality made available in 11g
• Have fun with some of the really nifty new 11g options

Details:

See full APAC Agenda for Oracle University Celebrity Specials.

Details on Oracle Database 11g R1 and R2 for Database Developers (Thursday 12th November in Melbourne and Thursday 19th November in Sinagpore).

see also the back-to-back seminar:

Details for Oracle SQL Inside Out – Challenging Puzzles and Puzzling Challenges (Friday 13th november in Melbourne and Friday 20th November in Singapore).

Oracle Open World, for this year, is done/is a wrap. A good presentation of the atmosphere can be seen on the "The Pythian OOW09 Diaries", on YouTube, were Alex Gorbachev placed a series of interviews he conducted in The OTN Lounge, which as always was a good place to hang out, meet other people and enjoy some good coffee or beverages.

During this series of interviews, besides hints on the adventures of Doug and "Polly and the Boys" and the occasional slip-of-the-tongue, good content can be enjoyed from, among others, Doug Burns, Steven Feuerstein, Gary Goodman (with details about the upcoming Hotsos Conference), Chris Muir, Tim Hall, Richard Foote. Justin Kestelyn, me, etc.

You can enjoy them here: "The Pythian OOW09 Diaries"