Oracle APEX Developer Day
9:00 am - 4:30 pm
Who should come: IT Managers, DBAs, Enterprise and Solution Architects, DevOps Engineers and Developers
10:30 am - 4:30 pm
Optimization with Intent
Ric Van Dyke, Hotsos Ltd.
SQL has come a long way and the options available to write your queries have increased over the years. But how do you know if the query you just wrote will work well in production? This training session will dive deep into what happens when that code is executed. With better understanding on how to evaluate the SQL you will be able to write better, faster and scalable queries. Key parts of the training will be evaluating run time statistics of our queries, getting these statistics, what to look for in a plan, indexing strategies, predicate ordering, row and block selectivity, and what options you can use to make SQL better, faster and stronger.
Ric Van Dyke is an Oracle ACE with over 25 years of experience in the IT industry. He worked as a developer and database administrator with Oracle starting with Version 6 and for Oracle Corporation for 10 years primarily as a core database instructor where he taught and developed several courses. Ric also served in the Advanced Technologies Services consulting group as a technical manager where he worked with several clients doing RAC installs and performance engagements. He has been with Hotsos for 10 years as an instructor; he also does performance consulting engagements and frequently speaks at local user group meetings.
1:00 pm - 4:00 pm
Conner McDonald, Oracle Corporation
Remember the good old days when writing SQL meant knowing SELECT, FROM and WHERE, plus how to use TO_CHAR and TO_DATE to handle those pesky dates. Fast forward to today, and the Oracle SQL documentation is a mindboggling 1500 pages long, and even that is only because we moved the SQL features for data warehousing, objects, OLAP, XML, Text and Intermedia into their own manuals! Our inability to keep up with the wealth of goodies available in SQL often means we too quickly resort to a 3GL coding solution - which can be more complicated, slower or just plain wrong. So let’s spend some time getting up to speed with some of the great SQL facilities available in the Oracle database, and look at some techniques to maximize the benefits of SQL-centric solutions. Key focus areas will be Analytics, Hierarchical queries, the WITH clause, Scalar subqueries, and the MODEL clause.
Connor McDonald is a former Oracle ACE Director who has joined the Oracle Developer Advocates team. Over the past 18 years, he has worked with systems in Australia, the UK, Southeast Asia, Western Europe, and the United States. He has co-authored three books, and has been a popular speaker at Oracle conferences around the world, specializing in topics regarding the database engine and PL/SQL. He has twice won the Inspirational Speaker award by the UK Oracle User Group in 2009 and 2011.
1:00 pm - 4:00 pm
Oracle Cloud Technology Workshop
Viscosity North America & Kai Yu, Dell
The Cloud Experience Technology Workshop* will start with creating a database in Oracle Cloud. We will also focus on backing up an on-premise database to the cloud and various solutions that are available from Oracle to backup both Oracle databases and non-Oracle databases. We will discuss complete solution options that you can implement as you make your journey to Oracle Cloud. We will also discuss real-life solutions addressing security concerns, opening ports, creating database links/communicating with databases in Oracle Cloud, and innovations that Oracle has made to Oracle Cloud in the past two years.
Here’s a high level agenda of the Oracle Cloud Experience HOL Workshop:
* Every attendee will be given a Kindle version of the Oracle Cloud Pocket Solutions Guide, which addresses Oracle Cloud fundamentals, Storage Cloud, Database Cloud, and Oracle Database Backup Cloud, as a quick go-to reference guide.