Presentation Title: Is Oracle SQL the Best Language for Statistics?
Speaker: Mr Brendan Tierney Oracle ACE Director
Company: Oralytics
Co-presenter: 
Presentation abstract: Did you know that Oracle comes with over 280+ statistical functions? and that these statistical functions are available in all version of the Database? Most people do not seem to know this. When we hear about people performing statistical analytics we can hear them talking about Excel and R. But what if we could do statistical analysis in the database, without having to extract any data onto client machines. That would be really good and just think of the possible data security issues with using Excel, R and other tools. This presentation will explore the various statistical areas available in SQL and I will give a number of demonstrations on some of the more commonly used statistical techniques. With the introduction of Big Data SQL we can now use these same 280+ Oracle statistical functions on all our data including Hadoop and NoSQL. We can also greatly expand our statistical capabilities by using Oracle R Enterprise using the embedded capabilities in SQL.
Presentation begins: 07/12/2015 09:00
Presentation duration: 50
Presentation content level: 4 (1 = indepth, 5 = strategic overview)
Audience experience: Beginner/Exploratory
Audience function: Customer/Senior Manager, Functional Manager, Product Expert, Product User
Speaker biography: Brendan Tierney, Oracle ACE Director, is an independent consultant and lectures on Data Mining and Advanced Databases in the Dublin Institute of Technology in Ireland. He has 22+ years of extensive experience working in the areas of Data Mining, Data Warehousing, Data Architecture and Database Design. Brendan has worked on projects in Ireland, UK, Belgium and USA. Brendan is the editor of the UKOUG Oracle Scene magazine and deputy chair of the OUG Ireland BI SIG. Brendan is a regular speaker at conferences across Europe and the USA and has written technical articles for OTN, Oracle Scene, IOUG SELECT Journal and ODTUG Technical Journal. Brendan has published his Oracle Press book called Predictive Analytics using Oracle Data Miner, in 2015 and is currently writing a book titled Oracle R Enterprise. email : brendan.tierney@oralytics.com twitter : @brendantierney blog : www.oralytics.com book on Amazon: http://tinyurl.com/orovpv8
Related topics: APEX & Database Development: Agenda Theme - Embrace, APEX & Database Development: Agenda Theme - Evolve, APEX & Database Development: Agenda Theme - Explore, APEX & Database Development: Big Data, APEX & Database Development: Deployment, APEX & Database Development: PL/SQL, APEX & Database Development: SQL
Hall: Hall 6B

Top