- Amazon Student members save an additional 10% on Textbooks with promo code TEXTBOOK10. Enter code TEXTBOOK10 at checkout. Here's how (restrictions apply)
Professional SQL Server 2000 Programming Paperback – Nov 15 2000
|New from||Used from|
Special Offers and Product Promotions
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
When 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, choosing this book, Professional SQL Server 2000 Programming, could well simplify your selection process.
In addition to providing a thorough treatment of SQL Server 2000 development, Robert 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 normalisation that will go a long way for many to de-mystify the mystery of 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 is no accompanying CD, 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 to grips with SQL Server 2000 development. If you are looking for a book that combines rich content with clear explanation, then look no further than this excellent title. --Peter Lunn --This text refers to an out of print or unavailable edition of this title.
From the Publisher
This book is a revised follow on from Professional SQL Server 7.0 Programming, to address the new features of this recent release. With a general understanding of programming principles, (eg familiarity with VB, C++, VB Script) Professional SQL Server 2000 Programming provides a comprehensive overview of the new areas of SQL Server, for programmers. There is an in-depth discussion of T-SQL, the query language of Microsoft SQL Server. From basic database design concepts a tutorial explains more advanced topics and specific areas including Stored Procedures and Advanced Queries. Advanced topics - performance tuning, security and a solid description of OLAP, which is built in with SQL Server, are then introduced. The new XML features are explored to provide an understanding of this important area. With over 1,500 pages this book covers the main topics to provide an in-depth understanding of concepts and procedures, so you can get the most out of SQL Server 2000. --This text refers to an out of print or unavailable edition of this title.See all Product Description
Inside This Book(Learn More)
Top Customer Reviews
Vieira concentrates specifically on the programming aspects of SQL Server 2000 as opposed to teaching you how to administer the server. He does touch on an administration overview in chapter 30, but it's not something you'd read in order to pass an administration exam. Although the title does say "Professional", this does not mean you have to be a veteran SQL programmer to benefit from it. The earlier chapters cover the fundamentals of RDBMS technology, as well as how SQL is used in a SQL Server 2000 environment. The further you get into the book, the more you'll find subjects that are either more advanced or cover techniques you'll use in application development, such as how to build triggers and stored procedures. While you will learn all these skills within the SQL Server 2000 platform, the core technologies are transferable to just about any RDBMS. Time spent with this book will continue to pay off regardless of what database system you need to use at any given time.
While the content is technical, the writing style is conversational and approachable. It's actually quite easy to read the material and digest the concepts without trying to fight against the author's style. If you have need to work with SQL Server 2000 from a development standpoint, this is definitely a book to consider to guide you along the way.
Thanks Rob. I personally think you are the best. I wish I worked for you! You are not only a master and completely professional, but you have that magic quality of not being full of yourself in any manner and humble in fact....a very admirable trait.
A reader who is appreciative and better for your great work.
The coverage of of all other modules that come with SQL server 2000 is better than any out there and a must for a developer using SQL server 2000. I was able to write some awesome SQLXML code directly from this book that allowed us to roll out reporting to our users with no client side worries. This is the best intro to XML as you will find. Obviously XML, OLAP and other topics like this need further discussion in full editions, but the author is quick to point that out and gives you just what you need to get started and tells you the best places to find continuing information.
SQL 2000 is so different from version 7.0, this book was rightfully not titled as an edition of the 7.0 book. They are two different animals. Rob has written a followup to this book and it's correctly titled the same as the 2000 book, 2nd edition. I'm so eager for it to be in stock. It must be a very popular book. I would pay full price for it knowing it's a second edition. That is how good Rob is at doing what he does. Any new information from someone as expert as Rob is worth the price.
Don't hesitate picking this one up if you want the best SQL 2000 programming book on the market. Again, anyone knows the supporting technologies of SQL SERVER are not able to be fully covered in one book, but an solid introduction into what they can do and beyond in most cases, is essential to a book of this integrity and usefulness.
Other authors write several SQL server books, change the title slightly and sell them as new books.Read more ›
I cannot imagine a better SQL Server 2000 "bible" for developers. It's true it lacks super advanced information on performance tuning, OLAP, and DTS, but all of these topics are covered well enough for the needs of a professional developer who is not on a specialty project and is not acting as a power DBA. And to add more of such advanced details, cutting out fat to make room would not be an option, because there is no fat in this book, it is already 1400 pages because it covers everything. Unless you are already a SQL Server expert, I think you shouldn't go without this book.
Most recent customer reviews
I've read the MSPress Certification book, BOL (SQL server Books Online), and neither come close to the under standing this book gives. Read morePublished on July 14 2004
This is a very good book for sql server programmers. Not like the other books where you find lots of cut and paste from BOL. Read morePublished on July 9 2004 by ravi lobo
I agree with the reviewer Wendt, who complained that this book is too much like its earlier edition. Read morePublished on May 17 2004 by Alois van Klinken
This book covers everything a professional programmer using SQL server 2000 needs to know in just the right depth and breadth of topics. Can't beat it. Read morePublished on May 10 2004
This book has some good info, but the book itself has many flaws.
First, much of the info is copied verbatim from the 7.0 book. Read more
This book covers the client side of Sql Server application development extremely well. It covers nearly all the client side technolgies and provides real-world examples for putting... Read morePublished on May 1 2004 by Lyle Edwards
This is THE book to have on SQL Server 2000. Robert Vieira unquestionably knows his stuff and covers every aspect of SQL Server completely and thoroughly.Published on Feb. 12 2004 by Terry Smith
Like another review, I find the 'Professional' in the title inappropriate. I'm an experienced SQL developer and I quickly discovered that there was never anything in here that I... Read morePublished on Jan. 7 2004
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Networking & Cloud Computing > Data in the Enterprise > Client-Server Systems
- Books > Computers & Technology > Programming
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > Qualifying Textbooks - Fall 2007 > Computers & Internet
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages