Customer Reviews

Beginning Visual Basic SQL Server 7.0

5 star:		(13)
4 star:		(7)
3 star:		(1)
2 star:		(1)
1 star:		(3)

 

 

First of all, this book definitely is not an introduction book for Visual Basic. I'd like to give this book 5+ stars if I could. It is not only an EXCELLENT introduction book for MS SQL 7.0 and ADO, but also an EXCELLENT introduction book for how to write the stored procedures and how to use or call a stored procedure in your VB code. I have been looking for a good introduction book for how to write and use the stored procedures with VB for a long time. Finally, I got this one. I really like the Chapter 8: Stored Procedures vs T-SQL Statements. It shows you for a same task in two different ways to do it. One is Stored Procedures, the other one is T-SQL Statements. The side-by-side comparisons of stored procedure and SQL statement is a wonderful idea, especially good for beginner. Mr. Thearon Willis really understands the definition of BEGINNING.

This book is one of the best I've found to learn SQL 7.0 by. Don't let the "Visual Basic" part confuse you. The book is a practical guide on all aspects of SQL 7.0 from installation, database creation, and data manipulation, to the application of the concepts in real-world application examples. The explanations are step-by-step, thorough and very clear so that a novice user can understand fully and quickly become able to create and deploy SQL databases. And once you're ready for more, Vieira's "Professional SQL Server 7.0" is a great follow-up book to this one.

The title of the book is not beginning visual basic, it is beginning visual basic sql server 7. If people are looking for a book to learn visual basic, do not look here. If you are look for the best introduction to sql server and vb programming, then GET THIS BOOK! The examples are well thought out and are actually practical! The author does actually normalize the intro database correctly as you could have both husband and wife (ie, same address) in the database. this book is the best intro to sql server there is!

If you are already a VB programmer and want to learn SQL Server 7 AND ADO, give this book a try. Read it cover to cover - when you are done with it, you will be amazed at what you have learned. We programmers need more books written in this vein. My only complaint is that there could be more in-depth discusion on which is the best ADO method to use for a given scenario of data and queries to the data. By the way, I hope you like to type... alot of it to do with this book. WROX must like to cut costs by eliminating the CD and using a font between 6 pt. and 7 pt. I guess you can get by if you are on the net. Just pick out an ADO approach you like and stick with it? More discussion is needed on which syntax should be used for a given set of circumstances. Still a great book though!

I've been a software engineer for just over 20 years now, and to this date, this author is by far, the most talented author, I've encountered. The book covers all that is required, for a Visual Basic developer, to learn the tasks associated with building applications for Visual Basic using SQL. With other books, it never failed that the author would leave something important out, when demonstrating a technique, but the author of this book, Thearon Willis, covers everything, down to the intimate detail. Thearon also has reminders through out the book, that remind the reader not to forget to do something, that may have already been covered. I believe the author has the ability to convey upon the reader, in an understandable manner, like no other author has.

Many Thanks

For a non-expert in programming this is a very well paced and easy book to read and understand. It also, after 8 chapters, has very few, if any, errors. A very enjoyable book.

The author does an excellent job of using examples to help you learn difficult material. I mainly use this book as a reference guide and it has not left my desk since I bought it. This book is not for those just starting to learn the VB language. This book is for someone who knows the language and wants to learn how to incorporate SQL Server Functionality into their application. Overall this book is worth every penny.

The author shows several professional ways to build reliable, stable database applications. The subject is not easy so I don't think this is a book for beginners. I have several years experience in administering other DBMSs so I came along with this book and even more this book was the base for my first "real-life" SQL-Server7-VB6 application. But I have to admit that it is not easy to work with that book because the presentation and the arrangement of the contents could be better.

Thearon Willis's approach is pretty straight forward, and that's what I like. In short this book gets a solid positive review and has minor peeves.

In short this is a great intro to SQL server 7. Good use of explaining triggers, and stored procedures. Most important the examples are REAL WORLD BUSINESS examples that you can use. So many other books get you to do things that are totaly useless.

While I wouldn't design and interface like he did, or make the tables, as such, and I did find his stored procedures a bit overly lengthy, it's still a great book to get started on and has a lot of usefull stuff. Knowing VB helps but not neccesary and is of course not concentrated on either..

solid 4, Another good Wrox book.

Great book. I had a very good understanding of VB and Access but had no experience whatsoever with SQL Server. I am halfway through the book and could not be more happy with the results. But there is a word of warning: You need to understand relational databases and VB. You will struggle if you don't understand what a foreign key is, and some of the examples use VB class objects with the assumption you've done it before. If this doesn't scare you off, you will worship this book.