Beginners Guides

Question

Beginners Guides

SQLSACT

SSC-Insane

Points: 21838
More actions
September 15, 2011 at 12:24 am

#257180

Hi Guys
Where is the best place to find info/documentation on learning SQL Server from the beginning - From an administration point.
Any book/article suggestions?
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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

OTF SSCertifiable Points: 6104 More actions · Answer 1

derekr 43208 (9/15/2011)
Hi Guys
Where is the best place to find info/documentation on learning SQL Server from the beginning - From an administration point.
Any book/article suggestions?
Thanks

It all depends on your background or more to the point, how much you already know, I would say.

Have you been working with another RDBMS prior to now? If yes, then just get stuck in to Sql Server Books Online (Sql Servers Documentation) to see whats possible and spend lots of time on sites such as this one. You can complement your knowledge with Sql Administration specific books. There are quite a few of those and I'm sure there are people who will come along to make specific recommendations on those. Otherwise, hit amazon or any other online book store and do a search for books on Sql Server and read the user reviews to get a feel for what might be suitable for you.

If you have no prior knowledge of databases then its a different story. You might want to consider learning some basic database concepts before doing the above. In any case, consider online sql server forums, blogs and Sql Server Books Online an integral part of your study efforts.

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 2

Do a search on the web site here. This question comes up all the time, There are a lot of discussions about it.

I'll suggest two books. First, Itzik Ben-Gan's Introduction to TSQL Querying. Excellent book that will you teach you how to query databases correctly, right at the start. Second, I co-authored a beginners book, Beginning SQL Server 2008 Administration. It's pretty good and can take you from zero to where you know a bit.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

SQLSACT SSC-Insane Points: 21838 More actions · Answer 3

SQLSACT

SSC-Insane

Points: 21838

September 15, 2011 at 8:44 am

#1382018

Thanks

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 4

derekr 43208 (9/15/2011)
Where is the best place to find info/documentation on learning SQL Server from the beginning - From an administration point.

1- Build your own lab, meaning download and install SQL Server on your laptop or home computer.

2- Read Books On Line a.k.a. BOL initial chapters about architecture

3- Follow tutorials on provided test databases

4- Practice... practice... practice.

5- Try to answer this forum's questions, research by yourself, check your answers against the answers of the most senior members.

Hope this helps.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 5

Check these resources :

http://www.brentozar.com/best-sql-server-dba-books/

http://www.sqlservercentral.com/Books/

Thank You,

Best Regards,

SQLBuddy

Davekahn SSCommitted Points: 1840 More actions · Answer 6

Hi, Try MCTS 431 Training Kit for 2005(or2008), it helped me a lot

CBT training - there are so many available in the market

And practice practice ....