Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Yellowdog
Starting Member
34 Posts |
 Posted - 2008-12-09 : 13:06:26
|
| I have just been assigned at work to manage the database running on sql2005 and I have no idea what I am doing. I have never done much in terms of sql but do have programming exp in c and c#. I need a good book to learn user defined functions and managing the data in the existing database, so learning how to set one up from the ground up is not a major concern for me.Any help would be great. I need a good book that is going to get me up and running while learning on the fly.Thanks in advanceJay |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-12-09 : 13:29:19
|
| Besides visakh16's suggestion on SQL basics;For sql 2005 database management, these books are very detailed on how to setup up sql 2005 from scratch. http://www.amazon.com/Self-Paced-Training-70-431-70-443-70-444/dp/0735623775/ref=sr_1_1?ie=UTF8&s=books&qid=1228847089&sr=1-1 |
 |
|
|
Yellowdog
Starting Member
34 Posts |
Posted - 2008-12-09 : 15:09:23
|
| Thanks for the replies.I am looking for a book that I can work off of that will teach me a little more in depth, more than simple searches but not as advanced as taking a certification. Perhaps I am thinking there is more that is involved but I need to learn how to create methods that will enable me to verify emails, replace data based on certain criteria. So, I am looking for an intermediate learning book. The reason I am looking for a book is I found that I learn better with a text rather than working off a web site.Thanks again and hopefully I can find something soon as I have a lot to learn and little time to do it in.Has anyone used thishttp://www.amazon.com/Microsoft-SQL-Server-2005-Unleashed/dp/0672328240/ref=pd_sim_b_26it seems like a comprehensive book but may be more than a beginner/intermediate learning tool. |
|
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-12-09 : 16:05:11
|
| The book you've linked is a pretty good reference book. It pretty much covers the BOL with additional details. here is the Book On Line: http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspxThe certificate books i've linked above are not just for advanced users, at least not the 1st book exam 70-431 Microsoft SQL Server 2005 Implementation and Maintenance. For example, in chapter 11 and 14, it talks about backup and restore processes as well as maintenance plan and jobs, which is essential for every DBA. I picked these books for you because I figured you can learn all the basics from online books while these books give you step by step practices and enhance your SQL 2005 technological knowledge. Two bird One stone. |
|
|
|
|
|
|
Need some advice on a good book