- Paperback: 1440 pages
- Publisher: John Wiley & Sons (15 Nov 2000)
- Language English
- ISBN-10: 0764543792
- ISBN-13: 978-0764543791
- Product Dimensions: 23.1 x 18.4 x 6.7 cm
- Average Customer Review: 5.0 out of 5 stars See all reviews (11 customer reviews)
- Amazon Bestsellers Rank: 617,380 in Books (See Top 100 in Books)
- See Complete Table of Contents
Professional SQL Server 2000 Programming
and over 900,000 other books are available for Amazon Kindle .
Learn more
| ||||||||||||||||||
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 Amazon.co.uk Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Amazon.co.uk Review
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.
Product Description
What is this book about?
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 for OLAP and data mining.
Professional SQL Server 2000 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 wanting to add programming skills to your DBA knowledge, you′ll find what you need in this book to get to grips with SQL Server 2000 development.
What does this book cover?
Here are just a few of the things covered in this book:
- 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
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 as it affects the SQL Server developer.
Inside This Book
(Learn More)
First Sentence
SQL Server 7.0 was a major leap forward from SQL Server 6.5. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
SQL Server 7.0 was a major leap forward from SQL Server 6.5. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
16 of 16 people found the following review helpful:
5.0 out of 5 stars
A must read book,
By
This review is from: Professional SQL Server 2000 Programming (Paperback)
If you want to know about SQL Server - BUY THIS BOOK. I have read a few SQL Server books and NOTHING comes close to this book. The descriptions are clear, the examples precise. Page after page are littered with valuable, hard won, information. The authors has extensive knowledge of SQL Server and it shines though. A man who understands the subject matter and can explain it ... a rare thing in my experience. If you read one book about SQL Server, make it this one. Also, if you are using SQL Server 7, don't be put off, most of what is said applies to '7' and most differences between '7' and '2000' are clearly explained.
10 of 10 people found the following review helpful:
5.0 out of 5 stars
Well worth the money,
By A Customer
This review is from: Professional SQL Server 2000 Programming (Programmer to Programmer) (Paperback)
I have just got this book the other day, and for the price it is I can defiantly say it is well worth the money. I had never used SQL Server before and only used Access in the past, this is a perfect book for learning SQL Server 2000 - The first few chapters set the ground work and is a bit boring as your keen to get to the pratical parts but you need to do it and is worth reading so the rest makes sense. Very nice examples, easy to follow. Another great book from Wrox to add to my collection.
8 of 8 people found the following review helpful:
5.0 out of 5 stars
A great introduction to SQL Server and T/SQL,
By A Customer
This review is from: Professional SQL Server 2000 Programming (Paperback)
As an experienced C++/Java developer with limited database experience I found this book to be really useful. It was pitched at the right level for me. I was initialy a little put off by the 'Professional' tag, I assumed it would require some previous knowledge of SQL Server. Instead the 'professional' should be taken to mean 'Software professional' rather then database specialist.It's pretty big, but remarkabley easy to read. Well written in a friendly in style without being patronising or dumbed-down.
Share your thoughts with other customers: Create your own review
Would you like to see more reviews about this item?
|
Most Recent Customer Reviews |
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Languages & Tools
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
Look for similar items by subject
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.
|
