Sub-Total: $0.00
Testing data in your new database design
Learn how to strengthen your database design with testing and referential integrity.
In this Data Survival Skills session, Robin shows why every database—no matter how small the budget—needs testing at each stage. Using a volunteer management system as the example, you’ll see how to set up relational tables for partners, events, and volunteers, and then enforce referential integrity to prevent bad data from creeping in. By testing real scenarios—like trying to add events without valid partner records—you’ll understand how guardrails protect data quality and ensure reliable relationships between tables. With practical demos in Access and SQL, Robin emphasizes that testing isn’t optional—it’s the key to designing databases that remain accurate, consistent, and trustworthy.
#DatabaseDesign #SQLServer #ReferentialIntegrity #DataSkills #AccessDatabase #DataManagement #Productivity
If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.