SQL Server 2012 Data Design and Retrieval (Volume 0)

Mike Hotek

Verlag: CreateSpace Independent Publishing Platform, 2013
ISBN 10: 1482730065 / ISBN 13: 9781482730067
Gebraucht / Anzahl: 0
Verkäufer Book Deals (Lewiston, NY, USA)
Bei weiteren Verkäufern erhältlich
Alle  Exemplare dieses Buches anzeigen

Über dieses Buch

Leider ist dieses Exemplar nicht mehr verfügbar. Wir haben Ihnen weitere Exemplare dieses Titels unten aufgelistet.

Beschreibung:

This Book is in Good Condition. Clean Copy With Light Amount of Wear. 100% Guaranteed. Summary: 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. Buchnummer des Verkäufers ABE_book_usedgood_1482730065

Bibliografische Details

Titel: SQL Server 2012 Data Design and Retrieval (...
Verlag: CreateSpace Independent Publishing Platform
Erscheinungsdatum: 2013
Zustand: Used

Beste Suchergebnisse bei AbeBooks

1.

Hotek, Mike
Verlag: CreateSpace Independent Publishi (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
Gebraucht Paperback Anzahl: 1
Anbieter
HPB-Ohio
(Dallas, TX, USA)
Bewertung
[?]

Buchbeschreibung CreateSpace Independent Publishi, 2013. Paperback. Buchzustand: Good. 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. Buchnummer des Verkäufers mon0000740271

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Gebraucht kaufen
EUR 22,71
Währung umrechnen

In den Warenkorb

Versand: EUR 3,56
Innerhalb USA
Versandziele, Kosten & Dauer

2.

Hotek, Mike
Verlag: CreateSpace Independent Publishing Platform
ISBN 10: 1482730065 ISBN 13: 9781482730067
Gebraucht Paperback Anzahl: 1
Anbieter
Books Squared
(Dallas, TX, USA)
Bewertung
[?]

Buchbeschreibung CreateSpace Independent Publishing Platform. Paperback. Buchzustand: Good. Only lightly used. Book has minimal wear to cover and binding. A few pages may have small creases and minimal underlining. Buchnummer des Verkäufers G1482730065I3N00

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Gebraucht kaufen
EUR 26,37
Währung umrechnen

In den Warenkorb

Versand: Gratis
Innerhalb USA
Versandziele, Kosten & Dauer

3.

Hotek, Mike
ISBN 10: 1482730065 ISBN 13: 9781482730067
Neu Anzahl: > 20
Print-on-Demand
Anbieter
Books2Anywhere
(Fairford, GLOS, Vereinigtes Königreich)
Bewertung
[?]

Buchbeschreibung 2013. PAP. Buchzustand: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Buchnummer des Verkäufers IQ-9781482730067

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Neu kaufen
EUR 33,46
Währung umrechnen

In den Warenkorb

Versand: EUR 10,45
Von Vereinigtes Königreich nach USA
Versandziele, Kosten & Dauer

4.

ISBN 10: 1482730065 ISBN 13: 9781482730067
Gebraucht Anzahl: 1
Anbieter
BookSleuth
(Sanford, NC, USA)
Bewertung
[?]

Buchbeschreibung Buchzustand: Good. SQL Server 2012 Data Design and Retrieval. Buchnummer des Verkäufers Amz4793489

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Gebraucht kaufen
EUR 36,93
Währung umrechnen

In den Warenkorb

Versand: EUR 0,88
Innerhalb USA
Versandziele, Kosten & Dauer

5.

Hotek, Mike
Verlag: CreateSpace Independent Publishing Platform (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
Neu Paperback Anzahl: 10
Anbieter
Ergodebooks
(RICHMOND, TX, USA)
Bewertung
[?]

Buchbeschreibung CreateSpace Independent Publishing Platform, 2013. Paperback. Buchzustand: New. Buchnummer des Verkäufers INGM9781482730067

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Neu kaufen
EUR 34,88
Währung umrechnen

In den Warenkorb

Versand: EUR 3,56
Innerhalb USA
Versandziele, Kosten & Dauer

6.

Hotek, Mike
ISBN 10: 1482730065 ISBN 13: 9781482730067
Neu Anzahl: > 20
Print-on-Demand
Anbieter
Pbshop
(Wood Dale, IL, USA)
Bewertung
[?]

Buchbeschreibung 2013. PAP. Buchzustand: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Buchnummer des Verkäufers IQ-9781482730067

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Neu kaufen
EUR 37,38
Währung umrechnen

In den Warenkorb

Versand: EUR 3,56
Innerhalb USA
Versandziele, Kosten & Dauer

7.

Mike Hotek
Verlag: Createspace, United States (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
Neu Paperback Anzahl: 10
Print-on-Demand
Anbieter
The Book Depository
(London, Vereinigtes Königreich)
Bewertung
[?]

Buchbeschreibung Createspace, United States, 2013. Paperback. Buchzustand: New. 242 x 188 mm. 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. Buchnummer des Verkäufers APC9781482730067

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Neu kaufen
EUR 41,04
Währung umrechnen

In den Warenkorb

Versand: Gratis
Von Vereinigtes Königreich nach USA
Versandziele, Kosten & Dauer

8.

ISBN 10: 1482730065 ISBN 13: 9781482730067
Neu Anzahl: > 20
Print-on-Demand
Anbieter
BWB
(Valley Stream, NY, USA)
Bewertung
[?]

Buchbeschreibung Buchzustand: New. This item is Print on Demand - Depending on your location, this item may ship from the US or UK. Buchnummer des Verkäufers POD_9781482730067

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Neu kaufen
EUR 41,07
Währung umrechnen

In den Warenkorb

Versand: Gratis
Innerhalb USA
Versandziele, Kosten & Dauer

9.

Mike Hotek
Verlag: Createspace, United States (2013)
ISBN 10: 1482730065 ISBN 13: 9781482730067
Neu Paperback Anzahl: 10
Print-on-Demand
Anbieter
The Book Depository US
(London, Vereinigtes Königreich)
Bewertung
[?]

Buchbeschreibung Createspace, United States, 2013. Paperback. Buchzustand: New. 242 x 188 mm. 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. Buchnummer des Verkäufers APC9781482730067

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Neu kaufen
EUR 41,08
Währung umrechnen

In den Warenkorb

Versand: Gratis
Von Vereinigtes Königreich nach USA
Versandziele, Kosten & Dauer

10.

Hotek, Mike
Verlag: CreateSpace Independent Publishing Platform
ISBN 10: 1482730065 ISBN 13: 9781482730067
Neu PAPERBACK Anzahl: > 20
Anbieter
Russell Books
(Victoria, BC, Kanada)
Bewertung
[?]

Buchbeschreibung CreateSpace Independent Publishing Platform. PAPERBACK. Buchzustand: New. 1482730065 Special order direct from the distributor. Buchnummer des Verkäufers ING9781482730067

Weitere Informationen zu diesem Verkäufer | Frage an den Anbieter

Neu kaufen
EUR 41,36
Währung umrechnen

In den Warenkorb

Versand: EUR 6,25
Von Kanada nach USA
Versandziele, Kosten & Dauer

Es gibt 5 weitere Exemplare dieses Buches

Alle Suchergebnisse ansehen