When
5:00 PM Saturday
Where
8402
Silicon Valley Code Camp : October 11th and 12th 2014session
Intro to Relational Database Design & Entity-Relationship Diagrams
Mark will cover the basics of designing and setting up a database schema.
About This Session
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; 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.Time: 5:00 PM Saturday Room: 8402
The Speaker(s)
Mark Abramson
Founder & CEO , Printform Corporation
Mark is a globally recognized expert on digital printing for industrial and packaging applications.