Silicon Valley Code Camp : October 5th and 6th 2013
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.
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.
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.
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;
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.
In this session we will dive in deeper and work on specific challenges that crop up with database designs. This session will be interactive and will benefit from your specific database-related issues. Please hit me on Twitter (@mark__a) or use the "email the speaker" button with your challenges and we'll do our best to cover some approaches for you in the class. Need the basics? Check out my other session on "Intro to DB Design."