Book Review: Murach’s SQL Server 2016 for Developers

Book Review: Murach’s SQL Server 2016 for Developers

Murach Publishing always works hard to release books as and when the relevant software product is being updated. Murach’s SQL Server 2016 for Developers authored by Bryan Syverson and Joel Murach examines all aspects of the SQL Server 2016 in a comprehensive manner.

Murach’s SQL Server 2016 for Developers is divided into four sections comprising of 20 chapters. The first section provides a basic introduction to relational databases, SQL including the usage of the management studio.

In section 2, you will learn the steps required to retrieve data from both single and multiple tables. You will also learn the required steps involved with coding summary queries, subqueries including the working of data types and functions. You will learn how to insert, update and delete data in Chapter 7.

The first chapter of Section 3 helps you to design a database. The remaining chapters provide a detailed coverage of the steps required to create a database and tables with both SQL Statements and management studio.

If you check out Section 4, you will have to spend more time since it discusses advanced concepts. You will also to learn the use of views, scripts, stored procedures, functions, triggers, XML, BLOB in addition to management of transactions, locking and database security. The author also provides a short introduction to the CLR included with Microsoft .NET Framework.

The book also includes one appendix using which you will learn the relevant configuration steps to work with the SQL Server 2016. The section also provides alternatives to full-blown SQL Server 2016.

Each chapter begins with a detailed introduction followed by the code samples. The author has provided a description in bulleted format, which helps you to learn the concepts easily. The book also includes tables at appropriate places including the relevant syntax. The advantage of the books published by Murach is that the author has followed the same style in all chapters.

READ  Book Review - Murach's Beginning Java with NetBeans

Murach’s SQL Server 2016 for Developers will be useful for computer training centers since the book can be used for teaching courses spanning three months. The book also includes exercises, which help students to gauge their knowledge.

Murach's SQL Server 2016 for Developers Book Cover Murach's SQL Server 2016 for Developers
Database
Bryan Syverson and Joel Murach
Database
Murach Publishing
June 2016
676
978-1-890774-96-7

Leave a Reply

Your email address will not be published.