embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

Codd’s Rules, Normal Forms, and SQL Anti-Patterns – Recognition & Repair

Speaker:

Ken Clement

Abstract:

In 1970 E.F. Codd presented a seminal set of ideas now known as the Relational Model of Data. Revolutionary for its time, these notions would give rise to many of the database engines of today including SQL Server. Too many software developers and database designers though are unfamiliar with these ideas or do not know how to effectively apply them. This presentation reviews Codd’s rules and the relational normal forms; explains the differences between the relational model of data and the SQL database engines these ideas inspired; identifies some of the SQL anti-patterns that avoidance of these rules and normal forms gives rise to; and discusses both technical and organizational strategies for improving existing applications and their associated database designs and implementations.

Bio:

Ken Clement has been an I.T. professional for over three decades in roles including software and database design, development, analysis, architecture, and management. He has successfully applied these technologies to diverse problem domains and in the process acquired a firm practical and theoretical understanding of the often opposing developer and database professional perspectives. While he has worked with several database technologies, the most notable is SQL Server which he has been involved with practically from its inception. He has over the years been a technical presenter at various conferences.

Recorded At:

SQL Saturday Houston 2016

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>