Entries by Zohar Elkayam

,

MySQL 5.7 New Features for Developers (slides)

This is a presentation from outside my comfort zone – MySQL. So as most of you know, I usually do sessions about Oracle core technologies (rdbms), Big Data (Hadoop) and Spark. Even though I’ve been working with MySQL for quite some time, I never considered myself to be much of an expert – it was just always in the background.

Since I decided 2016 is going to be a year of challenges in my last year resolution, I choose to take the things I learned using MySQL 5.7 and make them into a public session. I consulted some of my co-workers, and decided that the best thing will be to start with MySQL for Developers. I took everything I thought that might interest developers and off we went.

I submitted this session to couple of user group conferences (and to the Oracle Open World) – but the first conference that it actually was presented at was DOAG 2016 in Germany. Since then, I presented this in two other events (the MySQL meetup in Israel and in a private event) and got some really positive feedback.

In the agenda:

  • Optimizer, Performance and InnoDB changes
  • Native JSON datatype
  • The Performance Schema and SYS Schema
  • Other features we should know
  • What are we waiting for in MySQL 8.0?

Read more →

/0 Comments/by
, ,

Things Every Oracle DBA Needs To Know About The Hadoop Ecosystem (slides)

This is the deck for a presentation I had the pleasure to present in multiple forums over the last year. It’s a short introduction for Oracle personal (DBAs and DB Developers) to the Big Data challenges and solutions. This presentation is focusing on the Hadoop Ecosystem but also shows other solutions – such as Apache Spark.

This is things every DBA needs to know, and not EVERYTHING a DBA needs to know. This is only an introductory to the subject. I also have a 200+ slides deck for getting the in depth view. If someone find this interesting and want to read more, feel free to contact me and I’ll post the longer deck as well.

In the agenda:

  • What is the Big Data challenge?
  • A Big Data Solution: Apache Hadoop
    • HDFS
    • MapReduce and YARN
  • Hadoop Ecosystem: HBase, Sqoop, Hive, Pig and other tools
  • Another Big Data Solution: Apache Spark
  • Where does the DBA fits in?

This presentation was presented in BGOUG 2016, ILOUG Tech Days 2016, HROUG 2016 and DOAG 2016 Oracle user groups. I also presented this in smaller, more private sessions.

Read more →

/0 Comments/by
,

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 →

/0 Comments/by
, ,

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

/0 Comments/by

OTN Appreciation Day: Oracle Data Guard and DG Broker

Thanks to Tim Hall for organizing this day – I’m happy to give back to the community which has given me so much.

My favorite feature is with no doubt is the Data Guard.

Even though the Data Guard feature might looks like an excess of other features (redo log for recovery, archive log for backup) it is one of the more awesome features in the Enterprise Edition database.

For those of you who don’t know what I am talking about – Data Guard is the disaster solution feature for the Oracle Database. This feature has been around since Oracle 7 (under the name Standby Database), but in Oracle 10g it had a major change: for the first time there was a way to create disaster recovery solutions, which actually had ROLES in them!

Read more →

/1 Comment/by