Clothier B., Steele D., Viescas J. - Effective SQL: 61 Specific Ways to Write Better SQL [2017, PDF/EPUB/MOBI/AZW3, ENG]

Reply to topic
DL-List and Torrent activity [Update пиров]
Size:  91 MB   |    Registered:  2 years 4 months   |    Completed:  0 times

Seeder not seen: Never

Author Message


Post 24-May-2017 23:13


Effective SQL: 61 Specific Ways to Write Better SQL
Год издания: 2017
Автор: Clothier B., Steele D., Viescas J.
Издательство: Addison-Wesley
ISBN: 978-0-13-457889-7
Язык: Английский
Формат файла: PDF/EPUB/MOBI/AZW3
Качество: Распознанный текст без ошибок (OCR)
Количество страниц: 546
Описание: Effective SQL brings together practical solutions and insights so you can solve complex problems with SQL and design databases that simplify data management in the future. It’s the only modern book that brings together advanced best practices and realistic example code for all of these versions of SQL: IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL.
Drawing on their immense experience as world-class database consultants and instructors, the authors identify 61 proven approaches to writing better SQL. Wherever SQL versions vary, the authors illuminate the key nuances, so you can get the most out of whatever version you prefer. This full-color guide provides clear, practical explanations; expert tips; and plenty of usable code. Going far beyond mere syntax, it addresses issues ranging from optimizing database designs to managing hierarchies and metadata. If you already know SQL’s basics, this guide will help you become a world-class SQL problem-solver.
● Craft better logical data models, and fix flawed models
● Implement indexes that improve query performance
● Handle external data from sources you don’t control
● Extract and aggregate the information you need, as efficiently as possible
● Write more flexible subqueries
● Analyze and retrieve metadata using your database platform of choice
● Use Cartesian Products and Tally Tables to solve problems you can’t address with conventional JOINs
● Model hierarchical data: managing SQL’s tradeoffs and shortcomings

Примеры страниц

Torrent: Registered ·  [ 2017-05-24 23:12 ] ·  8c892bc71ede71980cb8986a756646b173c064ca

15 KB

Status: checked
Completed: 0 times
Size: 91 MB
(Votes: 0)
Say thanks: 0  Thanks
Похожие темы
[Profile]    [PM]
Display posts from previous:    
Reply to topic

The time now is: Today 06:55

All times are GMT + 7 Hours

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum