Database Design and SQL
.gif){kind=small}
.gif){kind=small}
|
|
Database Design and SQL |
|
Once the site at the new server is ready, this message will automatically disappear!
Meanwhile, you can see how the move is progressing at the status page.
|
|
|
|
|
|
Introduction Finding other books |
|
Titles: |
Introduction |
|
Of course you can jump into working with databases by getting just one or more books for the database you're going to work with. Unfortunately, unless you already have a considerable background in database work, you'll likely miss something: a book about SQL Server will teach you the SQL dialect for Microsoft's database management system, and maybe some design principles, but you'll be seeing the world through colored glasses and probably completely missing the basics of design as well. On this page about Database Design and SQL you'll find books that are about database design and SQL in general, without dealing with one particular product. Here you'll find the background you need for a solid design and a good grasp of SQL that will allow you to move more easily between different manufacturers' products. |
|
 |
|
Joe Celko's SQL for Smarties: Advanced SQL Programmingby Joe Celko
Not for beginners (as the title suggests), this book is a classic. The book gives special
emphasis to SQL-92 and product-independent techniques that let you optimize performance or achieve highly specialized behavior,
regardless of the RDBMS with which you work. It does not focus on any commercial product, but concentrates on the SQL language itself,
and goes into all aspects of it, with clear examples. A good understanding of standard SQL will help you navigate the
inevitable differences between commercial databases though, discerning the extensions from the standard, and making migration easier.
|
| |
 |
|
The Practical SQL Handbook: Using SQL Variants
|
||
Background |
Although the title suggests an emphasis on different versions of SQL, the emphasis seems to be on
Sybase (and it comes with a time-limited version of that on the Cd-Rom). That doesn't mean this is a bad book though: there must be a
reasons why this is already the 4th edition. More of an introduction than Joe Celko's book.
 |
|
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
|
||
Background
|
Where Joe Celko's book concentrates on the SQL language, this focuses on
more the design aspect. As the title indicates, it's more aimed at non-technical people or beginners. The first half is somewhat slow, but
all the basics are covered. A good book to get started with, and another classic.
Get it!
 |
|
Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design
|
||
Background |
Rather than jumping in with a simple collection of data and a (boring) normalization exercise, this
book starts by explaining datamodeling with an accurate way to model data: Object-Role Modeling (ORM). This technique captures not only the
semantics of the data (in the language of the subject matter expert) but also business rules, and provides a way to ensure the model is
correct. It also maps completely to a normalized model expressed in entity-relationship diagrams or UML. The ORM technique is supported by VisioModeler, freely downloadable from Microsoft (though no longer supported):
see the sidebar.
Finding other books |
|
You can use these search forms to search Amazon.com's or Amazon.co.uk's catalog for books, software, and more. And
|
|
|
|
||||
|
|
let me know
