Review

Murach's SQL Server 2016 is written for professional application developers who need to work with SQL Server databases. It's also a good choice for anyone needing to learn SQL, since SQL is the standard scripting language for any database management system.

You will learn how to use SQL Server 2016 and Management Studio interface to run SQL statements on your computer. You'll learn how to retrieve data from the database, as well as how to add, edit, and delete data.

Later you will learn how to design and create a database by using either SQL statements or the Management Studio interface.

In the final section you will learn the advanced skills that give your database much of it's power. These features include, views, scripts, stored procedures, functions, triggers, and transactions. Also included in this section is database security, XML,BLOBs, and CLR integration.

If you're looking for one book that will provide you will a solid foundation and reference to working with SQL Server, then Murach's SQL Server 2016 is the book for you.

You may read other reviews for this book at Amazon.com.

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 work with 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 Managment 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