This is a heads up for some upcoming events I will be appearing on in the next few weeks. I was also accepted (as a standby session) to UKOUG Scotland (which I was at, last year) but unfortunately I will not be able to attend as it collides with some of my other speaking events.

ILOUG Technology Days 2016

On May 30 and 31, in Rishon Le’zion (Israel) I will be giving two sessions on my favorite Oracle User Group (well, it’s the one I belong to.. :).

The first session (and its abstract) is:

Exploring Advanced SQL Techniques Using Analytic Functions

Even though DBAs and developers are writing SQL queries every day, it seems that advanced SQL techniques such as multi-dimension aggregation and analytic functions are still relatively remain unknown. In this session, we will explore some of the common real-world usages for analytic function, and understand how to take advantage of this great and useful tool. We will deep dive into ranking based on values and groups; understand aggregation of multiple dimensions without a group by; see how to do inter-row calculations, and much-much more…

Together we will see how we can unleash the power of analytics using Oracle 11g best practices and Oracle 12c new features.

The second session will be:

Is SQLcl the Next Generation of SQLPlus?

Introducing the new tool from the developers of SQL Developer: SQLcl – a new command line tool from the SQL Developer team that might replace SQL*Plus and all of its functions which has been around for over 30 years!

In this session, we will explore the new functionality of the SQLcl, and use a live demonstration to show what SQLcl has to offer over the old SQL*Plus. We will use real life example to see what makes this tool such a time saver in day-to-day tasks for DBAs and developers who prefer using the command line interface.

Link to the event

BGOUG Spring Conference 2016

On that same week of the ilOUG Even I will also be attending the Bulgarian User group at the Borovets Resort. This event take place between June 3^rd to June 5^th.

There, I will also give two 1 hour sessions:

Exploring Advanced SQL Techniques Using Analytic Functions

See abstract above

Things Every Oracle DBA’s Need to Know about the Hadoop Ecosystem

Big data is one of the biggest buzzword in today’s market. Terms like Hadoop, HDFS, YARN, Sqoop, and non-structured data has been scaring DBA’s since 2010 – but where does the DBA team really fit in?

In this session, we will discuss everything database administrators and database developers needs to know about big data. We will demystify the Hadoop ecosystem and explore the different components. We will learn how HDFS and MapReduce are changing the data world, and where traditional databases fits into the grand scheme of things. We will also talk about why DBAs are the perfect candidates to transition into Big Data and Hadoop professionals and experts.

Link to the event.

DevGeekWeek Israel 2016

This is a different kind of an event. First, these sessions are not an hour long sessions like in the user groups – they are a daylong sessions. The other thing is that the event is not focused on  database administrators or database developers, but to the more general application development and IT professionals. I will be talking about Big Data and Spark which are some of the things I’ve been involved with a lot it the last couple of years.

This event is 5 days long, and will be taking place on June 19th to the 23rd in Hetzelia, Israel. I will be leading 2 sessions:

Hadoop Ecosystem Fundamentals & Abstractors (Pig, Hive, Hbase)

When we’re thinking about Big Data solutions, we usually think about Hadoop. Apache Hadoop is an open-source distributed fault-tolerant system that leverages commodity hardware to achieve large-scale agile data storage and processing. Hadoop empowers applications to work with a large number of nodes, and large-scale storage without exposing the complexity of clustering to the end user.

In this seminar, we will discuss the design principles behind Apache Hadoop and explain the architecture of its core sub-systems: HDFS and MapReduce. We will then dive into the Hadoop eco-system and other projects that relate to Hadoop big data solution.

This seminar is for application developers, team leaders, data scientists, and architects who want to understand Hadoop’s architecture and its related projects.

Rapid Cluster Computing with Apache Spark

When we’re thinking about Big Data solutions, we usually think about Hadoop. The Hadoop framework is based on the programming model called MapReduce, and it enables a computing solution that is scalable, flexible, fault-tolerant and cost effective.  While MapReduce gives us all that, it is still a little complicated to write, harder to use and maintain, and sometimes slow to run.

Spark is an open source alternative to MapReduce – designed to make it easier to build and run fast and sophisticated applications on Hadoop or without it. It was introduced by Apache Software Foundation as a replacement to the Map Reduce framework and it is now considered one of the best solutions for MPP processing.

Spark’s main feature is its in-memory cluster computing that increases the processing speed of an application. It performs at speeds of up to 100 times faster than Map Reduce for iterative algorithms or interactive data mining and with much less code. Spark is also very flexible, and supports Java, Scala, and Python APIs for ease of development. It also have on-line shells for testing and debugging.

In this session, we will learn what is Spark, how to utilize it, and how to integrate it with the rest of our Big Data solutions. We will explore some code samples, and show usages of data science in the real world.

The seminar is designed for developers, team leaders, data scientists and CDOs.

The session includes some code samples so programming background might be required.

Link to the event.