Skip to Main Content

How should we design a database? You decide!

When creating database tables there are lots of decisions you need to make. For example, should you use: Surrogate or natural primary keys? Check constraints or lookup tables for status codes? Store or calculate derived values? Each choice affects the table structure and the queries you'll write to fetch data. Join this interactive session to see how these decisions affect your schema. Vote for your preferred option for each choice while we'll discuss their trade-offs. We'll then create the tables using the most popular answer to each question. What will the final schema look like? You decide!

Resources

Featured Speakers

  • Speaker

    Chris Saxon


    Oracle Developer Advocate for SQL

Workshop Info

Session Has Completed - 15 November 2022
1 Hour
Write Great SQL Office Hours
English
SQL

Other Upcoming Sessions