This is the presentation I used for the Oracle Open World 2016 – it’s about SQL and more specifically about analytic functions and other advanced techniques.

Oracle Open World was one of my biggest aspirations for a very long time. Ever since I become a junior DBA I’ve heard of this conference but never thought I’d actually get to speak there.

For the last 3 or 4 years, I’ve been submitting my papers to the Open World CfP – and was never accepted.

Last year, I started to make my appearances at the different user groups meetup in the EMEA region. In June, I had the pleasure to sit down and talk to few user group leaders. From them, I learned what I can do better in submitting my papers and what kind of session I should aim for.  I followed their advice and indeed, I was accepted to present at the Open World (on the User Group Sunday – which, in my humble opinion, is the best day of the conference – with little to no marketing agenda).

So without feather ado, here it is. My first presentation at the Oracle Open World ever. The topic was Advanced SQL Techniques (analytic functions, grouping function and so on). This presentation also present couple of Oracle 12cR1 new features (since 12cR2 went out after OOW).  This is part of a bigger presentation I usually  give in a full day (I will post it as well soon) – that presentation also include newer features from 12cR2.

The presentation is available for download from Slideshare.

http://www.slideshare.net/zohare/oow2016-exploring-advanced-sql-techniques-using-analytic-functions

I had around 150 people on Sunday morning at 9:15 am. I got some great reviews and a personal invitation to submit this presentation to some of the biggest user group events in the world. I did and I am now waiting to see if it will actually by selected by their boards. 🙂

I really thought I would write more about the open world – since I did do some crazy things and met some lovely people there, but didn’t have the chance for it yet.
I hope I’ll get around to it because that was really cool – and I enjoyed it very much.