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.
Relational databases are workhorses which form the backbone for much of the information we find at our fingertips on the internet. In this course, you will learn to create and modify databases using OmniDB and structured query language (SQL) to import data, create tables, and modify fields. You will also practice cleaning data to maintain your database and ensure that it provides accurate information. As the course progresses, you will identify questions you want answered and practice translating those questions into SQL. You will also examine different forms of outputting data from a database, including outputting to a program or text file and outputting CSV text.
You are required to have completed the following course or have equivalent experience before taking this course:
- Querying Relational Databases
Key Course Takeaways
- Create a database with SQL
- Load a database and clean data
- Turn a question about data into an SQL query
- Output data
Download a BrochureNot ready to enroll but want to learn more? Download the course brochure to review program details.
How It Works
Who Should Enroll
- Data scientists
- Business analysts
- Professionals who work with databases or data warehouses
- Marketing analysts
- Career starters