murach's SQL server 2016 for developers - Bryan Syverson

If you are an application developer, or you are training to be one, this 2016 edition of Murachs 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 will 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 will be able to create database applications that are thoroughly professional. You will be familiar with the DBA-related issues that let you work far more effectively than most of your colleagues. And you will have a handy reference at your side to answer questions and handle new challenges as they come up.