ISBN: 9781795478298 - solving business problems using sql: a definitive guide for beginners who want to be proficient in database design and writing sql (5 risultati)

Paperback. Condizione: Very Good. 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 them-Application developers who want to become a solution designer/architect by becoming proficient in database design and SQL-Data 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-Application users who want to go the extra mile and find answers to their own questions using SQL-Anyone who is an expert in one database tool and wants to become an expert in another database tool-Business 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.Table of ContentsLesson 1 A Basic Vocabulary of Database Design & SQLLesson 2 The E-commerce Site Case StudyLesson 3 Installing SQL ToolsLesson 4 Converting a logical data model into a physical databaseLesson 5 Manipulating dataLesson 6 Retrieving Static Data Without a TableLesson 7 Retrieving All Rows from a TableLesson 8 Retrieving subset of rows from a tableLesson 9 Summarizing Retrieved Rows from a TableLesson 10 Retrieving and Summarizing Data from Multiple Tables Using Inner JoinLesson 11 Retrieving and summarizing data from multiple tables using Outer JoinLesson 12 Retrieving and Summarizing Data from Multiple Tables Using UNIONLesson 13 Working with ViewsLesson 14 Comparing Data Between Rows Within the Same Table or Result Set Using Self-JoinLesson 15 Working with Flow-control StatementsLesson 16 Working with Stored ProceduresLesson 17 Working with TriggersLesson 18 Improving query performance using indexesLesson 19 Backing up and restoring a databaseAppendix A Solutions to the Practice Business Problems. …

Condizione: very_good. Book is in very good condition and may include minimal underlining highlighting. The book can also include "From the library of" labels. May not contain miscellaneous items toys, dvds, etc. . We offer 100% money back guarantee and 24 7 customer service.

Paperback. Condizione: Very Good. 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 them-Application developers who want to become a solution designer/architect by becoming proficient in database design and SQL-Data 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-Application users who want to go the extra mile and find answers to their own questions using SQL-Anyone who is an expert in one database tool and wants to become an expert in another database tool-Business 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.Table of ContentsLesson 1 A Basic Vocabulary of Database Design & SQLLesson 2 The E-commerce Site Case StudyLesson 3 Installing SQL ToolsLesson 4 Converting a logical data model into a physical databaseLesson 5 Manipulating dataLesson 6 Retrieving Static Data Without a TableLesson 7 Retrieving All Rows from a TableLesson 8 Retrieving subset of rows from a tableLesson 9 Summarizing Retrieved Rows from a TableLesson 10 Retrieving and Summarizing Data from Multiple Tables Using Inner JoinLesson 11 Retrieving and summarizing data from multiple tables using Outer JoinLesson 12 Retrieving and Summarizing Data from Multiple Tables Using UNIONLesson 13 Working with ViewsLesson 14 Comparing Data Between Rows Within the Same Table or Result Set Using Self-JoinLesson 15 Working with Flow-control StatementsLesson 16 Working with Stored ProceduresLesson 17 Working with TriggersLesson 18 Improving query performance using indexesLesson 19 Backing up and restoring a databaseAppendix A Solutions to the Practice Business Problems. …

Paperback. Condizione: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.

paperback. Condizione: Good. Good reading copy. May have light wear on cover/edges, otherwise good. We've been in business for over 25 years serving thousands of customers worldwide. Your satisfaction is extremely important to us.Established Seller, We Ship Daily! We pack your order with care so that it arrives in great condition.…