What do you think?
Rate this book
Microsoft SQL Server 2012 A Beginners Guide 5/E
Get up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.
832 pages, Paperback
First published November 1, 2011
4 people are currently reading
32 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 of 1 review
November 20, 2016
I don't do SQL as part of my everyday job, so I wanted to know more about this technology. I chose this book and I was stunned how much I didn't know about SQL.
The author explains many of the concepts using SQL queries and diagrams. He has provided a custom db script with fewer number of records in about 4 tables. I found this to be good to get things going and then the author switches to the AdventureWorks database to illustrate advanced concepts like indices, joins and query optimization.
The chapter on concurrency is highly informative and I am finally able to wrap my head around optimistic and pessimistic concurrency. The book then segues into the various intricacies of transactions.
The parts detailing creation and usage of indices and query optimization are the best sections of the book. The journey of query parsing to its execution is exceptionally written which helps understand table / index scan, index seek, selectivity and column statistics very thoroughly.
The remarkable organization of this book helps clarify the concepts of SQL Server. This is definitely a must read for someone who has just gotten his hands dirty with SQL. Something tells me even experts would refer to this book a few times.
The author explains many of the concepts using SQL queries and diagrams. He has provided a custom db script with fewer number of records in about 4 tables. I found this to be good to get things going and then the author switches to the AdventureWorks database to illustrate advanced concepts like indices, joins and query optimization.
The chapter on concurrency is highly informative and I am finally able to wrap my head around optimistic and pessimistic concurrency. The book then segues into the various intricacies of transactions.
The parts detailing creation and usage of indices and query optimization are the best sections of the book. The journey of query parsing to its execution is exceptionally written which helps understand table / index scan, index seek, selectivity and column statistics very thoroughly.
The remarkable organization of this book helps clarify the concepts of SQL Server. This is definitely a must read for someone who has just gotten his hands dirty with SQL. Something tells me even experts would refer to this book a few times.
Displaying 1 of 1 review