<p><b>Developer working with a database? Need to build a data-rich application but not sure how to design your DB? Did someone hand you a legacy DB app and now you have to modify the database schema?</b></p> <br/> <p>This session will cover the basics of designing and setting up a database schema. We'll start with defining a few common business scenarios, build out some tables, create relationships and then go through usage, pitfalls, problems and design tradeoffs. As a veteran of many, many database-driven projects for consumer desktop software applications, websites and enterprise software systems, the database design plays a crucial role in the success of your project.</p> <br/> <p>We'll run through some real-life examples and issues such as:</p> <ul> <li>Creating a new table</li> <li>Choosing data types</li> <li>Normalization (and when to denormalize)</li> <li>Types of relationships</li> <li>Referential integrity</li> <li>join/relationship tables</li> <li>1-to-many, many-to-many</li> <li>...and then how to actually use these structures in your application</li> </ul> <br/> <p>Note: while the examples will focus on SQL Server, the techniques and SQL code will work for virtually any SQL database.</p> <br/> <p><b>Please use the "Email Speaker" button to send me your questions, where you're at with DB design now, or any other material so I can tailor the presentation to your needs!</b></p>