- Paperback: 1138 pages
- Publisher: WROX Press Ltd (1 Sep 1999)
- Language English
- ISBN-10: 1861002319
- ISBN-13: 978-1861002310
- Product Dimensions: 23.4 x 18.5 x 5.6 cm
- Average Customer Review: 4.2 out of 5 stars See all reviews (6 customer reviews)
- Amazon Bestsellers Rank: 1,741,873 in Books (See Top 100 in Books)
- See Complete Table of Contents
| ||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Amazon.co.uk Review
Targeted at developers interested in leveraging the latest release of Microsoft SQL Server in their applications, Professional SQL Server 7.0 Programming is a well-balanced examination of SQL Server 7.0 that meets the needs of readers of all levels. As author Robert Vieira points out, "even developers who have used SQL Server for years have a lot to get to grips with".
This title offers a superb look at SQL Server, but is meant for those utilising the database features of the product rather than those responsible for administration. It does include a chapter on administration; however, its focus is on manipulating data programmatically and through the product's interactive tools.
The author's fine conversational style engages the reader and clearly illustrates procedures. He also handles the version transition from 6.5 to 7.0 well with feature comparisons between the old and new while maintaining focus on the latest release. He includes introductory chapters on the basics of relational databases for developers that are entirely new to SQL.
There isn't a CD included with this book--a trial version of SQL Server would have been nice. However, a companion Web site is available. Whether you want to get up to speed with 7.0's new features or are jumping into SQL Server for the first time, this book is a great place to start. --Stephen W. Plain, Amazon.com
Topics covered: SQL basics, relational databases, T-SQL, table creation/alteration, indexes, views, scripts, stored procedures, cursors, queries, replication, OLAP, English and full-text searches, security, performance tuning, and administration.
Synopsis
With a general understanding of programming principles, SQL Server 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 of performance tuning, security and a solid description of OLAP, which is built in with SQL Server, are then introduced. Data Transformation Services are explained in detail and Remote and Linked SQL Server Agents are covered. With over 1,000 pages this book covers the main topics to provide an in-depth understanding of concepts and procedures, so programmers can get the most out of SQL Server 7.0. Online discussion of the topics in this book available at Wrox's P2P site Whether you're coming 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 get to grips with SQL Server 7.0 development. There is no particular programming language, so you'll get as much out of the book if you're programming in C++ as you would in Visual Basic.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
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
1 of 1 people found the following review helpful
Format:Paperback
This is a great book for beginners, well written in an easy to follow style. Clear and understandable. Considering its a computer book its almost a pleasure to read.
Format:Paperback
I purchased this book because of the overwhelming recommendation from other readers. This is definitely a worthwhile investment. It has helped me understand normalisation, joins, and all other aspects of sql server and db design. I still haven't read all of it though. Excellent.
Format:Paperback
Very good, detailed book that covers most topics required to develop, administrate and maintain a SQL Server Db. The only disappointing thing is the lack of depth on more advanced features, such as text fields, DTS automation and OLAP. But generally a much better book than the average SQL book.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Some good tips
I have only been using SQL Server for a couple of years and some of the advice in this book was quite usefull. Read more
Published on 24 Nov 2000
Not as Advanced as the Professional in the title implies
I am a big fan of Wrox books particularly on Internet subjects. It is difficult to find books which cover advanced SQL Server topics well so I thought this might be the one. Read more
Published on 7 Nov 1999 by David
Good reference material
I was looking for some advanced information on programmatically calling DTS. When the book arrived I was disappointed to find that it didn't actually cover that topic (but then I... Read more
Published on 21 Oct 1999 by Andrew McKay
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 > 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.
