SQL Server 2012 Data Design and Retrieval (Volume 0)

Hotek, Mike

Published by CreateSpace Independent Publishi, 2013
ISBN 10: 1482730065 / ISBN 13: 9781482730067
Used / Paperback / Quantity Available: 0
From HPB-Ohio (Dallas, TX, U.S.A.)
Available From More Booksellers
View all  copies of this book

About the Book

We're sorry; this specific copy is no longer available. AbeBooks has millions of books. We've listed similar copies below.

Description:

Item may show signs of shelf wear. Pages may include limited notes and highlighting. Includes supplemental or companion materials if applicable. Access codes may or may not work. Connecting readers since 1972. Customer service is our top priority. Bookseller Inventory # mon0000740271

About this title:

Synopsis: What you need to get the job done. The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying data. I no longer have a publisher making me stay away from all of the advanced topics. If you bought one of my prior books and quickly found yourself outgrowing it, this one is MUCH different. SQL Server professionals of all levels will find something in this book which will impact the way you design databases and manage data. This is the most in-depth book I have ever written on SQL Server. This book takes you on a tour from the basics through the advanced details delivering a reference which you can employ in solving the real-world problems faced every day by database professionals. Each topic is reinforced with detailed exercises taken from real customer implementations. All of the content is updated for SQL Server 2012 SP1 and includes the new features which were introduced. Each topic starts with the basics, giving beginners a good starting point, and then drills down to the advanced details which will interest even the most seasoned SQL Server professionals. This book is also a great starting point for the 70-461 Querying Microsoft SQL Server 2012 certification exam. I believe in learning the material for your job and using an exam to verify mastery. If you are simply looking for a cookbook to pass an exam, this isn't the book for you. If you want to really learn SQL Server and be able to apply it to your job, you've found the right book. We start with a brief overview of SQL Server and walk you through getting everything you need for the examples installed. Once installed, the structure of a database is covered including details on FILESTREAM storage and how it works in SQL Server 2012. After getting through the pre-requisites, Chapter 5 becomes the launch point for a tour de force through designing, mainpulating, and querying data. You will get a very detailed discussion of all of the data types and specifically when and how to use them with examples that show you why a FLOAT is actually more accurate than a DECIMAL. Mike also explains, how to REALLY design a database without all of the baffling technobabble. Once we have some tables, we dive into a detailed discussion of the on-disk storage mechanisms, how a row is actually stored, and how to compute the real space consumption. You learn all of the ins and outs of manipulating data, including how to manipulate trees and subtrees within a hierarchy. The concurrency chapter provides an in-depth view into everything having to do with transaction management. If that wasn't enough, we then take you through basic, intermediate, and advanced querying applying everything that you could think of doing with a SELECT statement, inlcuding 20+ pages on window functions and querying XML on the way to a deep dive into spatial data. After finding out how to write a SELECT statement to find the nearest Starbucks, we finish off the book with a 150+ page dissertation on SQL Server indexes. You'll drill through every component of every type of index, including an explanation of how statistics are actually built with some examples on how the stats can have a completely unexpected effect on your query plans. The book finishing not just with partitioning but a real world implementation which very few DBAs even know how to do on the way to explaining just why something as simple as the nullability of a column can double the number of processor cycles your queries require.

About the Author: Mike Hotek is a SQL Server professional and best-selling author of 9 SQL Server books, with a depth and breadth of experience few can match. He has over 30 years of experience developing application using a variety of programming languages and over 20 years of experience building database solutions. His solutions span virtually every business sector and are among the largest, most complex solutions ever deployed. In his more than 2 decades, he has built solutions encompassing every SQL Server feature and blending those with a variety of other platforms and services. He has been teaching and writing about SQL Server for more than 15 years and has been on the leading edge (and sometimes beyond the bleeding edge) of the processes and techniques used throughout the industry today.

"About this title" may belong to another edition of this title.

Bibliographic Details

