Cantitate/Preț
Produs
Total produse
Vezi coșul
SQL Hacks de Andrew Cumming

SQL Hacks

Autor Andrew Cumming, Gordon Russell
en Limba Engleză Paperback – 26 dec 2006
Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book helps you push the limits of traditional SQL to get data effectively from your database. It offers 100 hacks - tips and tools, and practical techniques to address complex data manipulation problems.
Citește tot Restrânge

Preț: 14317 lei

Preț vechi: 17895 lei
-20%

Puncte Express: 215

Carte disponibilă

Livrare economică 25 septembrie-09 octombrie

Livrare prin curier în România Termenul estimat este afișat lângă disponibilitate.
Transport gratuit de la 40000 lei Plată online sau ramburs, în funcție de opțiunile comenzii.
Retur gratuit în 14 zile Comandă securizată și suport în română.
 Adaugă în coș

Wish list
Gift list
Am citit!
Adaugă în listă

Specificații

ISBN-13: 9780596527990
ISBN-10: 0596527993
Pagini: 409
Dimensiuni: 154 x 228 x 32 mm
Greutate: 0.55 kg
Editura: O'Reilly
Locul publicării:United States

Cuprins

Credits;
About the Authors;
Contributors;
Acknowledgments;
Preface;
Why SQL Hacks?;
How to Use This Book;
How This Book Is Organized;
Conventions;
Using Code Examples;
How to Contact Us;
Got a Hack?;
Safari Enabled;
Chapter 1: SQL Fundamentals;
Run SQL from the Command Line;
Connect to SQL from a Program;
Perform Conditional INSERTs;
UPDATE the Database;
Solve a Crossword Puzzle Using SQL;
Don't Perform the Same Calculation Over and Over;
Chapter 2: Joins, Unions, and Views;
Modify a Schema Without Breaking Existing Queries;
Filter Rows and Columns;
Filter on Indexed Columns;
Convert Subqueries to JOINs;
Convert Aggregate Subqueries to JOINs;
Simplify Complicated Updates;
Choose the Right Join Style for Your Relationships;
Generate Combinations;
Chapter 3: Text Handling;
Search for Keywords Without LIKE;
Search for a String Across Columns;
Solve Anagrams;
Sort Your Email;
Chapter 4: Date Handling;
Convert Strings to Dates;
Uncover Trends in Your Data;
Report on Any Date Criteria;
Generate Quarterly Reports;
Second Tuesday of the Month;
Chapter 5: Number Crunching;
Multiply Across a Result Set;
Keep a Running Total;
Include the Rows Your JOIN Forgot;
Identify Overlapping Ranges;
Avoid Dividing by Zero;
Other Ways to COUNT;
Calculate the Maximum of Two Fields;
Disaggregate a COUNT;
Cope with Rounding Errors;
Get Values and Subtotals in One Shot;
Calculate the Median;
Tally Results into a Chart;
Calculate the Distance Between GPS Locations;
Reconcile Invoices and Remittances;
Find Transposition Errors;
Apply a Progressive Tax;
Calculate Rank;
Chapter 6: Online Applications;
Copy Web Pages into a Table;
Present Data Graphically Using SVG;
Add Navigation Features to Web Applications;
Tunnel into MySQL from Microsoft Access;
Process Web Server Logs;
Store Images in a Database;
Exploit an SQL Injection Vulnerability;
Prevent an SQL Injection Attack;
Chapter 7: Organizing Data;
Keep Track of Infrequently Changing Values;
Combine Tables Containing Different Data;
Display Rows As Columns;
Display Columns As Rows;
Clean Inconsistent Records;
Denormalize Your Tables;
Import Someone Else's Data;
Play Matchmaker;
Generate Unique Sequential Numbers;
Chapter 8: Storing Small Amounts of Data;
Store Parameters in the Database;
Define Personalized Parameters;
Create a List of Personalized Parameters;
Set Security Based on Rows;
Issue Queries Without Using a Table;
Generate Rows Without Tables;
Chapter 9: Locking and Performance;
Determine Your Isolation Level;
Use Pessimistic Locking;
Use Optimistic Locking;
Lock Implicitly Within Transactions;
Cope with Unexpected Redo;
Execute Functions in the Database;
Combine Your Queries;
Extract Lots of Rows;
Extract a Subset of the Results;
Mix File and Database Storage;
Compare and Synchronize Tables;
Minimize Bandwidth in One-to-Many Joins;
Compress to Avoid LOBs;
Chapter 10: Reporting;
Fill in Missing Values in a Pivot Table;
Break It Down by Range;
Identify Updates Uniquely;
Play Six Degrees of Kevin Bacon;
Build Decision Tables;
Generate Sequential or Missing Data;
Find the Top n in Each Group;
Store Comma-Delimited Lists in a Column;
Traverse a Simple Tree;
Set Up Queuing in the Database;
Generate a Calendar;
Test Two Values from a Subquery;
Choose Any Three of Five;
Chapter 11: Users and Administration;
Implement Application-Level Accounts;
Export and Import Table Definitions;
Deploy Applications;
Auto-Create Database Users;
Create Users and Administrators;
Issue Automatic Updates;
Create an Audit Trail;
Chapter 12: Wider Access;
Sharing Data Across the Internet;
Allow an Anonymous Account;
Find and Stop Long-Running Queries;
Don't Run Out of Disk Space;
Run SQL from a Web Page;
Colophon;