Search the Library Catalogue
Sql Design Patterns (Record no. 578743)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 01797nam a2200193 4500 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 250806b |||||||| |||| 00| 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| ISBN | 9788184044966 |
| Paper back/Hardbound | pbk |
| 041 ## - LANGUAGE CODE | |
| Language code of text/sound track or separate title | eng |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.7585 S |
| Item number | TRO |
| 100 ## - MAIN ENTRY--AUTHOR NAME | |
| Personal name | Tropashko, Vadim |
| 245 ## - TITLE STATEMENT | |
| Title | Sql Design Patterns |
| Sub Title | : expert guide to sql programming |
| Statement of responsibility, etc | Vadim Tropashko |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication | Mumbai |
| Name of publisher | Shroff Publishers & Distributors Pvt. Ltd. |
| Year of publication | c2006 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Number of Pages | ix, 258 p. |
| Dimensions | 23 cm. |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE | |
| Bibliography, etc | Includes index |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc | This indispensable SQL reference book is the first-of- its-kind to leverage the benefits of design patterns to relational database SQL queries. Leveraging on the success of programming design patterns books, SQL guru Vadim Tropashko categorizes and describes all common SQL structures and design patterns. This is an important book for programmers and managers alike. Because SQL is a declarative language there are many ways to write any SQL query and convoluted and clumsy SQL syntax has become a maintenance nightmare. 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. As relational databases structures become more complex, so do their SQL queries. Complex SQL becomes difficult to understand and maintain, especially with novices who pile-on nested subqueries, and all SQL programmer must learn rudimentary SQL theory, which classifies known SQL solutions into common patterns. SQL design patterns greatly improve the quality and productivity of systems development projects because SQL design patterns form a 'best practices' foundation for all relational database queries |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Term | Database Management |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | English Books |
| Withdrawn status | Lost status | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Cost, normal purchase price | Full call number | Accession Number | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Anna Centenary Library | Anna Centenary Library | 3RD FLOOR, A WING | 10.08.2010 | 250.00 | 005.7585 S TRO | 114917 | 06.08.2025 | English Books |