SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details. Special Offer until June 30, 2013: Receive an additional £5 promotional Gift Certificate, when you trade-in at least £10 worth of books. Learn more. |
Book Description
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
Product Description
Amazon Review
Ideal for the database programmer or system DBA, Microsoft SQL Server 2000 Programming by Example is an excellent example-based tutorial on mastering today's SQL features. Packed with plenty of tips and tricks, this title will let almost anyone do more with SQL Server.
While there are plenty of screen shots showing graphical SQL Server tools, the focus of this book is clearly on learning real command-line Transact-SQL (T-SQL). The authors provide a patient and very thorough tour of T-SQL with full coverage of both basic and advanced features. You'll learn how to define new tables, manage users in groups, as well as perform all kinds of queries. Stand-out material includes an excellent guide to SQL data types and how to choose the right one for your needs. When it comes to queries, the book does a great job of exploring all your options for joining relational data, as well as grouping data for more advanced reporting. True to its title, Microsoft SQL Server 2000 Programming by Example is filled with dozens of examples of SQL commands (and the results) so that you can try out this material for yourself and really learn the language thoroughly.
Later on, the authors turn toward server-side programming with a digestible guide to creating stored procedures and triggers. The book closes with an in-depth guide to the issues regarding cursors (for working with table data), transactions and locking. Sections on bulk copy tools and the Microsoft Data Transformation Services (DTS) show how to move data around the enterprise. A final section of distributed queries and linked servers will help you work with different sources of data wherever it resides in your organisation.
Despite some stilted writing, the comprehensive examples in this book make it a success. It will let anyone start using basic T-SQL for the first time, as well as teach more advanced readers to master the finer points of Microsoft databases. --Richard Dragan
From the Author
SQL 2000 Programming for beginners... plus some surprises
SQL 2000 Programming for beginners... plus some surprises
SQL 2000 Programming for beginners... plus some surprises
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
Most Helpful Customer Reviews
12 of 12 people found the following review helpful
By A Customer
Format:Paperback
With previous experience (v7.0) I found this book an excellent guide to the added functionality of v2000.
It's concisely, cleanly written in a straightforward no-nonsense style. The lay out is logical and well planned with the book building nicely as you move through it.
I have also found it deep enough to fill some gaps and clarify areas that I previously felt I knew very well.
The main advantage of the book to my mind though is that it does exactly what it says on the cover - it provides pratical examples of all the concepts discussed (I have found that previous books have often left me feeling "OK, but lets see it in action!!!" including Soukup & Delaney's excellent "Inside SQL Server 7".
All round an excellent book, highly recommended at a very reasonable price.
5 of 5 people found the following review helpful
By "gixane"
Format:Paperback
This book is one of the best Technical books you can buy to learn SQL Server 2000. Very easy to follow and with some good examples. If you have used other databases such as Access, this book provides a reasonable basis to step up to a larger database system.
Offcourse you will need practical experience to fully utilize what you learn, but gives you a good basis to start. After reading this book you should have little problems. Good luck
12 of 14 people found the following review helpful
By A Customer
Format:Paperback|Amazon Verified Purchase
I wasnt sure how useful this book would be to me as I am already a MCSD & MCT with intermediate SQL Server experience. I read this book cover to cover and it managed to fill in many gaps in my general SQL Server knowledge, as well as the new features of SQL Server 2000. No subject is left uncovered, and from a developer's perspective, the "by example" approach really helps, as you can check your understanding of a topic by looking at the example. The authors style is simple and precise without being at all boring.
As for the exam, I found this a great all-round book that helped with most of the areas. (And yes I passed this morning!)
I will definitely keep this book as a handly SQL reference from now on.
7 of 10 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
One of the most important new features of Microsoft SQL Server 2000 is the introduction of XML. This feature is enormous in its importance. Guess what! No XML in this book! That's right. It refers you off to other sources.
More fool me for assuming that no book would ignore this.
0 of 1 people found the following review helpful
Format:Paperback
I didn't go through the whole book, but, got lots of useful information in stuff I needed! Very happy with it!
Would you like to see more reviews about this item?
›
Go to Amazon.com to see all 22 reviews
4.4 out of 5 stars
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Networking & Security > Network Topics > Microsoft Windows
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
