Skip to Main Content

Advanced guide to database constraints

Last month we covered the five fundamental database constraints: primary keys, unique constraints, foreign keys, not null, and check constraints. This time we'll look more advanced use cases for database constraints, including how to Ensure there's always a child row in parent-child relationships Use foreign keys to ensure there's no gaps or overlaps in start/end dates Check the percentage splits across rows add up to 100

Resources

Featured Speakers

  • Speaker

    Chris Saxon


    Oracle Developer Advocate for SQL

Workshop Info

Session Has Completed - 21 March 2023
1 Hour
Write Great SQL Office Hours
English
SQL

Other Upcoming Sessions