Analytic Functions: Unleash the SQL Power
Track
Development & Middleware
Date and time
Wednesday, 14. October 2015., 10:00
Room
Hall 3 Restaurant
Duration
45'
Analytic Functions have been around for quite a long time, and still they are a relatively unknown. If you are unfamiliar with these very powerful functions, you are missing out on something spectacular. Analytic Functions add inter-row calculations, aggregates over multiple dimensions, or rank assignment based on values within a group of values - all without a GROUP BY clause.The syntax might seem daunting at first, but it is really not that scary. This session will focus on the syntax with tons of real world uses for Analytic Functions.
Lecture details
About speaker
Alex Nuijten, author
Alex Nuijten works as a key consultant for Ordina Oracle Solutions in The Netherlands. Besides his consultancy work, he conducts training classes, mainly in APEX, SQL and PL/SQL. Alex has been a speaker at numerous international conferences, such as ODTUG, Oracle Open World, UKOUG, IOUG, OUGF, BGOUG, OGH and OBUG. He was part of the Nordic ACE Directors Tour in 2012. He is also a frequent contributor at the Oracle Technology Network forum for SQL and PL/SQL. He wrote many articles in Oracle related magazines, and at regular intervals he writes about Oracle Application Express and Oracle database development on his blog "Notes on Oracle" (nuijten.blogspot.com). Alex is co-author of the book “Oracle APEX Best Practices” (published by Packt Publishers). In August 2010, Alex was awarded the Oracle ACE Director membership.
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.
Follow us on Facebook
Follow us on Twitter
Keep yourself up to date with all updates! Follow @HrOUG_2015Best Sponsor
Better Sponsor
Good Sponsor
Media Sponsor
