{"product_id":"139384","title":"SQL tuning for immediate use in business ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jXPBp0X4g7Dq8QtzVM7mz6p1svVhP.png?v=1765074697\" style=\"max-width:100%;max-height:10px\"\u003e\u003c\/div\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\n\n\u003cdiv style=\"width:95%\"\u003e\n\n\u003cdiv style=\"text-align:center;font-size:30px;font-weight:bolder;line-height:1.6em\"\u003e SQL tuning for immediate use in business \u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"border-bottom:1px;border-bottom-style:dotted;border-color:;padding-bottom:20px\"\u003e\u003ccenter\u003e\u003ctable align=\"center\" width=\"100%\"\u003e\u003ctbody style=\"border:0px\"\u003e\n\n\u003ctr\u003e\u003ctd align=\"center\" style=\"line-height:1.2em;text-align:center;font-size:18px;color:black;font-weight:bold;padding-bottom:20px;\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\u003ctr\u003e\u003ctd style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/image.yes24.com\/goods\/102382080\/XL\" style=\"max-width:100%;height:auto\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\u003c\/table\u003e\u003c\/center\u003e\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;{split_style6}padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e Description \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;word-break:break-all;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eBook Introduction\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\u003cdiv\u003e \u003cb\u003eLearn the fundamental principles of SQL tuning and how to tune it for specific situations with case studies.\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e SQL tuning is the most important technique for processing large amounts of data faster and more powerfully.\u003cbr\u003e However, many developers feel burdened and cannot even start because of the difficult content.\u003cbr\u003e This book is composed of intuitive illustrations and examples so that anyone with basic knowledge of SQL can easily understand tuning. \u003cbr\u003eAdditionally, you'll gain hands-on experience analyzing and tuning SQL statements through malicious cases that can arise in real-world work. Readers with little experience writing SQL statements need not worry.\u003cbr\u003e Even a newly hired database developer can learn to create \"good queries\" using this book and apply them to their work right away!\u003c\/div\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cul\u003e\u003cli\u003e You can preview some of the book's contents.\u003cbr\u003e \u003cspan\u003ePreview\u003c\/span\u003e\n\n\u003c\/li\u003e\u003c\/ul\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003eChapter 1.\u003cbr\u003e MySQL and MariaDB Overview\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e 1.1 Status\u003cbr\u003e 1.2 Differences from commercial RDBMS\u003cbr\u003e 1.3 The Importance of MySQL and MariaDB Tuning\u003cbr\u003e 1.4 In conclusion\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter 2. Intuitively Understanding SQL Tuning Terminology\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e 2.1 Physics Engine and Object Terminology\u003cbr\u003e 2.2 Logical SQL Concept Terminology\u003cbr\u003e 2.3 Conceptual Tuning Terminology\u003cbr\u003e 2.4 In conclusion\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter 3. Digging into SQL Tuning's Execution Plans\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e 3.1 Setting up the practice environment\u003cbr\u003e 3.2 Executing the execution plan\u003cbr\u003e 3.3 Profiling\u003cbr\u003e 3.4 In conclusion\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter 4.\u003cbr\u003e Escape the Beginner's Path with Malicious SQL Tuning\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e 4.1 Preparing for SQL Tuning \u003cbr\u003e4.2 Creating Good Queries by Simply Modifying SQL Statements\u003cbr\u003e 4.3 Creating Good Queries by Changing Table Join Settings\u003cbr\u003e 4.4 In conclusion\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter 5.\u003cbr\u003e Become an expert with malicious SQL tuning\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e 5.1 Create good queries by rewriting SQL statements\u003cbr\u003e 5.2 Creating Good Queries with Index Tuning\u003cbr\u003e 5.3 Creating Good Queries with Appropriate Table and Column Properties\u003cbr\u003e 5.4 In conclusion\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eDetailed image\u003c\/b\u003e \u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cdiv\u003e\u003cimg src=\"https:\/\/image.yes24.com\/momo\/TopCate3508\/MidCate002\/350714838.jpg\" border=\"0\" alt=\"Detailed Image 1\"\u003e\u003c\/div\u003e\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003ePublisher's Review\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003eStructure of this book\u003cbr\u003e\u003cbr\u003e Chapter 1: Overview of MySQL and MariaDB\u003c\/b\u003e\u003cbr\u003e We'll explore the background and market share of MySQL and MariaDB, the differences between them and commercial DBMSs, and the importance of tuning MySQL and MariaDB, both open-source DBMSs.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter 2: Intuitively Understanding SQL Tuning Terminology\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e Before performing SQL tuning, learn about the structure of the physics engine, terms related to DB objects, terms related to writing logical queries, and conceptually common tuning terms.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter 3: Understanding SQL Tuning Execution Plans\u003c\/b\u003e\u003cbr\u003e \u003cbr\u003eLet's set up a hands-on environment required to perform SQL tuning.\u003cbr\u003e We'll look at how execution plans are executed to determine the direction of tuning, what the output means, and understand profiling, which is physical time-unit information.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter 4: Escape the Beginner's Path with Malicious SQL Tuning\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e This hands-on exercise involves tuning a given SQL statement by making simple text changes. We'll explore examples of query tuning achieved by changing specific syntax or table join methods in a SQL statement.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter 5: Becoming an Expert with Malicious SQL Tuning\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e This hands-on exercise involves tuning a given SQL statement by rewriting the query or modifying objects using the DDL data definition language. We'll explore examples of query tuning that involve rewriting the entire SQL statement, adjusting indexes, and modifying table and column properties. \u003cbr\u003e\n\n\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e GOODS SPECIFICS\u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;font-size:14px;line-height:1.6em;\"\u003e\n\n \u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e- \u003cstrong\u003eDate of issue:\u003c\/strong\u003e July 1, 2021\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003ePage count, weight, size:\u003c\/strong\u003e 296 pages | 562g | 183*235*20mm\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN13:\u003c\/strong\u003e 9791162244500\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN10:\u003c\/strong\u003e 116224450X \u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cspan\u003e\u003c\/span\u003e\n\n\u003c\/center\u003e\n\n\n\u003c\/center\u003e","brand":"LIBRAIRIE COREENNE","offers":[{"title":"Default Title","offer_id":43893354463274,"sku":"139384","price":31.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/a570055a8752e2c8f4e3fa53bef452f2.jpg?v=1765398060","url":"https:\/\/librairie.coreenne.fr\/en\/products\/139384","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}