{"product_id":"effective-sql","title":"Effective SQL","description":"\u003cstrong\u003e\u003cem\u003eEffective SQL\u003c\/em\u003e\u003c\/strong\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. \u003cbr\u003e\n \u003cbr\u003e\n 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. \u003cul\u003e \u003cli\u003eCraft better logical data models, and fix flawed models \u003c\/li\u003e\n \u003cli\u003eImplement indexes that improve query performance \u003c\/li\u003e\n \u003cli\u003eHandle external data from sources you don’t control \u003c\/li\u003e\n \u003cli\u003eExtract and aggregate the information you need, as efficiently as possible \u003c\/li\u003e\n \u003cli\u003eWrite more flexible subqueries \u003c\/li\u003e\n \u003cli\u003eAnalyse and retrieve metadata using your database platform of choice \u003c\/li\u003e\n \u003cli\u003eUse Cartesian Products and Tally Tables to solve problems you can’t address with conventional JOINs \u003c\/li\u003e\n \u003cli\u003eModel hierarchical data: managing SQL’s tradeoffs and shortcomings \u003c\/li\u003e\n \u003c\/ul\u003e \u003cp\u003e\u003cstrong\u003eThe full text downloaded to your computer\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eWith eBooks you can:\u003c\/p\u003e \u003cul\u003e \u003cli\u003esearch for key concepts, words and phrases \u003c\/li\u003e\n \u003cli\u003emake highlights and notes as you study \u003c\/li\u003e\n \u003cli\u003eshare your notes with friends \u003c\/li\u003e\n \u003c\/ul\u003e \u003cp\u003e\u003cstrong\u003eeBooks \u003c\/strong\u003eare downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps. \u003c\/p\u003e \u003cp\u003eUpon purchase, you'll gain instant access to this eBook.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eTime limit\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eThe \u003cstrong\u003eeBooks\u003c\/strong\u003e products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.\u003c\/p\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":46286508458222,"sku":"9780134579061","price":45.36,"currency_code":"AUD","in_stock":true}],"url":"https:\/\/bookland.com.au\/products\/effective-sql","provider":"Book Land AU","version":"1.0","type":"link"}