The 2019 edition of this book is available now! If you're an application developer, or you're training to be one, this 2016 edition of Murach's classic SQL Server book is made for you. To start, it presents the SQL statements that you need to retrieve and update the data in a database. These are the SQL statements that you'll use every day. Then, it shows you how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, security, XML data, BLOB data with FILESTREAM storage, and the CLR integration feature. The result? You'll be able to create database applications that are thoroughly professional. You'll be familiar with the DBA-related issues that let you work far more effectively than most of your colleagues. And you'll have a handy reference at your side to answer questions and handle new challenges as they come up.
I absolutely love this book. Everything in here is well worth reading. Even if you’re a developer or programmer who’s been at it for a bit, I still think it’s an excellent source for review. I really like how Murach’s explains things and lets you know when something isn’t exactly necessary because it’s either rarely used or it’s scope needs much further studying. Also who doesn’t love seeing their code executed beautifully by a minor change that wasn’t thought of eh?