Beginning SQL Queries: From Novice to Professional

Купить бумажную книгу и читать

Автор: Clare Churcher

Название: Beginning SQL Queries: From Novice to Professional

Издательство: Apress

Год: 2008

Формат: PDF в RAR+5%

Размер: 6.94 МБ

ISBN: 978-1-4302-0550-0

Язык: Английский

Качество: отличное

This book is for anyone who has a well-designed relational database and needs to extract

some information from it. You might have noticed in the previous sentence that the database

must be “well designed.” I can’t overemphasize this point. If your database is badly

designed, it will not be able to store accurate and consistent data, so the information your

queries retrieve will always be prone to inaccuracies. If you are looking to design a database

from scratch, you should read my first book, Beginning Database Design (Apress, 2007).

The final chapter of this book outlines a few common design problems you are likely

to come across and gives some advice about how to mitigate the impact or correct

the problem.

For this book, you do not need any theoretical knowledge of relational theory, as I will

explain the relevant issues as they come up. The first chapter gives a brief overview of

relational database theory, but it will help if you have had some experience working with

databases with a few or more tables.