SQL Design Patterns: The Expert Guide to SQL Programming

by Vadim Tropashko

This indispensable SQL reference book is the first of its kind to leverage the benefits of design patterns to relational database SQL queries; all common SQL structures and design patterns are clearly categorized and described. Emphasizing the theoretical foundation for almost every type of SQL query problem, accompanying figures are included to help visualize the problem. Because SQL is a declarative language there are many ways to write any SQL query and professional database programmers must understand the correct way to write SQL for complicated database queries, and managers must institute formal SQL coding standards to improve productivity and maintainability. The SQL design patterns in this resource greatly improve the quality and productivity of systems development projects by forming a "best practices" foundation for all relational database queries.

Genres: Programming

256 pages, Paperback

First published April 1, 2007

Reviews

[Corrado Piola · Rating 5 out of 5]

A mathematical approach to SQL language. I think you'll appreciate this book if you already have some advanced knowledge of SQL language (hierarchical queries, pivoting, advanced grouping, etc...) and some mathematical concepts (Trees, Graphs, Matrices, Logarithms, Polynomial expressions, etc...)
All SQL is Oracle oriented.
Well done, really.

[Shailesh Singh]

want to learn new things

[Максим Помидоров]

gg