November 2012 Quarterly Educational Workshop

October 18, 2012 by · Comments Off on November 2012 Quarterly Educational Workshop
Filed under: QEW 

 

 

 

ID Required

 

 

 

 

Don’t miss out on the last Quarterly Educational Workshop before Training Days

PIZZA is being sponsored by ECS Team for lunch

November 16, 2012

Oracle – Campus

7700 Technology Way

Denver, CO 80237

Building 3 (North Building)

Registration Required!

Please go to:

http://www.rmoug.org/RMOUG-forms/QEWregistration.php

Question please e-mail Heidi at admin@rmoug.org

Or call 303.948.1786

 

$15 visitor fee
For non members

 

 

 

7:45 am – 8:15 am Continental Breakfast
8:15 am – 9:15 am Essbase Calculations – Observations from the Road
9:25 am – 10:25 am Sherlock Holmes for the DBA
10:35 am -11:35 am Introduction to SOA and Oracle SOA Suite
11:45 am -12:45 pm CTO’s Perspective on Adding Geo-spatial and Location-Based Information to Your Data
12:45 pm – 1:45 pm Board Meeting

 

Presentations

 

8:15 am – 9:15 am
Essbase Calculations – Observations from the Road
Chris Chase, Managing Partner @ The Bean Consulting Group

With nearly 25 years experience in software and database technology I thought I had seen all that programming had to offer; then I discovered Essbase. Learn some interesting observations regarding Essbase calculations accumulated over nearly 10 years of Hyperion implementations. We will discuss aggregations, allocations, eliminations, and driver-based calculations, commands and functions specific to Hyperion Planning, and some of the more confounding aspects such as block creation and cross dimensional operators.

 

9:25 am -10:25 am
Sherlock Holmes for the DBA
Kellyn Pot’Vin, Senior Technical Consultant @ Enkitec

The DBA has numerous tools, some requiring additional licenses, some standard to any environment. When problems arise, often the administrator is expected to, not only identify, but also correct the problem without impact and in short order. This presentation goes over a number of common Oracle errors and performance issues, showing what tools, tracing to AWR reports, along with how to utilize these to quickly assess a strategy to address problems when they develop to lessen the challenge to managing these types of environments.

Attendees will leave the session with a better understanding of trouble-shooting techniques and when to use what features, tools and reports to address issues.

 

10:35 am -11:35 am
Introduction to SOA and Oracle SOA Suite
Brian Statkevicus, Senior Consultant @ ECS Team and Greg Opie, Director of Architecture @ ECS Team

Almost everyone has heard of Service Oriented Architecture (SOA). Some people can accurately describe what it is and isn’t. This introductory session will cover:

• What is SOA?
• What are the business problems solved by implementing SOA?
• Oracle’s SOA Suite
• Demo of a sample business process using SOA Suite
• SOA Case Study

 

11:45 am – 12:45 pm
CTO’s Perspective on Adding Geo-spatial and Location-Based Information to Your Data
Bradley Brown, CEO/CTO @ InteliVideo

There is a considerable amount of free geo-spatial data available from the government and open source groups. This information can be quite helpful at providing more information about location-based data. For example, if you’re a property management company and you wanted to know close each of your properties are for anything from grocery stores to railroad tracks to flood plains, all of this information is available. If you wanted to know which homes are on a specific golf course, this data is available for free too.

In this presentation, Brad will share what geo-spatial data is available, where you can download the data, and what you might use the information for. You can also create your own layers of information and merge this into your queries. All of this can be done using an Oracle database (even the free version of Oracle) – i.e. without a mapping tool like ESRI. You can easily overlay this information onto Google maps or Google Earth. Brad will share PL/SQL code that will extract shapes into KML

 

 


View Larger Map

7700 Technology Way
Denver, CO 80237

 


Come Learn and Play QEW – August 17 at Elitch Gardens

July 20, 2012 by · Comments Off on Come Learn and Play QEW – August 17 at Elitch Gardens
Filed under: QEW 

Quarterly Educational Workshop

Elitch Gardens Theme and Water Park
2000 Elitch Circle Denver, CO 80204

Registration Required!

Members Registration

Non-Members Registration

Questions please e-mail Heidi at admin@rmoug.org or Carolyn at programsdir@rmoug.org

Download This Form for Complete Information

Registration open for the May 18 QEW

April 11, 2012 by · Comments Off on Registration open for the May 18 QEW
Filed under: QEW 

 

 

 

ID Required

 

 

 

  May 18th, 2012

Quarterly
Educational Workshop

And Annual
Membership Meeting

**MySQL – Special Interest
Group**

 

Oracle Broomfield Campus

500 Eldorado Blvd

Building 1

Broomfield, CO 80021

Registration
Required!

Please go
to:

Click Here to Register!

 Question please e-mail Heidi at admin@rmoug.org

