SQL Hacks

3,13 valoración promedio
( 31 valoraciones por GoodReads )
 
9780596527990: SQL Hacks
From the Publisher:

Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:

  • Wrangle data in the most efficient way possible
  • Aggregate and organize your data for meaningful and accurate reporting
  • Make the most of subqueries, joins, and unions
  • Stay on top of the performance of your queries and the server that runs them
  • Avoid common SQL security pitfalls, including the dreaded SQL injection attack

Let SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.

About the Author:

Andrew Cumming is the Zoo Keeper at http://sqlzoo.net . He keeps a collection of tame SQL engines and presents these to the public. He cares for these beasts, protecting them from the abuse inflicted by SQL learners, and protecting SQL learners from the injuries that the wild engines can inflict. But mostly he shovels manure out the cages and hoses them down every now and then. Andrew also teaches at Napier University in Edinburgh, Scotland.

Dr. Gordon Russell is a Computing lecturer in Napier University, Scotland. He teaches databases, Linux, and networking. He also builds educational websites, concentrating on technology-driven online learning environments. These include db.grussell.org, whose claim-to-fame is its automatic checking of SQL assessments, and http://linuxzoo.net, which offers online users root free access to Linux servers. But without database technology to support these sites, even he would be lost.

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

Andrew Cumming; Gordon Russell
Editorial: O'Reilly Media (2006)
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos Paperback Cantidad: 1
Librería
Southern Maryland Books
(Waldorf, MD, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2006. Paperback. Estado de conservación: New. ** WE SHIP DAILY (Mon-Fri) ** Free Tracking Information. Nº de ref. de la librería mon0000050619

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 11,55
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,73
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Andrew Cumming; Gordon Russell
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos Paperback Cantidad: > 20
Impresión bajo demanda
Librería
BargainBookStores
(Grand Rapids, MI, Estados Unidos de America)
Valoración
[?]

Descripción Paperback. Estado de conservación: New. This item is printed on demand. Item doesn't include CD/DVD. Nº de ref. de la librería 975604

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 14,83
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,73
A Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Andrew Cumming; Gordon Russell
Editorial: O'Reilly Media
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos PAPERBACK Cantidad: > 20
Librería
Mediaoutlet12345
(Springfield, VA, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. PAPERBACK. Estado de conservación: New. 0596527993 *BRAND NEW* Ships Same Day or Next!. Nº de ref. de la librería SWATI2122347705

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 15,23
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,73
A Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Andrew Cumming; Gordon Russell
Editorial: O'Reilly Media (2006)
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos Tapa blanda Cantidad: 1
Librería
Book Deals
(Lewiston, NY, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2006. Estado de conservación: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Credits Preface Chapter 1. SQL Fundamentals 1. Run SQL from the Command Line 2. Connect to SQL from a Program 3. Perform Conditional INSERTs 4. UPDATE the Database 5. Solve a Crossword Puzzle Using SQL 6. Don't Perform the Same Calculation Over and Over Chapter 2. Joins, Unions, and Views 7. Modify a Schema Without Breaking Existing Queries 8. Filter Rows and Columns 9. Filter on Indexed Columns 10. Convert Subqueries to JOINs 11. Convert Aggregate Subqueries to JOINs 12. Simplify Complicated Updates 13. Choose the Right Join Style for Your Relationships 14. Generate Combinations Chapter 3. Text Handling 15. Search for Keywords Without LIKE 16. Search for a String Across Columns 17. Solve Anagrams 18. Sort Your Email Chapter 4. Date Handling 19. Convert Strings to Dates 20. Uncover Trends in Your Data 21. Report on Any Date Criteria 22. Generate Quarterly Reports 23. Second Tuesday of the Month Chapter 5. Number Crunching 24. Multiply Across a Result Set 25. Keep a Running Total 26. Include the Rows Your JOIN Forgot 27. Identify Overlapping Ranges 28. Avoid Dividing by Zero 29. Other Ways to COUNT 30. Calculate the Maximum of Two Fields 31. Disaggregate a COUNT 32. Cope with Rounding Errors 33. Get Values and Subtotals in One Shot 34. Calculate the Median 35. Tally Results into a Chart 36. Calculate the Distance Between GPS Locations 37. Reconcile Invoices and Remittances 38. Find Transposition Errors 39. Apply a Progressive Tax 40. Calculate Rank Chapter 6. Online Applications 41. Copy Web Pages into a Table 42. Present Data Graphically Using SVG 43. Add Navigation Features to Web Applications 44. Tunnel into MySQL from Microsoft Access 45. Process Web Server Logs 46. Store Images in a Database 47. Exploit an SQL Injection Vulnerability 48. Prevent an SQL Injection Attack Chapter 7. Organizing Data 49. Keep Track of Infrequently Changing Values 50. Combine Tables Containing Different Data 51. Display Rows As Columns 52. Display Columns As Rows 53. Clean Inconsistent Records 54. Denormalize Your Tables 55. Import Someone Else's Data 56. Play Matchmaker 57. Generate Unique Sequential Numbers Chapter 8. Storing Small Amounts of Data 58. Store Parameters in the Database 59. Define Personalized Parameters 60. Create a List of Personalized Parameters 61. Set Security Based on Rows 62. Issue Queries Without Using a Table 63. Generate Rows Without Tables Chapter 9. Locking and Performance 64. Determine Your Isolation Level 65. Use Pessimistic Locking 66. Use Optimistic Locking 67. Lock Implicitly Within Transactions 68. Cope with Unexpected Redo 69. Execute Functions in the Database 70. Combine Your Queries 71. Extract Lots of Rows 72. Extract a Subset of the Results 73. Mix File and Database Storage 74. Compare and Synchronize Tables 75. Minimize Bandwidth in One-to-Many Joins 76. Compress to Avoid LOBs Chapter 10. Reporting 77. Fill in Missing Values in a Pivot Table 78. Break It Down by Range 79. Identify Updates Uniquely 80. Play Six Degrees of Kevin Bacon 81. Build Decision Tables 82. Generate Sequential or Missing Data 83. Find the Top n in Each Group 84. Store Comma-Delimited Lists in a Column 85. Traverse a Simple Tree 86. Set Up Queuing in the Database 87. Generate a Calendar 88. Test Two Values from a Subquery 89. Choose Any Three of Five Chapter 11. Users and Administration 90. Implement Application-Level Accounts 91. Export and Import Table Definitions 92. Deploy Applications 93. Auto-Create Database Users 94. Create Users and Administrators 95. Issue Automatic Updates 96. Create an Audit Trail<br/. Nº de ref. de la librería ABE_book_new_0596527993

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 19,05
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Andrew Cumming; Gordon Russell
Editorial: O Reilly Media, Inc, USA, United States (2006)
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos Paperback Cantidad: 1
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2006. Paperback. Estado de conservación: New. 231 x 150 mm. Language: English . Brand New Book. Whether you re running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. It offers 100 hacks - unique tips and tools - that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You ll find practical techniques to address complex data manipulation problems. Learn how to: wrangle data in the most efficient way possible; aggregate and organize your data for meaningful and accurate reporting; make the most of subqueries, joins, and unions; stay on top of the performance of your queries and the server that runs them; and, avoid common SQL security pitfalls, including the dreaded SQL injection attack. Let SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you. Nº de ref. de la librería AAH9780596527990

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 19,43
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Andrew Cumming; Gordon Russell
Editorial: O'Reilly Media (2006)
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos Paperback Cantidad: 1
Librería
Irish Booksellers
(Rumford, ME, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2006. Paperback. Estado de conservación: New. book. Nº de ref. de la librería 0596527993

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 22,32
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Andrew Cumming; Gordon Russell
Editorial: O Reilly Media, Inc, USA, United States (2006)
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos Paperback Cantidad: 1
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2006. Paperback. Estado de conservación: New. 231 x 150 mm. Language: English . Brand New Book. Whether you re running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. It offers 100 hacks - unique tips and tools - that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You ll find practical techniques to address complex data manipulation problems. Learn how to: wrangle data in the most efficient way possible; aggregate and organize your data for meaningful and accurate reporting; make the most of subqueries, joins, and unions; stay on top of the performance of your queries and the server that runs them; and, avoid common SQL security pitfalls, including the dreaded SQL injection attack. Let SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you. Nº de ref. de la librería AAH9780596527990

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 23,86
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Andrew Cumming; Gordon Russell
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos Cantidad: 5
Librería
Chiron Media
(Wallingford, Reino Unido)
Valoración
[?]

Descripción Estado de conservación: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Nº de ref. de la librería NU-ING-00036070

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 20,90
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,49
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

9.

Andrew Cumming; Gordon Russell
Editorial: O'Reilly Media (2006)
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos Paperback Cantidad: 1
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2006. Paperback. Estado de conservación: New. 1. Nº de ref. de la librería DADAX0596527993

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 20,69
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,73
A Estados Unidos de America
Destinos, gastos y plazos de envío

10.

Andrew Cumming; Gordon Russell
ISBN 10: 0596527993 ISBN 13: 9780596527990
Nuevos Paperback Cantidad: 1
Librería
Grand Eagle Retail
(Wilmington, DE, Estados Unidos de America)
Valoración
[?]

Descripción 2006. Paperback. Estado de conservación: New. 153mm x 25mm x 228mm. Paperback. Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. It offer.Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 386 pages. 0.544. Nº de ref. de la librería 9780596527990

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 25,05
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda