Beginning SQL Server 2000 Programming [With CDROM]

by Robin Dewson

Book Overview

Microsoft SQL Server 2000 provides enterprise-class database solutions, offering interactive development tools and complete management of your relational database applications. In this book, you'll... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1861005237
• ISBN13: 9781861005236
• Release Date: January 2001
• Publisher: Wrox Press
• Length: 771 Pages
• Weight: 2.90 lbs.
• Dimensions: 1.7" x 7.3" x 9.1"

Customer Reviews

Good book. Detailed review below...

This is an excellent beginners book. From installation through to triggers all you need to know to get up and running. Shame it is missing about User Defined Functions but I thought this was a really good book.Chapter 1 - Good coverage of the versions, whats what. Also liked the installation of SQL Server. Chapter 2 Covered areas such as Enterprise Manager well and like the Configuring section. Found out how to set some very useful propretiesChapter 3 - Query Analyzer. Went through every item that a beginner should need as well as an intermediate. Helped me figure out and set up as I wantedChapter 4 - This chapter for DB design etc is very clear and concise. I liked the Normalization section as well as relationships as to how these workChapter 5/6/7 - Enough coverage and good warnings about the system databases and building the sample db. Also loved the defining tables and the different data types and finally all about the different indexes you can have. Very useful.Chapter 8 - This was my favourite chapter as it showed how to build relationships between tables.Chapter 9 - didnt think this was really necessaryChapter 10 - Good basics of backups. Not much on network backups.Chapter 11 - Good basics again of maintenanceChapter 12 - Images!! Yes!! No-one else I know touches this. chapter 13-15 - Loved transactions in the Insert chapter. all the others cover good basics of T-SQLChapter 16 - Could have done a bit more on indexing a view but apart from that shows how to create a view well. Also how to use itChapter 17/18 - Would have liked to see more about nested stored procedures but again good coverage. Dealing with errors was my favourite partChapter 19 - XML - The way so much is going. Maybe book needs updating for SQLXML 3.0?chapter 20 - A bit advanced for beginners but triggers are a great plus.As I say, this is the best beginning SQL Server book I bought (this was my third!) and I loved the authors style and content. Wasnt confused at any point and found all that was being said to be clear. Wish I had bought it firstIts downfalls? Well images it does say you need a binary stream to input an image but doesnt show any VB code to pass it in. No UDF's or UDT's and no coverage of SQL XML 3. Dedication was interesting but a bit long....Excellent coverage on how to complete each action in any method you wish so this does lead to excellent T-SQL coverage. Loved it

Excellent book

Coming from Access I needed to move to SQL Server and this is the second book I bought on the subject. By far this is the better of the 2. Brilliant style of writing and I got up to speed very quickly. I also bought the Pro SQL Server book, which is not for beginners but there are areas now two months on within that book that it too is now becoming useful. Buying the 2 books together is the right move. However for beginners this is the book to get rather than the Professional.Well done Wrox and well done to the author for a useful compendium.

If you don't know SQL, then this is it!

If you are a beginner, then this is for you! This book take you from the SQL installation to data manipulation in a professional style. Once you finish it, you can really claimed that you know SQL 2000. In addition, this book provide you a lot of useful resources, such as other books and websites, for you to extend the SQL knowledge.

Great book for those not knowing SQL Server 2000

Bought this book as I know nothing about SQL Server 2000, or any database. Found it was written at an easy pace but great attention to detail which made everything real clear.Found I was up and running in hours and enough in the book to get me far enough so I could do what I needed to do, quickly. However, dont be fooled. It didnt treat me as stupid! It also gave me a lot of info which makes me no longer a beginner. Also cool that it had an evaluation copy of SQL Server.I dont normally like Wrox (too big!) but this might change my mind and swap over to them. Recommend it to those who know databases or not. Well done!

Great beginners book!

Just moving across from Access to SQL Server and I found this a brilliant book. Starting from the installation, through creating a database onwards it covers every aspect.The best part is that the book covers the same area from every angle so I could choose which method from the choices SQL Server 2000 gives me, suits me best. I didnt know which book to buy on the shelves in the book store, but from just opening the book at random pages the author had a great style of writing.