|
12 of 13 people found the following review helpful:
5.0 out of 5 stars
An excellent book, teaching you the basics of SQL Server 200, 4 Feb 2001
By A Customer
I have always liked Wrox Press books - you certainly get a lot of pages for your money and the content is generally very well written and informative.Ths book is no exception. Its geared towards giving you all the information that you need to work with SQL Server 2000 and how to integrate SQL Server 2000 into your VB applications. SQL Server has been around for many years in different forms including version 4, 6.5 and 7 - but although at the heart of the product its still a database, you can do a heck of a lot more with SQL Server 2000 than you can with any of the other versions. The book starts off showing you how to install the product, next moving on to explain the basics at the heart of SQL Server - tables, indexes, stored procedures, triggers and views... Topics such as relational database design are explained and SQL Server security. It takes you through Query Analyzer - a very good and powerful tool for developers. By now, you'll have a good understanding of the basics of the product, and the author Thearon Willis now ups the knowledge tap to go through stored procedures, joins, temporary tables, and inserting, updating, deleting data. If you've ever ready any articles from the MSDN website, you will probably have ready something about XML and how its going to be so important and useful in the future for developers. Incase you don't know, XML is a self describing data language which is made up of tags and values - similar to HTML.. Using XML you could send data from one company to another and using an XML parser, the destination company could full understand the data it receives because the data explains itself.. This is the power and benfit of XML. Microsoft have built XML into SQL Server 2000 and it works beautifully. The book describes how using a URL in IIS under Windows NT/2000, you can query a database, returning XML to the ASP page (or even direct to the client browser)... So instead of having to use someting like ADO to open your DB connection, build you SELECT statement, run it, get a recordset back, loop through each record building your output - you can do this all with XML and a hugely reduced amount of code... This is the future of web development and SQL Server 2000 and this excellent book will help you get there. As with any books, its important to realise that hands on experience compliments what you read in the book. Overall, this in my opinion is an excellent book and definately worth the money. One word of warning though... You may need to reinforce your bookshelf to hold the weight of these Wrox Press books if you buy more than a couple of them ;-)
|
With an Amazon.co.uk 
