Good enough data modeling

NCEAS

Open Science for Synthesis, Gulf Research Program

July 10-28, 2017

Sponsor: Gulf Research Program, National Academy of Sciences

Learning outcomes

  • Understand basics of relational data models
  • Learn how to design and create effective data tables in SQL
  • Learn to query tables in SQL

Benefits of relational data systems

  • Powerful search and filtering
  • Handle large, complex data sets
  • Enforce data integrity
  • Decrease errors from redundant updates