 |
Beginning SQL Server 2005 Programming View Larger Image | Robert Vieira
Wrox Press, Paperback, Published February 2006, 550 pages, ISBN 0764584332 | List Price: $39.99
Our Price: $24.95
You Save: $15.04 (38% Off)
| | | Availability: In-Stock |
Customer Reviews: 1 Average Customer Rating:   Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Professional SQL Server 2005 Reporting Services; Paul Turley, et al, $24.95, 38% Off!
- Beginning SQL Server 2005 Administration; Dan Wood, et al, $24.95, 38% Off!
- Professional SQL Server 2005 Integration Services; Brian Knight, et al, $30.95, 38% Off!
- Microsoft SQL Server 2005 Reporting Services Step by Step; Hitachi Consulting Services, et al, $28.50, 37% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
After a quick primer on database design basics and the SQL query language (for
those programmers who may be building their first database application), this
book provides an overview of SQL Server itself, which has been dramatically redesigned
with the 2005 release
Once readers have grasped the fundamentals of database design and SQL concepts,
they will then learn how to implement those concepts with Microsoft SQL Server
2005
Addresses creating and changing tables, managing keys, database normalization,
writing scripts, working with stored procedures, programming with XML, and using
SQL Server reporting and data transformation services
The companion Web site provides all of the code found in the book.
Customer Reviews
Customer Reviews: 1 Average Customer Rating: Aug 20, 2007
Very good book - probably best for those exposed to SQL
I think the author did a very good job of writing this book. Mr. Viera makes understanding SQL syntax very easy and throws in a few of the "gotchas" that one can encounter. Having said that, I also think that this book is best suited to someone who has had a bit of exposure to SQL syntax.
There isn't very much time spent on the construction of basic SELECT statements and explanations of JOINS, which will potentially throw the novice newbie way off track. I'd recommend reading "Beginning Transact-SQL with SQL Server 2000 and 2005" before tackling this book.
I'm brand new to SQL and programming in general and am at the point of having to learn more about how to write scripts and stored procedures for my expanding job duties (i'm a Data Analyst at Microsoft Xbox, about six months into the job). This book has helped tremendously by explaining batches and syntax in plain language without ambiguity. The chapter on stored procedures is nearly 50 pages and filled with great explanations.
I've enjoyed this book so much that I also purchased Robert Vierra'a companion book, "Professional SQL Server 2005 Programming". I've often referred to that book for help with writing CURSORS, which is not a topic that is easy to find in most SQL books.
I'm often very frustrated by the lack of programming books that can/do explain syntax and processes well. I've found this book to be a very bright light in a very dark tunnel and feel that Robert Vierra deserves to be congratulated.
|
|
