{"product_id":"solving-business-problems-using-sql-a-definitive-guide-for-beginners-who-want-to-be-proficient-in-database-design-and-writing-sql-9781795478298","title":"Solving Business Problems Using SQL: A Definitive Guide for Beginners Who Want to Be Proficient in Database Design and Writing SQL","description":"\u003cp\u003e • Author(s): Hafizur Rahman\u003cbr\u003e • Publisher: Independently Published\u003cbr\u003e • Publisher Imprint: Independently Published\u003cbr\u003e • BISAC: Computers \u0026amp; Technology\u003c\/p\u003e\u003cp\u003eAre you getting ready for your new job?\u003c\/p\u003e\u003cp\u003e\u003cb\u003eData analysis and presentation is one of the most in-demand job skills right now. Knowing SQL syntaxes and applying them to the real world problems will give you advantage in your career.\u003c\/b\u003e\u003c\/p\u003e\u003cp\u003eWhether you are going to start a new job, or you are a database administrator, developer of web or mobile applications, or you are engaged in a similar business applications role, a good understanding of SQL is essential for communicating with modern database systems. The point is that, if you are working with data, you definitely need to know SQL.\u003c\/p\u003e\u003cp\u003e\u003ci\u003eThere are plenty of resources regarding SQL syntaxes, but it is difficult to find resources that shows how to apply these syntaxes for solving real world business problems. This book is filling this gap.\u003c\/i\u003e\u003c\/p\u003e\u003cp\u003eThis book is for anyone who has little to no knowledge about databases or SQL and would like to become an expert in it. The lessons and practice scenarios in this book are designed to teach a total beginner how to build a complete database from scratch using SQL. For those of you who are not novices, we recommend this book as a valuable resource for: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eApplication developers who want to learn how to write SQL on their own rather than rely on a database developer to do it for them\u003c\/li\u003e\n\u003cli\u003eApplication developers who want to become a solution designer\/architect by becoming proficient in database design and SQL\u003c\/li\u003e\n\u003cli\u003eData analysts, data architects, report analysts or report developers who have to answer a lot of business questions and want to use SQL to answer those questions\u003c\/li\u003e\n\u003cli\u003eApplication users who want to go the extra mile and find answers to their own questions using SQL\u003c\/li\u003e\n\u003cli\u003eAnyone who is an expert in one database tool and wants to become an expert in another database tool\u003c\/li\u003e\n\u003cli\u003eBusiness users or project managers who would like to know how to talk to technical people (such as those mentioned above)\u003c\/li\u003e\n\u003cli\u003eAnyone who can write SQL but doesn't know how to design a database from a business case\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eIn short, if you want to take a more active role in how your database powers your business, the SQL skills taught in this book will give you an advantage in your career.\u003c\/p\u003e\u003cp\u003eYou will learn how to: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCreate data model for your business\u003c\/li\u003e\n\u003cli\u003eConvert data model into physical database\u003c\/li\u003e\n\u003cli\u003eInsert, update and delete data\u003c\/li\u003e\n\u003cli\u003eSolve real world problems related to data\u003c\/li\u003e\n\u003cli\u003eRecover your data from disaster\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003eTable of Contents\u003col\u003e\n\u003cli\u003eA Basic Vocabulary of Database Design \u0026amp; SQL\u003c\/li\u003e\n\u003cli\u003eThe E-commerce Site Case Study\u003c\/li\u003e\n\u003cli\u003eInstalling SQL Tools\u003c\/li\u003e\n\u003cli\u003eConverting a logical data model into a physical database\u003c\/li\u003e\n\u003cli\u003eManipulating Data\u003c\/li\u003e\n\u003cli\u003eRetrieving Static Data without a Table\u003c\/li\u003e\n\u003cli\u003eRetrieving All Rows from a Table\u003c\/li\u003e\n\u003cli\u003eRetrieving subset of rows from a table\u003c\/li\u003e\n\u003cli\u003eSummarizing Retrieved Rows from a Table\u003c\/li\u003e\n\u003cli\u003eRetrieving and Summarizing Data from Multiple Tables Using Inner Join\u003c\/li\u003e\n\u003cli\u003eRetrieving and summarizing data from multiple tables using Outer Join\u003c\/li\u003e\n\u003cli\u003eRetrieving and Summarizing Data from Multiple Tables Using UNION\u003c\/li\u003e\n\u003cli\u003eWorking with Views\u003c\/li\u003e\n\u003cli\u003eComparing Data Between Rows Within the Same Table or Result Set Using Self-Join\u003c\/li\u003e\n\u003cli\u003eWorking with Flow-control Statements\u003c\/li\u003e\n\u003cli\u003eWorking with Stored Procedures\u003c\/li\u003e\n\u003cli\u003eWorking with Triggers\u003c\/li\u003e\n\u003cli\u003eImproving query performance using indexes\u003c\/li\u003e\n\u003cli\u003eBacking up and restoring a database\u003c\/li\u003e\n\u003cli\u003eAppendix A Solutions to the Practice Business Problems\u003c\/li\u003e\n\u003c\/ol\u003e","brand":"Independently Published","offers":[{"title":"Paperback","offer_id":45546982146199,"sku":"9781795478298","price":2199.0,"currency_code":"INR","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9781795478298.webp?v=1767676360","url":"https:\/\/atlanticbooks.com\/products\/solving-business-problems-using-sql-a-definitive-guide-for-beginners-who-want-to-be-proficient-in-database-design-and-writing-sql-9781795478298","provider":"Atlantic Books","version":"1.0","type":"link"}