We Are Currently Shipping - Free Delivery When You Spend Over €10!

Effective SQL

by John L Viescas | 20 December 2016
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-colour guide provides clear, practical explanations; expert tips; and plenty of usable code. Going far beyond mere syntax, it addresses issues ranging from optimising 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 Analyse 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
€0.00 RRP €33.49
0 Reward Points
Currently out of stock
Delivery in 4 - 7 working

Any purchases for more than €10 are eligible for free delivery anywhere in the UK or Ireland!

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-colour guide provides clear, practical explanations; expert tips; and plenty of usable code. Going far beyond mere syntax, it addresses issues ranging from optimising 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 Analyse 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
Currently out of stock
Delivery in 4 - 7 working
0 Reward Points

Any purchases for more than €10 are eligible for free delivery anywhere in the UK or Ireland!

€0.00 RRP €33.49
Currently out of stock
Delivery in 4 - 7 working
0 Reward Points

Any purchases for more than €10 are eligible for free delivery anywhere in the UK or Ireland!

Product Description

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-colour guide provides clear, practical explanations; expert tips; and plenty of usable code. Going far beyond mere syntax, it addresses issues ranging from optimising 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 Analyse 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

Product Details

Effective SQL

ISBN9780134578897

Format

PublisherADDISON WESLEY (20 December. 2016)

No. of Pages352

Weight448

Language English (United States)

Dimensions 231 x 179 x 12