Monday 20 July 2009

Scott Squared

For those not subscribed to the AUSOUG emails, there is a branch meeting this Wednesday night with two presenters - me & my namesake - Scott Squared, I suppose. Mine won't go for too long, just some thoughts I needed to get off my chest on a topic I think is important but often overlooked.

My abstract:
If you're a database developer, regardless of whether you have 6 months or 6 years experience, you need a good reference manual. By good, I mean one that you can locate what you need within seconds. I know you know what I mean...

I'd like to show you how easy the free Oracle supplied documentation really is to use, and if for some reason it still doesn't cater to your needs, I'll show you some other methods and destinations that might save you a few headaches.

In this short presentation, I'll show you how to find most day to day documentation requirements in 2 clicks, maybe 3 if you're unlucky - without connecting to the net. You might also hear some funky new words such as Ubiquity & Bookmarklets.

I also look forward to Scott Hollows' presentation as there are some nifty features listed that are sometimes overlooked:
  • Subqueries everywhere - SELECTs in places where you didn't know you had places
  • Functions pretending to be tables
  • Outer joins and hierarchical queries - beyond the basics
  • Pivot and Unpivot your data
  • Fast track coverage of Analytical Functions
  • Rollup and Cubes
  • Nulls - SQL and PL/SQL issues, new nulls functions
  • Issues, Limitations, Workarounds and more
Event details

Topic 1: Weird SQL
Topic 2: Oracle Documentation: RTFM (Really Terrific Finding Methods)
Date: Wednesday 22nd July
Time: 4:15pm to 6:00pm - Aim to start first presentation at 4:50pm
Where: eCentral TAFE, 140 Royal Street, East Perth
Presenters: Scott Hollows and Scott Wesley
Cost: Free to members + bring a friend for free!

Free to members, as long as you RSVP with details. Please RSVP no later than 20th July, 2009 to Ailsa Wotherspoon at vicepresident.wa@ausoug.org.au to assist in planning for numbers.

Hope to see you there!

No comments: