Primary Keys: High Performance or Failure.

COMING SOON

This eBook will discuss the essentials in defining the primary keys (and all kind of DB keys, actually) for your tables, among them:

• Should I seek for natural keys? What are they?
• Set up the database to generate sequences ?
• Can the primary keys change ?
• How do I handle composite keys ?
• Consequenses of using AutoNumber or sequences ?
• Performance impacts with poorly defined primary keys
• How to enforce referential integrity

and many other issues related to the theme. The eBook steps through the whole analysis and design process for a specific topic, and ends up presenting a complete graphic database model, with all the necessary DDL statements (CREATE TABLE, INDEX, CONSTRAINT and other statements neccessary for creating the database.

(Subscribe to my Newsletter. That way you will be alerted when the eBook releases).

Return from Primary Keys to eBooks