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

November 23rd Presentation Featuring Alex Kizer, Groundswell Group

Presentation: Introduction to NoSQL & MongoDB Database The term “NoSQL” is very ill-defined. It’s generally applied to a number of recent nonrelational databases such as MongoDB, Cassandra, Neo4J, and Redis. They embrace schema-less data, run on clusters, and have the ability to trade off traditional consistency for other useful properties. Advocates of NoSQL databases claim […]

Read More
View the Blog »

September 21st Presentation Featuring Sarah Craynon Zumbrum, Oracle

Presentation: Introduction to Oracle Analytics Cloud (OAC) Oracle’s analytics offering got a huge boost this spring with the release of the ...

June 15th Presentation featuring Willie Hardie from Oracle and Ryan Behiel from Veritas

1st Presentation: What's New in Oracle Database 12c Release 2? Oracle Database 12c has been the most rapidly adopted release ...