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.
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.
