COUG Members June 10th Presentation


Data Warehousing and Mining

Dr. Randall Dyck


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


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.

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
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

Leave a Reply

May 18th Presentation Featuring Ray Smith from CGI

Presentation: RMAN “RMAN is ok for the simple recoveries but when things get complicated it’s just not good enough.” Anyone who’s been a DBA for any length of time has heard that statement but is it fair? This presentation is intended to assess RMAN’s ability to recover in various recovery scenarios and discuss the alternative in […]

Read More
View the Blog »

March 16th Presentation Featuring Martin D’Souza from Innovation at Insum

Presentation: APEX 5.1 New Features APEX 5.1 is the latest major release of Oracle Application Express. It has a lot of ...

February 16th Presentation featuring Steve Recsky from First4 Database Partners Inc.

Presentation:Oracle - Free Extended Support was to on May 31, 2017. It is now the end of December 2018 ...