 See larger picture | Professional SQL Server 2000 Programming (Programmer to Programmer)
by
Robert Vieira
- WroxList Price: $59.99
Price at Amazon.com: $41.99
(Save
30%)
 Availability: Usually ships in 24 hours
Shipping rates and policies |
- Average Customer Review:
Based on
76
reviews.
- Amazon.com Sales Rank: 347378
|
Product Description SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services.
Professional SQL Server 2000 Programming provides a comprehensive guide to programming with SQL Server 2000, from a complete tutorial on Transact-SQL to an in-depth discussion of new features, such as indexed views, user-defined functions, and the wealth of new SQL Server features to support XML. Whether you're coming to SQL Server 2000 from another relational database management system, upgrading your existing system, or perhaps want to add programming skills to your DBA knowledge, you'll find what you need in this book to come to grips with SQL Server 2000 development.
Who is this book for:
This book is aimed at the SQL Server developer who wants to make the most out of the new features of SQL Server 2000. No knowledge of SQL Server is assumed, although in order to follow this book, you do need to have an understanding of programming basics such as variables, data types, and procedural programming. Database administration is also covered but only insofar as it affects the SQL Server developer.
What does this book cover?
* A complete introduction to Transact-SQL
* Database design issues
* Creating and using views, stored procedures, and user defined functions
* Responding to events with triggers
* Making your SQL Server secure
* Retrieving your data as XML
* An introduction to Analysis Services
* Moving data using Data Transformation Services and the bulk copy program
* Maintaining the integrity of distributed data with replication
* Querying a SQL Server database using English Query and Full-Text SearchWhen it comes to selecting computer books, deciding which book to buy can sometimes be even more confusing than the software it is written about. However, if you are looking for a book to instruct you on the use of SQL Server 2000, Professional SQL Server 2000 Programming is an excellent choice. In addition to providing a thorough treatment of SQL Server 2000 development, Rob Vieira's extensive reference also devotes quite a lot of space to covering SQL in general and issues relating to database design. Included is a complete introduction to Transact-SQL and an excellent chapter on normalization that will help demystify an over-referenced but much misunderstood database design concept. There is also in-depth information on the new features of SQL Server 2000, including indexed views, user-defined functions, and support of XML. Sadly, there's no accompanying CD-ROM, but source code for the book can be downloaded from the Wrox Web site. While you don't need any knowledge of SQL Server or database administration to make the most of this book, you will need a reasonable understanding of programming fundamentals. That said, the author's down-to-earth style makes it possible for anyone with some programming background, and the will to learn, to really get comfortable with SQL Server 2000 development. If you are looking for a book that combines rich content with clear explanation, look no further. --Peter Lunn, Amazon.co.uk
Featured Customer Reviews  Best overall SQL 2000 book,
December 03, 2006
The chapters I liked the most are:
Ch9 SQL Server Storage and Index Structures
Ch10 Views
Ch12 Stored Procedures
Ch15 Triggers
Ch16 Advanced Queries
Ch26 Full-Text Search
Ch29 Performance Tuning
All Appendixes
Noticed that I said "best overall" & "Most topics"; this book will not have an answer for very advance topics in areas like DTS, performance tuning, XML, & Analysis Services. There are great books out there if what you are looking for is not in Professional SQL Server 2000 Programming. The "Professional SQL Server 2000 DTS" is the best I have read when it comes to Data Transformation Services. For performance tuning and XML you may find books written by Ken Henderson to be among the best. For Analysis Services I have not found one book I will recommend yet.
 Not bad not good,
September 20, 2006
He does not mention about the issues with no following ANSI 92. The stored procedures and the trigger parts are really boring.
Sometimes the book is good but the author likes to move into areas he should not or he is not proficient enough. His comments on normalization and security are sometimes so strong that I tend to think that this guy is watching just one side of the coin.
Ed
Tiny font,
July 07, 2006 Excellent book, but the font is VERY small which makes reading difficult even though I do not have vision problems.One of the best!!,
May 15, 2006 I have this book and I can say it is the best SQL Server book I have ever read. It may even be the best Development/Computer book I have. Every chapter is easy to read, detailed and concise. The coverage is phenomenal. I use this for reference quite a bit. The only thing that is missing is more detail on DTS... but that is a book in itself. Un-satisfied with this book,
May 10, 2006
You might also be interested in these items...
|
|