Murach’s SQL Server 2008 for Developers
When we published the first edition of this book, we heard from plenty of developers who were just starting out using Microsoft SQL Server and found this to be a great book for training.
But we also heard from a lot of experienced developers who read it and were amazed to discover how much they didn’t know about SQL. That’s why we’ve dubbed this book “the SQL book that most developers don’t even know they need.”
So whether you’re new to SQL…or whether you’ve been squeaking by with the SQL you know, never realizing how much you’re missing out on…this is the book for you.
This book is designed to teach application developers all of the skills they need to use SQL to work with a Microsoft SQL Server 2008 database. But it’s also a great first book for developers who are on the path to becoming a DBA.
Unlike most SQL Server 2008 books, this one starts by showing you how to use SQL queries to extract and update the data in a database, because that’s what every application developer needs to know first. Then, it shows how to design and implement a database, how to use powerful backend database features like views, stored procedures, functions, triggers, cursors, transactions, locking, security, and how to work with BLOB and XML data. Finally, it shows how to use the CLR integration feature to create database objects using a .NET language such as C# or Visual Basic.