{"title":"Stephane Faroult","description":null,"products":[{"product_id":"art-of-sql-book-stephane-faroult-9780596008949","title":"The Art of SQL","description":"Demonstrates that since SQL code may run for 5 to 10 years, and run on different hardware, it must be fast and sound from the start. This book offers SQL best practices and relational theory that force you to focus on strategy rather than specifics.","brand":"WoB","offers":[{"title":"GB \/ NEW \/ GARDNERS","offer_id":49726710448401,"sku":"NGR9780596008949","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49886734188817,"sku":"GOR005011444","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50483708985617,"sku":"CIN0596008945G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50924937511185,"sku":"CIN0596008945VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51004723364113,"sku":"NIN9780596008949","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53258069442833,"sku":"GOR005705934","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0596008945.jpg?v=1751326947"},{"product_id":"sql-success-book-stephane-faroult-9781909765009","title":"SQL Success","description":"SQL Success is about problem-solving in SQL. It bridges the gap between dry and dull database theory books, and developer books that focus on giving recipes without explaining sufficiently the reasons behind the recipes or discussing alternative solutions. Many developers struggle with SQL due to the contrast between the top-down logic of most programming languages and SQL's set-based approach. SQL Success aims to be different. This book is more than syntax examples. SQL Success explains how to use SQL to solve problems, and covers syntax in the process-not as the focus, but as a tool toward accomplishing the objective. SQL Success also shows something that most other books do not: the pitfalls and traps of SQL, a deceptively simple language, and how easy it is to get a query wrong. Written in a conversational way, SQL Success talks about logic more than theory, avoids jargon, and refers to common-sense more than rules. It ignores features that are rarely used and tries to avoid information overload. The intention of SQL Success is not to cover every aspect of all variants of SQL. The goal is to cover everything that is of practical use. That goal is informed by the author's many years of practical experience leading an understanding of what professional developers need to know, the common mistakes that are made, and how those mistakes can be avoided. * Focuses on the practical implications of theory. * Emphasizes accuracy and efficiency. * Teaches how to think SQL, not merely the syntax. * Applies to Oracle, SQL Server, MySQL, PostgreSQL, DB2, and SQLite. * Suitable for college-level database courses, SQL certification preparation, and professionals who want to take their database skills to the next level. * Bolstered by downloadable files and online database with practice exercises at http: \/\/edu.konagora.com. * Includes resources for instructors. About the author: Stephane Faroult has been performing database consultancy work for more than a quarter of a century with major French companies; he taught Computer Science undergraduates a long time ago and many professional developers since then. He is the author of two professional books, The Art of SQL and Refactoring SQL Applications (both by O'Reilly). SQL Success is a prequel to those books, giving readers a strong foundation in SQL.","brand":"WoB","offers":[{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50823169507601,"sku":"CIN1909765007VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51203062006033,"sku":"NIN9781909765009","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52333120946449,"sku":"NLS9781909765009","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1909765007.jpg?v=1750996642"},{"product_id":"refactoring-sql-applications-book-stephane-faroult-9780596514976","title":"Refactoring SQL Applications","description":"What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. \"Refactoring SQL Applications\" provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems.In this work, learn to: determine if and where you can expect performance gains; apply quick fixes, such as limiting calls to the database in stored functions and procedures; refactor tasks, such as replacing application code by a stored procedure, or replacing iterative, procedural statements with sweeping SQL statements; refactor flow by increasing parallelism and switching business-inducted processing from synchronous to asynchronous; refactor design using schema extensions, regular views, materialized views, partitioning, and more; and, compare before and after versions of a program to ensure you get the same results once you make modifications. \"Refactoring SQL Applications\" teaches you to recognize and assess code that needs refactoring, and to understand the crucial link between refactoring and performance. If and when your application bogs down, this book will help you get it back up to speed.","brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":51004763275537,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":51004765995281,"sku":"NIN9780596514976","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":52498901139729,"sku":"GOR009417434","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0596514972.jpg?v=1750784207"}],"url":"https:\/\/www.worldofbooks.com\/en-au\/collections\/author-books-by-stephane-faroult.oembed","provider":"World of Books ","version":"1.0","type":"link"}