Murach’s SQL Server 2016 for Developers

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.

Table of Contents

Section 1 – An Introduction to SQL
Chapter 1 – An Introduction to Relational Databases and SQL
Chapter 2 – How to Use the Management Studio

Section 2 – The Essential SQL Skills
Chapter 3 – How to Retrieve Data from a Single Table
Chapter 4 – How to Retrieve Data from Two or More Tables
Chapter 5 – How to Code Summary Queries
Chapter 6 – How to Code Subqueries
Chapter 7 – How to Insert, Update, and Delete Data
Chapter 8 – How to Work with Data Types
Chapter 9 – How to Use Functions

Section 3 – Database Design and Implementation
Chapter 10 – How to Design a Database
Chapter 11 – How to Create a Database and its Tables with SQL Statements
Chapter 12 – How to Create a Database and its Tables with the Management Studio

Section 4 – Advanced SQL Skills
Chapter 13 – How to Work with Views
Chapter 14 – How to Code Scripts
Chapter 15 – How to Code Stored Procedures, Functions, and Triggers
Chapter 16 – How to Manage Transactions and Locking
Chapter 17 – How to Manage Database Security
Chapter 18 – How to Work with XML
Chapter 19 – How to Work with BLOBs
Chapter 20 – An Introduction to CLR Integration

Appendix A – How to Set Up Your Computer for This Book