Title: SQL Server 2012 Data Design and Retrieval (...
Publisher: CreateSpace Independent Publishi
Publication Date: 2013
Binding: Paperback
Book Condition: Good

Top Search Results from the AbeBooks Marketplace

1.

Mike Hotek
Published by CreateSpace Independent Publishing Platform (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
Used Softcover First Edition Quantity Available: 1
Seller:
GlassFrogBooks
(Minden, NV, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform, 2013. Condition: Good. A+ Customer service! Satisfaction Guaranteed! Book is in Used-Good condition. Pages and cover are clean and intact. Used items may not include supplementary materials such as CDs or access codes. May show signs of minor shelf wear and contain limited notes and highlighting. Seller Inventory # 1482730065-2-4

More information about this seller | Contact this seller

Buy Used
US$ 15.04
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Mike Hotek
Published by CreateSpace Independent Publishing Platform (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
Used Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform, 2013. Paperback. Condition: Used: Good. 1. Seller Inventory # SONG1482730065

More information about this seller | Contact this seller

Buy Used
US$ 10.08
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

3.

Hotek, Mike
Published by CreateSpace Independent Publis (2018)
ISBN 10: 1482730065 ISBN 13: 9781482730067
New Paperback Quantity Available: > 20
Print on Demand
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publis, 2018. Paperback. Condition: New. Never used! This item is printed on demand. Seller Inventory # 1482730065

More information about this seller | Contact this seller

Buy New
US$ 40.85
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

4.

Hotek, Mike
Published by CreateSpace Independent Publishing Platform (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
New Paperback Quantity Available: 10
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform, 2013. Paperback. Condition: New. Seller Inventory # INGM9781482730067

More information about this seller | Contact this seller

Buy New
US$ 37.94
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

5.

Hotek, Mike
ISBN 10: 1482730065 ISBN 13: 9781482730067
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description 2013. PAP. Condition: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9781482730067

More information about this seller | Contact this seller

Buy New
US$ 40.15
Convert Currency

Add to Basket

Shipping: US$ 12.54
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Hotek, Mike
Published by Createspace (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Createspace, 2013. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9781482730067

More information about this seller | Contact this seller

Buy New
US$ 40.66
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

7.

Mike Hotek
Published by Createspace, United States (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
New Paperback Quantity Available: 10
Print on Demand
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Createspace, United States, 2013. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****. What you need to get the job done. The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying data. I no longer have a publisher making me stay away from all of the advanced topics. If you bought one of my prior books and quickly found yourself outgrowing it, this one is MUCH different. SQL Server professionals of all levels will find something in this book which will impact the way you design databases and manage data. This is the most in-depth book I have ever written on SQL Server. This book takes you on a tour from the basics through the advanced details delivering a reference which you can employ in solving the real-world problems faced every day by database professionals. Each topic is reinforced with detailed exercises taken from real customer implementations. All of the content is updated for SQL Server 2012 SP1 and includes the new features which were introduced. Each topic starts with the basics, giving beginners a good starting point, and then drills down to the advanced details which will interest even the most seasoned SQL Server professionals. This book is also a great starting point for the 70-461 Querying Microsoft SQL Server 2012 certification exam. I believe in learning the material for your job and using an exam to verify mastery. If you are simply looking for a cookbook to pass an exam, this isn t the book for you. If you want to really learn SQL Server and be able to apply it to your job, you ve found the right book. We start with a brief overview of SQL Server and walk you through getting everything you need for the examples installed. Once installed, the structure of a database is covered including details on FILESTREAM storage and how it works in SQL Server 2012. After getting through the pre-requisites, Chapter 5 becomes the launch point for a tour de force through designing, mainpulating, and querying data. You will get a very detailed discussion of all of the data types and specifically when and how to use them with examples that show you why a FLOAT is actually more accurate than a DECIMAL. Mike also explains, how to REALLY design a database without all of the baffling technobabble. Once we have some tables, we dive into a detailed discussion of the on-disk storage mechanisms, how a row is actually stored, and how to compute the real space consumption. You learn all of the ins and outs of manipulating data, including how to manipulate trees and subtrees within a hierarchy. The concurrency chapter provides an in-depth view into everything having to do with transaction management. If that wasn t enough, we then take you through basic, intermediate, and advanced querying applying everything that you could think of doing with a SELECT statement, inlcuding 20+ pages on window functions and querying XML on the way to a deep dive into spatial data. After finding out how to write a SELECT statement to find the nearest Starbucks, we finish off the book with a 150+ page dissertation on SQL Server indexes. You ll drill through every component of every type of index, including an explanation of how statistics are actually built with some examples on how the stats can have a completely unexpected effect on your query plans. The book finishing not just with partitioning but a real world implementation which very few DBAs even know how to do on the way to explaining just why something as simple as the nullability of a column can double the number of processor cycles your queries require. Seller Inventory # APC9781482730067

More information about this seller | Contact this seller

Buy New
US$ 46.00
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Mike Hotek
Published by Createspace, United States (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
New Paperback Quantity Available: 10
Print on Demand
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Createspace, United States, 2013. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****.What you need to get the job done. The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying data. I no longer have a publisher making me stay away from all of the advanced topics. If you bought one of my prior books and quickly found yourself outgrowing it, this one is MUCH different. SQL Server professionals of all levels will find something in this book which will impact the way you design databases and manage data. This is the most in-depth book I have ever written on SQL Server. This book takes you on a tour from the basics through the advanced details delivering a reference which you can employ in solving the real-world problems faced every day by database professionals. Each topic is reinforced with detailed exercises taken from real customer implementations. All of the content is updated for SQL Server 2012 SP1 and includes the new features which were introduced. Each topic starts with the basics, giving beginners a good starting point, and then drills down to the advanced details which will interest even the most seasoned SQL Server professionals. This book is also a great starting point for the 70-461 Querying Microsoft SQL Server 2012 certification exam. I believe in learning the material for your job and using an exam to verify mastery. If you are simply looking for a cookbook to pass an exam, this isn t the book for you. If you want to really learn SQL Server and be able to apply it to your job, you ve found the right book. We start with a brief overview of SQL Server and walk you through getting everything you need for the examples installed. Once installed, the structure of a database is covered including details on FILESTREAM storage and how it works in SQL Server 2012. After getting through the pre-requisites, Chapter 5 becomes the launch point for a tour de force through designing, mainpulating, and querying data. You will get a very detailed discussion of all of the data types and specifically when and how to use them with examples that show you why a FLOAT is actually more accurate than a DECIMAL. Mike also explains, how to REALLY design a database without all of the baffling technobabble. Once we have some tables, we dive into a detailed discussion of the on-disk storage mechanisms, how a row is actually stored, and how to compute the real space consumption. You learn all of the ins and outs of manipulating data, including how to manipulate trees and subtrees within a hierarchy. The concurrency chapter provides an in-depth view into everything having to do with transaction management. If that wasn t enough, we then take you through basic, intermediate, and advanced querying applying everything that you could think of doing with a SELECT statement, inlcuding 20+ pages on window functions and querying XML on the way to a deep dive into spatial data. After finding out how to write a SELECT statement to find the nearest Starbucks, we finish off the book with a 150+ page dissertation on SQL Server indexes. You ll drill through every component of every type of index, including an explanation of how statistics are actually built with some examples on how the stats can have a completely unexpected effect on your query plans. The book finishing not just with partitioning but a real world implementation which very few DBAs even know how to do on the way to explaining just why something as simple as the nullability of a column can double the number of processor cycles your queries require. Seller Inventory # APC9781482730067

More information about this seller | Contact this seller

Buy New
US$ 47.17
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Mike Hotek
Published by CreateSpace Independent Publishing Platform
ISBN 10: 1482730065 ISBN 13: 9781482730067
New Paperback Quantity Available: > 20
Print on Demand
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform. Paperback. Condition: New. This item is printed on demand. 526 pages. Dimensions: 9.5in. x 7.4in. x 1.5in.What you need to get the job done. The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying data. I no longer have a publisher making me stay away from all of the advanced topics. If you bought one of my prior books and quickly found yourself outgrowing it, this one is MUCH different. SQL Server professionals of all levels will find something in this book which will impact the way you design databases and manage data. This is the most in-depth book I have ever written on SQL Server. This book takes you on a tour from the basics through the advanced details delivering a reference which you can employ in solving the real-world problems faced every day by database professionals. Each topic is reinforced with detailed exercises taken from real customer implementations. All of the content is updated for SQL Server 2012 SP1 and includes the new features which were introduced. Each topic starts with the basics, giving beginners a good starting point, and then drills down to the advanced details which will interest even the most seasoned SQL Server professionals. This book is also a great starting point for the 70-461 Querying Microsoft SQL Server 2012 certification exam. I believe in learning the material for your job and using an exam to verify mastery. If you are simply looking for a cookbook to pass an exam, this isnt the book for you. If you want to really learn SQL Server and be able to apply it to your job, youve found the right book. We start with a brief overview of SQL Server and walk you through getting everything you need for the examples installed. Once installed, the structure of a database is covered including details on FILESTREAM storage and how it works in SQL Server 2012. After getting through the pre-requisites, Chapter 5 becomes the launch point for a tour de force through designing, mainpulating, and querying data. You will get a very detailed discussion of all of the data types and specifically when and how to use them with examples that show you why a FLOAT is actually more accurate than a DECIMAL. Mike also explains, how to REALLY design a database without all of the baffling technobabble. Once we have some tables, we dive into a detailed discussion of the on-disk storage mechanisms, how a row is actually stored, and how to compute the real space consumption. You learn all of the ins and outs of manipulating data, including how to manipulate trees and subtrees within a hierarchy. The concurrency chapter provides an in-depth view into everything having to do with transaction management. If that wasnt enough, we then take you through basic, intermediate, and advanced querying applying everything that you could think of doing with a SELECT statement, inlcuding 20 pages on window functions and querying XML on the way to a deep dive into spatial data. After finding out how to write a SELECT statement to find the nearest Starbucks, we finish off the book with a 150 page dissertation on SQL Server indexes. Youll drill through every component of every type of index, including an explanation of how statistics are actually built with some examples on how the stats can have a completely unexpected effect on your query plans. The book finishing not just with partitioning but a real world implementation which very few DBAs even know how to do on the way to explaining just why something as simple as the nullability of a column can double the number of processor cycles your queries require. This item ships from La Vergne,TN. Paperback. Seller Inventory # 9781482730067

More information about this seller | Contact this seller

Buy New
US$ 54.96
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

10.

Hotek, Mike
Published by CreateSpace Independent Publishing Platform
ISBN 10: 1482730065 ISBN 13: 9781482730067
New PAPERBACK Quantity Available: > 20
Seller:
Russell Books
(Victoria, BC, Canada)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform. PAPERBACK. Condition: New. 1482730065 Special order direct from the distributor. Seller Inventory # ING9781482730067

More information about this seller | Contact this seller

Buy New
US$ 44.99
Convert Currency

Add to Basket

Shipping: US$ 7.00
From Canada to U.S.A.
Destination, Rates & Speeds

There are 2 more copies of this book

View all search results for this book