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.
Book Description
Product Details
Would you like to update product info or give feedback on images?
|
Product Description
From Amazon
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 Publisher
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.
Get up to speed on SQL Server 2000 and how to take full advantage of new features
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
By A Customer
Format:Paperback
Who said you can find all the contents from Book On line? Does Book On Line has the same easy to follow structure plus the good examples that really help to learn and pratice? My confidence on SQL trippled after finishing only half of the book.
By A Customer
Format:Paperback
There is nothing in this book that you cannot find in many readily available sources mostly the Books Online. I learned nothing from this book and neither would most people. After reading this book one thing is certain: These authors have never built truly complex Sql applications. If you are a beginner get this book. If not keep looking.
Format:Paperback
This is an excellent book for average/advanced programmers who
want to review and learn all about SQL Server 2000 basics with very good and very concise,very clear examples.I recommend this book for people preparing for the Microsoft 70-229 database design and implementation.A must READ. I thank the authors.
want to review and learn all about SQL Server 2000 basics with very good and very concise,very clear examples.I recommend this book for people preparing for the Microsoft 70-229 database design and implementation.A must READ. I thank the authors.
Want to see more reviews on this item?
›
Go to Amazon.com to see all 22 reviews
4.4 out of 5 stars
Most recent customer reviews
5.0 out of 5 stars
Excelent
The book is super new and the delivery was too fast
Published on Aug 6 2003 by Sameer Alzouby
5.0 out of 5 stars
Excelent
The book is super new and the delivery was too fast
Published on Aug 6 2003 by Sameer Alzouby
5.0 out of 5 stars
Excelent, the best you can buy !!!
I have been working more than four years with SQL Server, since version 6.5. In my work I have to cover all the funcionality in SQL Server as I am developer, administrator and so... Read more
Published on Oct 30 2002 by ENRIQUE
2.0 out of 5 stars
Disappointed
You know one of those reference books you buy but no matter how often you look at it it never has the answer to your questions? Yes? Well this book is one of those. Read more
Published on Aug 20 2002 by Mel Mullen
5.0 out of 5 stars
Super Solid Intro to SQL Server Programming
Although not entirely sufficient as preparation for the SQL Server Design exam, it certainly helped me along that path, and in a much more enjoyable way than many of those dry... Read more
Published on May 31 2002 by Daniel C. Upton
5.0 out of 5 stars
Great all-purpose SQL Server developer's book
I bought this book at the same time I got Veria's book and this one is by far the better of the two. Read more
Published on Mar 16 2002 by Joe Hornsby
5.0 out of 5 stars
Great Book, Great Examples
When we needed to get up to speed on SQL Server 2000, we wrestled with the pros and cons of several books before deciding on this one. Read more
Published on Jan 3 2002 by Polar Bear
5.0 out of 5 stars
Excellent reference for any DBA
This book is an excellent reference for anyone needing assistance on stored procedures, triggers, cursors, or TSQL. The detail very good and the examples helpful. Read more
Published on Dec 17 2001 by John Madison
5.0 out of 5 stars
A must buy!
The most comprehensive, the most thorough, and the one book I can use in training.
Published on Aug 27 2001 by Anna
5.0 out of 5 stars
Finally!!
I have finally found an author and book that are outstanding in the T-SQL arena. I have been searching for the last 2 years for a book I could teach an Introductory College level... Read more
Published on Aug 2 2001 by Frank
Listmania!
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Networking > Data in the Enterprise > Client-Server Systems
- Books > Computers & Technology > Programming
- Books > Computers & Technology > Software > Databases
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > New & Used Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > New & Used Textbooks > Computer Science & Information Systems > Programming Languages
- Books > Qualifying Textbooks - Fall 2007 > Computers & Internet
Feedback
Would you like to update product info or give feedback on images?
|
