December 5, 2006 at 8:31 am
Does anyone have a recommendation for self-training materials that can take someone from a beginning level understanding of SQL server to an advanced DBA-type level of understanding? I am looking for something to take me and my other developer to a new level in our understanding of SQL server. Ideally this would have more in-depth coverage of JOINS, UNIONS, triggers and coding within stored procs (beyond just encapsulating simple queries in them). Any recommendations would be greatly appreciated.
Thanks!
Mike
December 6, 2006 at 7:20 am
AppDev has good training CDs, although they can be pretty expensive.
December 6, 2006 at 8:24 am
Mike,
I don't think there's anything to take you from start to guru. You'll probably end up with a variety of materials.
For books, I think any of the "SQL Server in 24 hours, SS2K for Dummies, SQL Server Unleashed", etc. series is a good book to get. I'm partial to Brian Knight's books because he founded this site , but the info in any of them is like 80-90% the same. Go through those as a good overview, try exercises and experiments, etc. Setup everyone with VPC and a personal edition of SQL and let them have fun. That way they can break it and learn as they do.
I'd also go through the exercises on TechNet with theirs or your VPC images (http://www.microsoft.com/technet/traincert/virtuallab/default.mspx)
Those are the low cost items. Beyond that, Andy and Brian, two of the founders of this site, offer classes in Orlando. There's travel, but the classes are pretty good. I'm biased, and you may find some classroom stuff locally, but that's expensive. However it works for some people better than books/DVDs. Send Brian and Andy a note and tell them you want a DVD, maybe they'll make one
If you google, you'll get lots of results for DVD and online training, however most of those seem to be for the MCDBA/MCITP cert programs and I'm not sure they're good for training your team. Not to say they're not worth it, but the goal of passing a test is different than learning the software .
I'd also consider finding a solid consultant and maybe buying a couple hours a week or a month and having them walk your team through some things.
If you find something you like, I'd love to see a review or hear what you like.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply