|
|
| Book details / order |
| SQL HACKS |
Whether you need to merely sort the data as it comes out of the database or perform complex calculations, sql hacks reveals the secrets that database experts use to dig through their data and get the answers they need. it includes 100 hacks for sorting, sifting, shuffling, and pushing the limits of traditional sql.
you?ll learn how to:
* send sql commands to your database from the command line and programs
* use advanced join, filter, and grouping techniques to get data ready for reports
* solve puzzles using sql
* perform complicated searches and sorts on strings, dates, and more
* set up your transactions so that users don?t collide with one another
* manage users and audit the changes they make to the database
* minimize cpu and network overhead with efficient alternatives to common sql operations
even if you?ve been using the databases covered in this book?access, mysql, sql server, oracle, and postgresql?for years, sql hacks will make sure you never look at your trusty select, insert, update, and delete statements in the same way again.
Author : Andrew cumming, gordon russell
Publication : O'reilly
Isbn : 9788184042207
Store book number : 104
NRS 640.00
|
 |
|
|
|
|
|
|
|
| |
|
|