What do you think?
Rate this book
Microsoft SQL Server 2016: A Beginner's Guide
Up-to-date Microsoft SQL Server 2016 skills made easy!Get up and running on Microsoft SQL Server 2016 in no time with help from this thoroughly revised, practical resource. The book offers thorough coverage of SQL management and development and features full details on the newest business intelligence, reporting, and security features.
Filled with new real-world examples and hands-on exercises, Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition, starts by explaining fundamental relational database system concepts. From there, you will learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis and BI tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.
- Revised from the ground up to cover the latest version of SQL Server - Ideal both as a self-study guide and a classroom textbook- Written by a prominent professor and best-selling author
Filled with new real-world examples and hands-on exercises, Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition, starts by explaining fundamental relational database system concepts. From there, you will learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis and BI tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.
- Revised from the ground up to cover the latest version of SQL Server - Ideal both as a self-study guide and a classroom textbook- Written by a prominent professor and best-selling author
897 pages, Kindle Edition
Published October 14, 2016
36 people are currently reading
33 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 2 of 2 reviews
April 26, 2018
I purchased this book so that I'd have a printed SQL Server reference that covers the basics of TSQL and SQL Server, without having to search Microsoft's web site or even turn on your computer.
There's really nothing special in this book. I was hoping to find some insights that might better explain some of the more complex examples that appear in Microsoft's documentation and take advantage of the author's experience in this area by going into some of the gotchas in database development.
One of my three main reasons for giving this book a low score is that it is incomplete, even at a basic level. I understand that there are better options than using cursors in modern SQL Server database development, this book doesn't even mention them. This is striking because cursors are one of only a handful of data types that T-SQL supports. Sure, there are better ways to iterate the rows in a table and do something programmatically with that data, but cursors have not been deprecated, they are still actively being used in development and I see them quite a bit in the scripts I work with in the office.
The second reason I gave this book a low score is because it is inaccurate. I found two instances where a function has an additional parameter that this book doesn't mention and I found those mistake.
Lastly, this book is worth two starts because I found no added value in any of it's examples, over what you'll find in Microsoft's programmer reference. There are no additional explanations that might improve MS Docs and no effort has been made to explain anything further than how Microsoft describes it.
There's really nothing special in this book. I was hoping to find some insights that might better explain some of the more complex examples that appear in Microsoft's documentation and take advantage of the author's experience in this area by going into some of the gotchas in database development.
One of my three main reasons for giving this book a low score is that it is incomplete, even at a basic level. I understand that there are better options than using cursors in modern SQL Server database development, this book doesn't even mention them. This is striking because cursors are one of only a handful of data types that T-SQL supports. Sure, there are better ways to iterate the rows in a table and do something programmatically with that data, but cursors have not been deprecated, they are still actively being used in development and I see them quite a bit in the scripts I work with in the office.
The second reason I gave this book a low score is because it is inaccurate. I found two instances where a function has an additional parameter that this book doesn't mention and I found those mistake.
Lastly, this book is worth two starts because I found no added value in any of it's examples, over what you'll find in Microsoft's programmer reference. There are no additional explanations that might improve MS Docs and no effort has been made to explain anything further than how Microsoft describes it.
August 5, 2018
Very dry but helpful to learn or refresh your memory of t-sql. Lacked real world advice or tips.
Displaying 1 - 2 of 2 reviews