Adam Brazier joined the Cornell Center for Advanced Computing in 2014 and is a member of the Consulting Group. He has been working in research at Cornell since 2005, first as a Research Associate in the Astronomy Department, and then as an Astronomy Programmer at the National Astronomy and Ionosphere Center and latterly Science Software Architect for the CCAT Telescope project. With a focus on the computational and data-intensive aspects of research at all stages of the research life cycle, Adam is a member of the international North American Nanohertz Observatory for Gravitational Waves (NANOGrav) and the PALFA pulsar survey collaboration.
Data drives many real-world endeavors, which means that storing and accessing the data is foundational to success. Relational databases are an industry-standard data storage mechanism for maintaining data integrity while allowing flexible data retrieval.
You will begin this course by examining the basic table structures that form a relational database. Using the relational database format, you will define connections between your data fields and determine how those can be expressed. You will then practice normalizing a relational database to ensure data integrity and reduce redundancy. As this course concludes, you will use a relational database system called OmniDB along with structured query language (SQL) to retrieve specific information from the database.