May 8, 2013 · 6:30 PM
This location is shown only to members
Speaker Mark Abramson of Forward Thought
With so 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.
Mark will cover the basics of designing and setting up a database schema. He'll define some common business scenarios, build out some tables, create relationships, and then demo usage, pitfalls, problems and design tradeoffs.
You'll see real-life examples and issues such as:
- Creating a new table
- Choosing data types
- Normalization (and when to denormalize)
- Types of relationships
- Referential integrity
- Join/relationship tables
- 1-to-many, many-to-many
- How to actually use these structures in your application
While the examples will focus on SQL Server, the techniques and SQL code will work for virtually any SQL database. There will be discussion of various commercial and open source tools to streamline your work.
Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder of Medicine of Cycling and Vice Chairman of USA Cycling. A veteran of both early-stage startups and enterprise software projects, he has particular technical expertise in complex global supply chains for high-growth companies. He's also a dad, runs the Microsoft BizSparkSF group for Bay Area startups, collects antique woodworking machines and mentors on Lean Startup methods.