Solving Business Problems Using SQL

Are you getting ready for your new job? Data 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… Lue lisää Are you getting ready for your new job? Data 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. Whether 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. There 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. This 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: Application developers who want to learn how to write SQL on their own rather than rely on a database developer to do it for themApplication developers who want to become a solution designer/architect by becoming proficient in database design and SQLData 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 questionsApplication users who want to go the extra mile and find answers to their own questions using SQLAnyone who is an expert in one database tool and wants to become an expert in another database toolBusiness users or project managers who would like to know how to talk to technical people (such as those mentioned above)Anyone who can write SQL but doesn't know how to design a database from a business caseIn 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. You will learn how to: Create data model for your businessConvert data model into physical databaseInsert, update and delete dataSolve real world problems related to dataRecover your data from disasterTable of ContentsA Basic Vocabulary of Database Design & SQLThe E-commerce Site Case StudyInstalling SQL ToolsConverting a logical data model into a physical databaseManipulating DataRetrieving Static Data without a TableRetrieving All Rows from a TableRetrieving subset of rows from a tableSummarizing Retrieved Rows from a TableRetrieving and Summarizing Data from Multiple Tables Using Inner JoinRetrieving and summarizing data from multiple tables using Outer JoinRetrieving and Summarizing Data from Multiple Tables Using UNIONWorking with ViewsComparing Data Between Rows Within the Same Table or Result Set Using Self-JoinWorking with Flow-control StatementsWorking with Stored ProceduresWorking with TriggersImproving query performance using indexesBacking up and restoring a databaseAppendix A Solutions to the Practice Business Problems