Archive for June, 2010

COUG Members June 10th Presentation

COUG


Data Warehousing and Mining

Dr. Randall Dyck


Abstract:

The Data Warehousing and Mining concepts and commands listed below will be demonstrated
and URL’s for additional information will be provided.

Data Warehouses
—————————————————
OLTP designs vs. OLAP designs
Commands and tools to initially load data
Commands and tools to keep data current
Methods to increase performance


Data Mining
—————————————————
Advanced SQL to analyze data
Advanced PLSQL to analyze data
Tools for further analysis



Where: Suncor Energy Centre, 150 6th Avenue SW, 17th floor Fraser Room
When: Thursday June 10th, 2010.
Registration 2:00 PM, Presentation 2:30 PM, Duration: 1 hour


Presenter Bio(s):


PhD in Computer Science
Over 18 years in industry building systems around the world
Over 10 years in universities teaching Oracle design, development, and administration
Total of 25 years of experience with Oracle, from versions 6.0 to 11.0



imagemap

Long View First4 Amec CGI Devy Oracle O'Reilly SAIT Suncor

Thank you for your continued support of COUG.


COUG Year End Social
Come help us wrap up our 2009-2010 season!! Join us at Bottlescrew Bill’s, voted Calgary’s Best Pub in 2009 by WHERE magazine!

Thursday June 10th 2010
Directly following the final 2009-2010 COUG meeting
3:30 PM – 6:30 PM
Bottlescrew Bill’s Old English Pub
140 – 10 Avenue S.W.

Oracle 11g Upgrade Seminar
Join Tom Kyte and the Oracle Development team for an Oracle Database 11g Upgrade Seminar.

Are you considering upgrading your database to Oracle 11g?
Are you unsure of what’s involved and the latest best practices for upgrading Oracle databases?
This seminar is a rare opportunity to hear directly from Oracle’s Upgrade Development Team and give you all the latest best practices, hints & tips needed to make your upgrades successful.

Don’t forget COUG Members! Tom Kyte has reserved some time in the afternoon just for us!


Wednesday, June 2, 2010
8:00 a.m. – 1:30 p.m.


Agenda
8:00 AM Registration and Breakfast
9:00 AM Keynote Address – Presented by Tom Kyte
Why Upgrade? Because Change Is The Only Constant
10:00 AM Break
10:15 AM General Session:
Upgrade Preparation – Support Policies,Patches, Documentation, Upgrade Paths
11:15 AM Breakout Sessions (choose to attend one session)
Session #1
Database Upgrade: DBUA, Command Line, Post Upgrade, Alternatives, ASM Upgrade
Session#2
Performance Evaluation: SQL Plan Management, SQL Performance Analyzer, Database Replay
12:15 PM Networking Lunch, Wrap Up and Raffle Drawing
1:30 PM Calgary Oracle User Group Session
Read More