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.
Course Overview
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.
Key Course Takeaways
- Analyze the structure of a relational database
- Normalize a relational database
- Write queries using SQL
Download Brochure
Fill out the form below to download program information and connect
with us.
Download a Brochure
Not ready to enroll but want to learn more? Download the course brochure to review program details.How It Works
Course Length
2 weeks
Effort
3 to 5 hours of study per week
Format
100% online, instructor-led
Course Author
Adam Brazier
Computational Scientist
Cornell University Center for Advanced Computing
Computational Scientist at Cornell University Center for Advanced Computing
Who Should Enroll
- Data scientists
- Business analysts
- Developers
- Professionals who work with databases or data warehouses
- Marketing analysts
- Career starters
Get It Done
100% Online
100% Online
Our programs are expressly designed to fit the lives of busy professionals like you.
Learn From
cornell's Top Minds
cornell's Top Minds
Courses are personally developed by faculty experts to help you gain today's most in-demand skills.
Power Your
career
career
Cornell's internationally recognized standard of excellence can set you apart.
Stack To A Certificate
Request Information Now by completing the form below.
Act today—courses are filling fast.