{"product_id":"effective-sql-61-specific-ways-to-write-better-sql-paperback","title":"Effective SQL: 61 Specific Ways to Write Better SQL (Paperback)","description":"\u003cp\u003e\u003ci style=\"font-family: \" amazon ember arial sans-serif font-size:\u003e\u003cb\u003eEffective SQL\u003c\/b\u003e\u003c\/i\u003e\u003cspan style=\"font-family: \" amazon ember arial sans-serif font-size:\u003e 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.\u003c\/span\u003e\u003cbr style=\"font-family: \" amazon ember arial sans-serif font-size:\u003e\u003cbr style=\"font-family: \" amazon ember arial sans-serif font-size:\u003e\u003cspan style=\"font-family: \" amazon ember arial sans-serif font-size:\u003eDrawing 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.\u003c\/span\u003e\u003c\/p\u003e\u003cul style=\"margin-top: 0px; margin-right: 0px; margin-left: 20px; padding-right: 0px; padding-left: 0px; font-family: \" amazon ember arial sans-serif font-size:=\"\" margin-bottom:=\"\"\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eCraft better logical data models, and fix flawed models\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eImplement indexes that improve query performance\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eHandle external data from sources you don’t control\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eExtract and aggregate the information you need, as efficiently as possible\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eWrite more flexible subqueries\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eAnalyze and retrieve metadata using your database platform of choice\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eUse Cartesian Products and Tally Tables to solve problems you can’t address with conventional JOINs\u003c\/li\u003e\n\u003cli style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003eModel hierarchical data: managing SQL’s tradeoffs and shortcomings.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003e \u003c\/p\u003e\u003cp style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003e\u003cstrong\u003eAbout The Author\u003c\/strong\u003e\u003c\/p\u003e\u003cp style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"box-sizing: border-box; font-weight: 700; color: rgb(15, 17, 17); font-family: \" amazon ember arial sans-serif font-size:\u003eJohn L. Viescas\u003c\/span\u003e\u003cspan style=\"color: rgb(15, 17, 17); font-family: \" amazon ember arial sans-serif font-size:\u003e is an independent database consultant with more than 45 years of experience. He began his career as a systems analyst, designing large database applications for IBM mainframe systems. He spent six years at Applied Data Research in Dallas, Texas, where he directed a staff of more than 30 people and was responsible for research, product development, and customer support of database products for IBM mainframe computers. While working at Applied Data Research, John completed a degree in business finance at the University of Texas at Dallas, graduating cum laude.\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003e \u003c\/p\u003e\u003cp style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"box-sizing: border-box; font-weight: 700; color: rgb(15, 17, 17); font-family: \" amazon ember arial sans-serif font-size:\u003eDouglas J. Steele\u003c\/span\u003e\u003cspan style=\"color: rgb(15, 17, 17); font-family: \" amazon ember arial sans-serif font-size:\u003e has been working with computers, both mainframe and PC, for almost 45 years. (Yes, he did use punch cards in the beginning!) He worked for a large international oil company for more than 31 years before retiring in 2012. Databases and data modeling were a focus for most of that time, although he finished his career by developing the SCCM task sequence to roll Windows 7 out to over 100,000 computers worldwide.\u003c\/span\u003e\u003c\/p\u003e\u003cp style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003e \u003c\/p\u003e\u003cp style=\"margin: 0px 0px 0px 20px; overflow-wrap: break-word;\"\u003e\u003cspan style=\"box-sizing: border-box; font-weight: 700; color: rgb(15, 17, 17); font-family: \" amazon ember arial sans-serif font-size:\u003eBen G. Clothier\u003c\/span\u003e\u003cspan style=\"color: rgb(15, 17, 17); font-family: \" amazon ember arial sans-serif font-size:\u003e is a Solution Architect with IT Impact, Inc., a premier Access and SQL Server development shop based in Chicago, Illinois\u003c\/span\u003e\u003c\/p\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":50506198745158,"sku":"9780134578897","price":3767.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0754\/2797\/1142\/files\/9780134578897.jpg?v=1790322807","url":"https:\/\/cb-india.com\/products\/effective-sql-61-specific-ways-to-write-better-sql-paperback","provider":"Computer Bookshop (India) Pvt Ltd","version":"1.0","type":"link"}