Practical Course of Learning
-
I'm the programmer and database guy for my company. I'm learning hungry. I taught myself Access and built about 15 systems for as many clients. Then learned basic SQL2000 and .Net C# and developed about 12 projects, all web related. I understand the basics: relationships, T-SQL, normalization, choosing data types, stored procs, UDF's. Now I want to know what's under the hood.
I couldn't give a poo about degree's or certifications. I want the practical working knowledge. Can anybody recommend books, on-line classes, or other resources that you couldn't live without? (and don't say BOL, that's a given)
Thanks in advance!
I hope this is the right place for this post. Please tell me if it's not. I think job hunters may benefit from the responses either way.
Charismaniac Hog,Matthew Spare
ithinkdesigns.com -
Ken Henderson's books are among the best especially for under the hood check out
Guru's Guide to SQL Server Architecture and Internals
Here is my review on it.
And then you might try looking thru my post history as I know I have contributed to quite a few really good ones in the past and many have links and other info you might find interesting.
-
Kalen Delaney's Inside SQL Server 2000 is a good one.
-
Microsft SQL Server 2000 Administrators Companion
ISBN 0-7356-1051-7.
Hard to go wrong with a book writen by the company who created SQL Server.
-
I have my difficulties with the last book http://www.sqlservercentral.com/columnists/fkalis/reviewofreviewofsqlserver2000administratorscompani.asp
Well, although BOL is a given, it is seldomly used as much as it should be. It is definitely the first place to go. Antares mentioned already Ken Henderson. Meanwhile I think his Guru's Guide to T-SQL is a must have, too. Surely Kalen Delaney.
But apart from reading books and getting knowledge equally important is getting experience by working with the product.
And, last but not least, online communities are an exceptionell place to share and get knowledge for free.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
I am not a fan of MS Press books.
It may be an obsolete prejudice but I see the existence of 3rd party books as proof that the manufacturers own manuals are flaky.
If I compare the MS Press deluxe learning edition of VB, VC++ etc to the nearest Wrox press equivalent it is like comparing an old Trabant (papier mache car made by the East Germans) to a BMW.
-
papier mache car made by the East Germans
Hm, I guess this would annoy quite a few people as there is no such distinction anymore here,...
< snip dramatic pause to emphasize on the irony >
... I mean there, in former East Germany
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Sorry Frank, is it also the former Trabant or are they still made?
-
Hey, I'm not insulted! I would be, if I were to drive such a thing some call a car
No, I think, the trabby is not produced anymore. However, some people here consider this cool, hip or stylish
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Cool, hip, stylish and VERY dangerous.
I have a friend who restored one of the original FIAT 500s and those have the fuel tank under the dash! Free cremation with every accident!
Do you have the Haynes car manuals in Germany? It didn't go down well when I suggested that my friend sell all his car manuals and replace them all with a single copy of "Rust treatment for dummies"
If anyone wrote a book on Rover it would have to titled "How to snatch defeat from the jaws of certain victory".
-
Do you have the Haynes car manuals in Germany?
Sorry, I don't understand
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
A Haynes manual is a maintenance guide for a car based on a complete strip down of a vehicle.
In theory you could buy a Haynes manual and completely rebuild your car from the ground up although it is intended to allow you to service your own vehicle.
In practice there is a right of passage that involves skinned and bleeding knuckles, a rounded off socket set and a spotted sobbing youth desperately wondering how he is going to get his car back together in time for work on a Monday morning.
-
Sorry, I'm the wrong person for this. I never really cared about cars. I know where to fill up gasoline, where to look for oil and that's it. For me a car is something I use, not worship. In apparent contrast to most of the people who incidentally happen to live in the same country than me.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Thanks guys, I'm starting with:
Guru's Guide to SQL Server Architecture and Internals
pretty excited about it too: w00t:
I'm such a geek, I'm actually excited about getting a manual! Carpe Dium!
Charismaniac Hog,Matthew Spare
ithinkdesigns.com -
Anything that comes through the post that isn't a bill or junk mail is something to get excited about.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply