Articles

Book Review: Murach’s SQL Server 2019 For Developers

SQL Server 2019 is the latest database language from the house of Microsoft. As a programmer, you make effective use of SQL Server 2019 to establishing connectivity with your programming environment. The SQL Server stores data in a secure manner and you can interact with the database from within the SQL Server environment. Murach Publishing is well known for the publishing of programming oriented books. We have been following Murach Publishing for the past 10 years and they are simply awesome. In this review, we will examine Murach’s SQL Server 2019 for Developers book recently published by Murach.

Murach’s SQL Server 2019 for Developers enables you to deeply understand the core fundamentals of the database programming language. The book has been authored by Bryan Syverson and Joel Murach. The book has been divided into 15 chapters comprising of four sections. The first chapter provides the basic introduction to relational databases and SQL, while the second chapter examines the usage of the Management Studio.

The Section 2 consists of 7 chapters. The third and fourth chapters cover the steps required to retrieve data from a single or multiple tables respectively. You will learn about the coding of summary queries and subqueries in the next two chapters.

With Murach’s SQL Server 2019 for Developers, you will also learn the steps required to insert, update, and delete data including the usage of data types and functions. You will learn database design and creation of a database and corresponding tables with SQL Statements. Moreover, the authors have also examined the procedure for the creation of a database and tables using the Management Studio included with SQL Server 2019.

With the help of the chapters in Section 4, you will learn the usage of views, scripts, stored procedures, functions, triggers, transactions, locking, XML, and BLOBs in addition to the management of database security. The book also includes one appendix using which you can learn the required steps that are needed to configure your computer to work with the content. The authors have examined the steps need to install SQL Server 2019 Express and SQL Server Management Studio including Visual Studio 2019 Community installation.

The book examines the content in a music way. However, I would appreciate if the author provides relevant screenshots as well while discussing the topic. Like all other Murach books, the Murach SQL Server 2019 for developer have covered the topics in a unique style. You will find the content followed by the code samples and description in bulleted format, which helps you to grasp the content easily. You will also find colored screenshots to support the learning material.

Murach’s SQL Server 2019 for Developers is a great book for emerging database programmers. Moreover, the book can also be used as study material for short term computer courses. Murach provides a special instructor kit with supplementary materials for usage in the classroom environment. You can navigate to the dedicated instructor’s site to learn more about this book and the accompanying instructor’s materials. You can also download a sample chapter from the official product page. I would suggest the publisher to provide the required content via online also including Multiple Choice Questions with instructor access so that students can learn from the comforts of home due to the COVID-19 pandemic.

Murach's SQL Server 2019 for Developers
Programming
Bryan Syverson and Joel Murach
Programming
Murach Publishing
April 2020
674

19 chapters, 674 pages, 291 illustrations

978-1-943872-57-2

Leave a Comment