Murach's SQL Server 2019 for Developers
Murach, Joel, Syverson, Bryan
If you're an application developer, or you're training to be one, this latest 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, and BLOB data with FILESTREAM storage.
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.