Can anyone recommend training (a book, a tutorial, etc.) for ERwin?

  • I am in the process of cross training a DBA. At this point, he has very little knowledge of ERwin 7.2 and data modeling in general. Can anyone recommend training (a good book, a tutorial, etc.)? Unfortunately, offsite vendor training is not an option for us.

  • Have you tried just searching for something?

    I found a few online training programs right away when I searched for "erwin training" in Bing.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Yes, I did search prior to posting. I even searched sqlservercentral.com prior to posting, but I came up mostly with old posts, seminars, and consulting.

    I would prefer to find a book that someone else has already found useful. Amazon.com has several books on its site, but most of the titles I found look old. Consequently, I thought I would pose the question to actual DBAs.

    How does your company handle training in ERwin? Do they have anything that they use for new DBAs?

  • Honestly, I avoid ERwin almost completely. I've found that a whiteboard has more utility in data modeling. Or a dinner napkin and a Sharpie. Haven't touched ERWin in about 5 years. Used it for a while way back when, but only because I had to, not because it actually did anything useful for me. Could be I'm missing something key in it, but if so, it hasn't stopped me from getting my job done yet.

    So, color me cynical on it.

    However, if you find it useful (and I assume you do since you want to train a new DBA on it), so do lots of other people and you're in good company.

    I'd start with the material on ERwin's Recommended Reading page: http://erwin.com/reading/

    On the same site, they have discussion forums, support groups, and a bunch of other resources under their Support and Community tabs. Start there. You'll be likely to find people a little less jaded about it than I am.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • shew (8/18/2011)


    I am in the process of cross training a DBA. At this point, he has very little knowledge of ERwin 7.2 and data modeling in general. Can anyone recommend training (a good book, a tutorial, etc.)? Unfortunately, offsite vendor training is not an option for us.

    Offsite training seems like overkill to me. I've just started using ERwin 7.3 at new job in June. It's pretty straight-forward with a few interface oddities/quirks. I'd say just let the trainee play with it and you can advise them around the gotchas.

    My $.02,

    Rob

  • I have a similar opinion of Erwin to GSquared - I think it's horrible and I'd rather have the pleasure of using graph paper and a bic... Underwater.

    I have been forced to use it while working in an analytic's function at a bank. I did actually buy Carla DeAngelis's Modelling with Erwin and it's possibly the only thing worse than actually trying to figure it out. I would strongly recommend against investing in a copy of it.

    On a completely different note - in our department whenever anyone mentioned ERwin the team would break out into an Irwin chant inspired by early 90's wrestler Irwin R. Schyster of Ted "Million Dollar Man" Dibiase fame.

    ----------------------------

    Dosing Tanks

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • When I used ERWin (as they spelled it at the time, IIRC) I thought it was excellent tool (once I got used to it).  However, you have to understand data modeling, so you should first train in the basics of data modeling (entities (vs "tables"), attributes (vs "columns"), etc.).  Presumably you've already done that.

    Unfortunately, I don't see any books similar to the ones I used then available now.

     

    SQL DBA,SQL Server MVP(07, 08, 09) Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: "If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them."

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply