Posts

OOW2016: Exploring Advanced SQL Techniques Using Analytic Functions (slides)

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.

Read more

Presentations-Presentations-Presentations

For the last few months I’ve been presenting a lot in various venues. I presented in Oracle Open World, HROUG conference in Croatia, DOAG in Germany, Oracle Week in Israel (3 day long presentations!), MySQL User Group in Israel and in some more private conferences and private events. I was also accepted to IOUG collaborate in Las Vegas in April and I’m planning to give some Webinars soon.

I believe that educating and sharing is pretty important, and since most of my presentations are in English (the slides, but sometimes also the session itself) – I usually keep the habit of uploading it to my SlideShare for people to enjoy it.

I was talking to a customer-friend yesterday, and he told me that he’s been reading my blog for a very long time, but he’s kind of sad he can’t see all my decks there. So, I’m taking his advise and for the next few days, I’ll post all of my presentations here – a post for each of the presentations and will add the demo scripts, wherever applicable.

Feel free to ask questions and make requests – I’d love to hear you opinion and suggestions!

All of the presentation are available for download from Slideshare.
My SlideShare link: http://www.slideshare.net/zohare.

Zohar

oow i'm speaking logo

My OOW Experience, the Prequel

On the first or second year after I became a DBA (somewhere in the year 2000, give or take), I heard about this magical event that is taking place in the Oracle realm. All the top Oracle DBAs and professionals in the world (and maybe a couple of unicorns, I’m not sure) are gathering in a small but beautiful village by the name of San Francisco – and talk about databases. I found this story unbelievable – but I knew I must go there.

I was about 20 at the time, so going around the world for a conference was out of the question – but the idea of a big convention sounded awesome to me. When I went to my first local Oracle event, I was so amazed and knew that no matter what – I will someday go to the Oracle Open World (OOW).

Years gone by and I evolved – from a programmer and DBA to a senior DBA, team leader, senior consultant, service director, and even CTO for a consultancy company – but I never had the chance to go to that Open World event.

Read more