May 2015 Quarterly Educational Workshop
|ID Required||May 15th, 2015
Quarterly Educational Workshop
And Annual Membership Meeting
Oracle Broomfield Campus
500 Eldorado Blvd
Broomfield, CO 80021
Please go HERE to register.
Question please e-mail Peggy at firstname.lastname@example.org
Or call 303.929.6266
Sponsors: Dell Software, Solarwinds, Delphix
|$15 visitor fee
For non members
8:00 am – 8:30 am Continental Breakfast
8:30 am – 9:00 am Annual Membership Meeting and Board Elections
9:00 am – 10:00 am Relaxed Reporting – Tips & Tricks on Building Dynamic Financial Reports, Joe Monteith
9:00 am – 10:00 am Introduction to Wait Types and Response Time Analysis, Rob Mandeville
10:00 am – 11:00 pm TOAD Tricks and Tips, Brad Wulf
10:00 am – 11:00 am SQL Developer Tips and Tricks, Jeff Smith
11:00 am – 12:00 pm Implementing Data as a Service with Virtual Data, Derek Zunker
11:00 pm – 12:00 pm Oracle12 New Features with Release 2 Updates, Dan Hotka
12:00pm – 12: 30 pm Lunch
Annual Membership Meeting and Board Elections
8:30 am – 9:00
Notice of our Annual Membership Meeting with 2015-2016 Board of Directors election proxies have been mailed to all current members. If you are unable to attend the Annual Membership Meeting to cast your vote in person, please complete the mailed ballot and proxy. Proxies must be received by 5/13/2015 to be included in 2015 Board of Directors election results. Please return your completed proxy by fax to 480-718-7557 or use the return envelope is provided.
9:00 am – 10:00 am
Relaxed Reporting – Tips & Tricks on Building Dynamic Financial Reports
This session contains tips & tricks on building financial reports that use best practices to reduce closing cycles, improve transparency, expedite reporting, streamline compliance, and increase efficiency using Hyperion Financial Reporting (HFR). The session is designed around individuals who support the reporting and financial close process including CFOs, controllers, senior managers, financial analysts and systems administrators.
9:00 am – 10:00 am
Introduction to Wait Types and Response Time Analysis
Using Response Time Analysis and Wait Types is a newer method for tuning Oracle instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using Oracle Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues.
Rob Mandeville – Solarwinds
10:00 am – 11:00 am
TOAD Tricks and Tips
Abstract: Whether you’re new to Toad or a veteran user, Brad will show you tricks and tips to get even more from Toad’s time-saving functionality. You’ll also see firsthand how Toad 12.6 will make your job easier than ever. In this session
- Access the collective knowledge of the Toad community without leaving your work.
- Get the most from Toad 12.6, no matter which platform you use.
- Simplify business intelligence with Toad Data Point.
- And much more.
Brad Wulf has held in numerous roles over the past 15 years within the Database world including Technical Support, Build Management, Development and Presales. He is presently the Product Manager for Toad Extension for Eclipse, Toad for Mac, Toad for Hadoop, Toad for MySQL and SQL Navigator.
10:00 am – 11:00 am
SQL Developer Tips and Tricks
This session aims to arm every attendee with one or two new “tricks” that will dramatically save the amount of time it takes to accomplish daily tasks while working in Oracle Database with Oracle SQL Developer. Not only that, but they might learn how to have fun while doing it.
Whether you’re new to Oracle, new to the tool, or a veteran of both, the session can go as shallow or deep as the audience requires. Content includes topics that appeal to the technical analyst, business user, database administrator, and application architect/data modeler.
Jeff Smith is a senior principal product manager for Oracle, working on the SQL Developer team. His true passion lies in helping people maximize their productivity and retain sanity while working with database development and administration tools. You can get a pretty good idea of Jeff’s take on the current state of affairs in the world of Oracle and SQL Developer by reading his blog over at http://www.thatjeffsmith.com.
11:00 am – 12:00 pm
Implementing Data as a Service with Virtual Data. How can Virtual Data help your organization respond more quickly to business demands?, Derek Zunker
The agenda will cover Delphix data virtualization solutions to deliver DBaaS and entire environments more quickly and securely then making copies or clones. We will present how the data virtualization engine works as well as how customers have applied it for a number of different use cases. If time permits Derek will also demo Delphix tool.
Derek Zunker is the Delphix territory manager for the Rocky Mountain Region. Delphix helps industry leaders like Walmart, Wells Fargo, Cisco, Facebook, and Pfizer deliver higher quality application projects in half the time. Our solutions virtualize, govern, and deliver data on demand. Delphix transforms the process and economics of application projects to drive innovation.
11:00 am – 12:00 pm
Oracle12 New Features with Release 2 Updates
This presentation is a must-see for anyone supporting applications! The presentation will be broken into 4 parts:
- Pluggable Database
- How it works
- New SQL Syntax
- New Analytical SQL Features
- New SQL Features
- New Options for Sequences
- Enhanced Join Syntax
- Increased column size limits
- New PL/SQL Syntax
- PL/SQL and SQL
- Enhanced DBMS_UTILITY
- New UTL_CALL_STACK
- Enhanced DBMS_SQL
- Enhanced Native SQL
Summary: Dan will cover quite a number of new features of the Oracle12 database that should be of value to developers and DBA’s
Dan Hotka is a Training Specialist and an Oracle ACE Director who has over 36 years in the computer industry, over 30 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.
Click here to access and download the presentation.