SQLBits 2012
Lego Sets: Relational Building Blocks
Introductory Relational Theory Using Lego Bricks to Model Data and Set Operations
Do your eyes glaze over at the mention of tuples, domains, or even basic SQL terms? Have you moved to SQL Server from MS Access, or Excel, or other non-relational database products? This session will help explain the basics of set theory and relational theory using actual Lego blocks. We will illustrate terms and concepts such as joins, unions, and set-based operations, and how you can translate them into actual SQL. If you're an absolute beginner to SQL, or feel overwhelmed by the baggage of computer data models, or would just like to play with Legos, you'll both enjoy and learn something during this session.
Speakers
Rob Volk's previous sessions
Thats So Metadata: Discover Your Database From the Inside
Learn about the metadata features in SQL Server that describe your database and how they can make documentation, tuning, and maintenance much easier.
Tame Your Unruly Data...With Constraints!
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
Revenge: The SQL!
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
Lego Sets: Relational Building Blocks
Introductory Relational Theory Using Lego Bricks to Model Data and Set Operations