Or call 303.948.1786

 

$15
visitor fee

For non
members

 

 

 

7:30 am –  8:15 am         Continental Breakfast

8:15 am –   9:15 am         TOAD as a SQL Tuning Tool 

8:15 am –  9:15 am          MySQL Backup & Recovery Essentials

9:25 am    10:25 am     Oracle PL/SQL Timestamp/Interval Data Types

9:25 am   10:25 am      SQL and NoSQL

10:35 am  – 11:35 am     Improving  your Oracle Application Express Applications using Dynamic Actions and Plug-Ins

10:35 am – 11:35 am       Explaining the MySQL EXPLAIN

11:45 am – 12:45pm        Demystifying MySQL for Oracle DBAs and Developers

Networking Lunch

12:45pm – 1:45 pm   Board Meeting (open to all members), Board Elections and Annual Membership  

 

Presentations

8:15 am – 9:15 am

TOAD as a SQL Tuning Tool 

Dan Hotka, Owner, www.DanHotka.com

 

This is a live-demo presentation.  Dan shows how to use TOAD to perform many SQL tuning tasks and the value of the information being presented.  TOAD has some interfaces that simply do not exist in other tools.  TOAD also has some little known features that comes with both the base TOAD and TOAD for Developers.  The attendee will gain valuable insights as to how Oracle processes SQL and many tips on how to improve SQL performance.

 

8:15 am – 9:15 am – MySQL

MySQL Backup & Recovery Essentials

Ronald Bradford, Founder Effective MySQL, Oracle ACE Director

 A hardware, software or human failure can occur at any time. Are you prepared?  Many organizations take a risk of serious data loss and system downtime with inadequate procedures in place to support a disaster recovery.  This
presentation covers the essentials of MySQL backup and recovery options, identifying the necessary tools for an effective strategy to support data resilience and business continuity for your organization. MySQL has no one
single unbreakable backup solution, so it is important to understand the impact of MySQL replication, storage engines, configuration options for durability, hardware configuration and the impact on locking and uptime for the various
hot/warm/cold options available
.

9:25 am – 10:25 am

Oracle PL/SQL Timestamp/Interval Data Types

Donald Schaefer, Ingenix Senior Software Engineer

Presentation/Programming Examples for 5 PL/SQL Data Types: Timestamp, Timestamp with Time Zone, Timestamp with Local Time Zone, 2 Interval Data Types; fractional second precision, automatic adjustment fordaylight savings time, Time Zone/date/time calculations/conversions, programming with various Timestamp/Interval PL/SQL functions.

9:25 am – 10:25 am

SQL and NoSQL

Dave Stokes, Oracle MySQL Community Manager

Data has lately been divided between SQL and NoSQL. But what if you could access the same data, from the same disks
using both methods? MySQL features two storage engines that provide direct SQL access and NoSQL access without duplication of systems, disks or other infrastructure. The InnoDB storage engine is MySQL’s default and is fully
ACID while the NDB is used in a cluster environment.  This session will cover how to get the best of both worlds.

10:35 am – 11:35 am

Improving  your Oracle Application Express Applications using Dynamic Actions and Plug-Ins

David Peake, Oracle Product Manager, Application Express

Learn how to easily incorporate dynamic actions and plug-ins to take your APEX applications to the next level. With the advent of dynamic actions developers no longer need to know JavaScript and AJAX in order to incorporate client-side interactivity. Plug-Ins allow developers to easily extend APEX with custom item types, regions,processes, dynamic actions and even authentication and authorizations.

 10:35 am – 11:35 am

Explaining the MySQL EXPLAIN

Ronald Bradford, Founder Effective MySQL, Oracle ACE Director

Determining the Query Execution Plan (QEP) of an SQL statement is the primary analysis tool for DBAs. Understanding how to interpret the information from the EXPLAIN command and what additional commands and tools exist to add supplementary information are essential skills that will be used daily in production operations.

The MySQL EXPLAIN QEP is significantly different from an Oracle QEP and Oracle DBAs need to understand and learn the most appropriate way to understand and navigate this information to effective performance tune a running MySQL
environment.

 11:45 am – 12:45 pm

Demystifying MySQL for Oracle DBAs and Developers

George Trujillo, Oracle Solutions Architect at VMware, Oracle MySQL ACE

MySQL is the world’s most popular open-source database for the Web.  The presentation will provide an introduction to the MySQL architecture, features and ecosystem.   Attendees will also see how new features, virtualization and the cloud are continuing to increase the adoption of MySQL.

Topics include:

1. MySQL Architecture

2. What makes MySQL so popular

3. Key Features

4. Advantages of MySQL

Networking Lunch

12:45pm   –1::45 pm  Board Meeting (open to all members), Board Elections and Annual Membership

500 Eldorado Blvd

Show on
Google Maps

« Previous PageNext Page »