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 disaster
Table of ContentsA Basic Vocabulary of Database Design & SQLThe E-commerce Site Case StudyInstalling SQL ToolsConverting a logical data model into a physical databaseManipulat