Session Details

Introduction to Database Design with Entity Relationship (ER) Diagrams  

Level :
Beginner
Date :
9:15 AM Sunday
Room :
5501
Interested : (-) - Registered : (-)

Presentation

<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>

The Speaker(s)

img

Mark Abramson

Mark Abramson is Founder & CEO of Printform Corporation. He has particular technical expertise in digital workflow, industrial printing and complex global supply chains for high-growth companies. He's also a dad, collects antique woodworking machines and mentors on Lean Startup methods.
  • Not Interested
  • Interested
  • Attending

SPONSORS List