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

Installing Oracle – Part 2: Creating an Instance

In the earlier post we installed the Oracle version (software only) but still didn’t create a database instance. In this post we will go over an installation procedure of a basic CDB database instance. This will be the first instance on that database server (and I’ll explain later why this is important).

Read more

Installing Oracle – Part 1

It’s been a few months since came out. Here is a basic guide for installing Oracle 12c (
This is a two-part post – in the first part we will install the software and in the next part we’ll go over creating the new database instance.

Read more