Beginning SQL Server 2005 Programming (Programmer to Programmer) Paperback – 24 Feb 2006
Customers also shopped for
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?
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.
From the Back Cover
Covering all the fundamentals of SQL Server 2005, this developer–oriented guide begins with an exploration of the foundation objects of SQL. Each chapter builds on the previous one, gradually progressing to increasingly advanced topics. By the time you′ve completed this book, you will be prepared to perform as an efficient SQL Server 2005 programmer, and, when ready, move on to the more advanced Professional title.
What you will learn from this book
- The various user–defined functions and triggers
- How to create and change tables
- Ways to manage keys, write scripts, and work with stored procedures
- Techniques for programming with XML
- How to use Reporting Services and Integration Services
- The different peripheral features of SQL
Who this book is for
This book is for Microsoft database developers of all levels who are looking for an authoritative resource for core syntax, systems, and strategies for the 2005 release of SQL Server.
Wrox Professional guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.See all Product description
There was a problem filtering reviews right now. Please try again later.
It does not cover SSIS, which is SQL Server 2005's replacement for DTS packages, except at an extremely basic level. It does not go in-depth on many new T-SQL language features, including the PIVOT/UNPIVOT operators. It skims over the complex features, which makes sense since it's a book for beginners, but it does claim to be useful to experienced programmers new to SQL Server 2005. I don't agree; experienced programmers will have most of their questions answered by the books online and there are books you can buy that specifically cover SSIS, analysis services, etc. So experienced programmers don't really need this book at all.
If you're on SQL Server 2005 and you are brand new to database programming then this book will be incredibly useful. If you're already familiar with SQL Server 2000, I'd give this book a miss. Maybe the Professional book (due in a few months) will be more useful. The book is incredibly well-written and very clear and easy to understand, and Vieira's conversational tone makes it pleasant to read. It doesn't seem forced; many tech authors try way too hard to make dry material interesting or funny. That isn't the case here.
The book is targeted at newbies like myself with no prior experience of SQL before. It is very clear and concise resulting in my having to re-read chapters or sections again very rarely.
The only slight negative is a paucity of end of chapter exercises upon which to practise the techniques that the chapter has just covered.
Having spent a good few hours browsing through a variety of introductory texts on SQL before deciding which one to buy, I believe this one does a very good job and can strongly recommend it.
Most helpful customer reviews on Amazon.com
This book is fantastic. Because of the nature of my job I've read a large technical book (500+ pages) every couple of months for years now and this is the best written book I can remember since reading Mark Minasi's "Master Windows 2000 Server" 5 years ago.
This is a beginning book and thus if you have programming and/or SQL Server experience you will probably find more detail than you need--I'd rather have more than less! However, I think it is misleading to think of it merely as a beginning book. After reading it there was little I found in my organization's professionally developed small to medium databases that I do not now understand. I'm sure there is much more to learn when dealing with highly distributed massive databases, but if you're at that level you're certainly not reading this review! After reading this book, I'm now able to create my own custom built databases which read data from our professionally developed databases. For example, I've created custom databases which use our SQL Server based personnel database as the source for basic employee info, thus my custom database does not have to deal with replicating employee information as this information is pulled directly from the source database. I also now know everything I need on the SQL Server side for the small ASP applications I'm creating.
It's hard to put my finger on what I most like about the book. The best term I can come up with is balance. It provides a great balance between background theory and discussion of practical examples. Vieira has a great sense for knowing when discussing theory is the best way to explain something versus knowing when to jump right into an example. The other thing I really like about the book is that his real-world experience is apparent on every page. This book is not just a dry "this is how this function works" book. The book is filled with best practices and small gray boxes which warn of possible pitfalls. He is also not afraid to give his own opinion about possibly controversial issues, but he does so in italics to make it clear he is giving his opinion and he also very clearly states his reasons for his opinion.
In one sentence, I like this book because reading it felt like I was having a private tutoring session with an experienced SQL programmer.